![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle Apps
文章平均质量分 52
orapeasant
这个作者很懒,什么都没留下…
展开
-
11i Notes-Profile Options
1. SQL Validation syntax:SQL=”SQL select statement”COLUMN=”column1(length), column2(length),...”[TITLE=”{title text|*application shortname:message name}”][HEADING=”{heading1(length), heading2(length),原创 2005-08-18 10:39:00 · 971 阅读 · 0 评论 -
Index organized table and redo log it genereates
Today, OPS team raised an issue related to a program using IOT. The program generated too many archive logs thus it took more time to FTP archive logs to our DR server and apply them. 1~4 hours lag we原创 2008-10-14 13:30:00 · 522 阅读 · 0 评论 -
Note: In form builder, triggers 'execution hierarchy' caused funny issue in enter-query mode.
Today, Im almost tortured by the weird form behavior in enter-query mode in one of my custom forms. Yesterday, I dont remeber exactly when, the block could still turn to light-blue when I hit F11原创 2008-10-10 18:17:00 · 881 阅读 · 0 评论 -
Using lp to test report printing in Unix for Apps
Days ago, user requested me to change the layout to fit for her new pre-printed paper. She is in Ireland and thousands kilometers away from Singapore. Theres no way for me to get that pre-printed pap原创 2008-10-08 19:26:00 · 614 阅读 · 0 评论 -
Production Issue: adjusted_amount_per_pqty column of oe_price_adjustments table contains strange amount
Yesterday user reported they had wrong discount and unit price in one of the SO extraction program. After checking the oe_price_adjustments table, I found adjusted_amount_per_pqty, the column I used t原创 2008-10-08 15:00:00 · 8670 阅读 · 0 评论 -
Production Issue: Drop ship order line workflow issue
Recently I closed a case of troubleshooting work flow issue in a drop ship order line. The order went through an obsolete workflow and get invoiced and closed while some holds exist, which is absolut原创 2008-10-06 15:22:00 · 1010 阅读 · 0 评论 -
Troubleshooting EPSON dot matrix printing issue in Apps
Recently I encountered an issue to print character report to EPSON LQ2080 dot matrix printer. Wheneven the printer is off and on, in the first print, it prints funny characters at page 7. To figure o原创 2008-10-06 15:00:00 · 1177 阅读 · 0 评论 -
Interesting URLs in Oracle Application 11i.
:/servlets/oracle.apps.icx.common.SystemInfoTest">http://:/servlets/oracle.apps.icx.common.SystemInfoTest:/servlets/IsItWorking">http://:/servlets/IsItWorking:/servlets/oracle.apps.icx.common.Connect原创 2008-10-16 18:43:00 · 641 阅读 · 0 评论 -
How to get request_id of previous request in a request set?
FUNCTION get_prev_req_id(p_conc_program IN VARCHAR2) RETURN VARCHAR2 IS l_parent_req_id NUMBER; l_request_id NUMBER; BEGIN SELECT parent_request_id INTO l_parent_r原创 2008-01-11 13:11:00 · 2095 阅读 · 0 评论 -
How to constraint user processing but allow API when processing constraints are enabled
Last week, our functional guy raised a requirement, our price in sales order should only be modified by a customized interface, user are not allowed to change price. The functional guy created a proce原创 2008-11-02 08:57:00 · 807 阅读 · 0 评论 -
OM: Order Import using OE_ORDER_PUB.PROCESS_ORDER
This article discusses som tips in importing sales order using oe_order_pub.process_order. The example is to import sales order with price adjustment.1. to update price_adjustments, the existing pri原创 2008-11-04 09:37:00 · 2992 阅读 · 0 评论 -
APPS:How to view the concurrent request output of other users
Basicaly, as Oracle documents, we can profile option "Concurrent:Report Access Level" to Responsiblity instead of default value User, then , user can view the request output of other users login as原创 2008-12-17 09:25:00 · 1325 阅读 · 0 评论 -
APPS:Bother, why password reuse is not allowed
In our dev/testing system, it requires to use different password each time changing password. This check is done in FND_WEB_SEC package, it checks fnd_user_preferences table using following sql:fnd_原创 2008-12-09 14:53:00 · 907 阅读 · 0 评论 -
FND:How to create a link in IE favorite to directly login into apps
Im lazy to type username and password whenever I open my testing 11i system. So I simply check the html source of the login page and get the submit detail of the login button, then following url can原创 2008-12-03 14:07:00 · 904 阅读 · 0 评论 -
QP:Error in formula process...
This error annoyed me for a whole week. We have only one formula set up in 2004, and there are a modifier for different OU, how come the error never occured these years. The formula has 2 steps 1 and原创 2008-11-28 17:31:00 · 1106 阅读 · 0 评论 -
OM:Manual Transaction in work flow
In Order management, sometimes, we need to progress order, one example is Schedule - Eligible. How is this implemented in Workflow? Basically, in Oracle workflow builder, we can see order goes to "原创 2009-01-02 15:49:00 · 1401 阅读 · 0 评论 -
How "Copy File" works in 'View Output" screen in Oracle Apps
Usualy, when we submit a concurrent report and it finishes running, we click Output button to view the output and click Tools->Copy file to copy it to browser window and thus save to local disk.原创 2008-11-11 13:42:00 · 2791 阅读 · 0 评论 -
Several interesting packages in Oracle apps
select distinct name from all_source where name LIKE ORACLE% wfa_html BIS_RG_SCHEDULER_PVT原创 2008-11-07 14:32:00 · 924 阅读 · 1 评论 -
OM: Good informational package in OM: OE_MSG_PUB
Last week I started to working on an order import pragram. A sample program in our live system does similar thing but it has no price adjustment etc. To have more information when importing the order,原创 2008-11-04 09:47:00 · 3287 阅读 · 0 评论 -
Carrying filename and request_id into table when doing sqlldr
Sometimes when we sqlldr data file into table, we may need to carry filename and request_id into each line. sqlldr doesnt seem to be able to pass env variables into table, so what I can do is to mass原创 2008-01-11 12:29:00 · 1371 阅读 · 0 评论 -
connect as sysdba problem.--asktom
Hi there,I am running Oracle 8.1.7 EE on SUN Solaris. I created two databasesSUGAR and TestDb (I need one to do some testing). Both are set remote_login_passwordfile = exclusive. The following shows h转载 2008-01-07 09:10:00 · 1438 阅读 · 0 评论 -
Tuning Linux for 11i Apps Red Hat Linux 3.0* -
Tuning Linux for 11i Apps Red Hat Linux 3.0* - (Recommended version)Quarterly Update 3Note: From the Package Group Selection screen, select Legacy SoftwareDevelopment. The following components will be原创 2007-06-03 14:36:00 · 1134 阅读 · 0 评论 -
Workflow Notification Mailer Configuration in 11.5.10.2
1. environment Oracle Enterprise Linux 4 i386 Oracle Ebusiness Suite 11.5.10.2 on Linux i386 platform email: sendmail and cyrus imap dns server: bind host name: oel.alex.cn domain: alex.cn client: d原创 2007-08-05 22:27:00 · 970 阅读 · 0 评论 -
FND: Function Parameter How-to
1. Show org-selection screen and submit request/set screenREQUEST_GROUP_CODE="CLE_AIR_DIRECT_EXTRACT" REQUEST_GROUP_APPL_SHORT_NAME="XONT" USE_ORG="Y"2. Show org-selection screen and direct enter th原创 2006-11-28 18:25:00 · 1020 阅读 · 0 评论 -
FRM-92050 Errors on Linux Oracle Applications 11i installs
Doc ID: Note:299187.1 Type: PROBLEM Last Revision Date: 21-AUG-2006转载 2006-09-27 22:22:00 · 5669 阅读 · 0 评论 -
What is SPAWN concurrent program and how to write such program?
SPAWN program is C program in EBS.How do I compile a custom C program? Spawned programs: Step 1: Write the code Self-explanatory Step 2: Compile the source原创 2006-09-21 11:55:00 · 2540 阅读 · 0 评论 -
How to Register a Host Concurrent Program in Applications
1. Create a simple unix script called TEST.prog in $FND_TOP/binEx:touch /u01/1153/visionappl/fnd/11.5.0/bin/TEST.txt2. Register this as a concurrent executable in Application Object Library called TES原创 2005-09-21 09:53:00 · 1368 阅读 · 0 评论 -
11i Notes-Receivable Interface and AutoInvoice
Objective: To import and AutoInvoice Invoice/Credit/Debit Memo in batch.原创 2005-09-22 20:55:00 · 921 阅读 · 0 评论 -
Understanding Multiple Organization
1. There are 4 levels in Oracle 11i Multiple Organization Hierarchy.Business Group | |-Legal entity-- | | |-Operating Unit---原创 2005-08-22 19:07:00 · 843 阅读 · 0 评论 -
Oracle ERP 11i 维护经验(转自http://zhulch.itpub.net/post/17395/194340)
Oracle ERP 11i 维护经验(根据BBS上内容整理的)1. 在oracle applications 11i 中如何快速获得上次查询的SQL 语句方法:我们不必使用SQL Trace 来获得,有一个简单的办法,即:帮助->诊断->检查->在"块"中输入"system",在"字段"输入" last_query ",然后把鼠标移动到"值",你就可以看到你所要的SQL 语句,简单吧原创 2007-06-01 17:03:00 · 1200 阅读 · 0 评论 -
How to remove ^M in a uploaded text file?
In apps, its common that user changes setting of FTP client so that uploaded DOS plain text file contains a ^M at the end of each line. Such ^M usually cause wrong data in table after sqlldr loads it原创 2008-01-25 17:25:00 · 925 阅读 · 0 评论 -
How to delete a DFF Context
Sometime Im quite annoyed by the typo mistake when creating a DFF context. The DFF segment screen doesnt allow deletion of context. Fortunately, Oracle has internal API to do such thing. Following i原创 2008-01-03 18:36:00 · 1441 阅读 · 0 评论 -
What's wrong with FND_WEB.PING in Release 12?
As we know , in 11.5.8, we can use :/pls/VIS/mypkg">http://:/pls/VIS/mypkg to call enabled plsql package. To testing availability of pl/sql web agent, Oracle has a testing package fnd_web.ping. But in原创 2007-12-26 12:17:00 · 855 阅读 · 0 评论 -
Troubleshooting the Personal Home Page Login Problems in 11.5.x
Subject: Troubleshooting the Personal Home Page Login Problems in 11.5.x Doc ID: Note:135949.1 Type: TROUBLESHOOTING Last Revision Date: 31-MAR-2005 Status: PUBLISHED Troublesh转载 2007-12-26 11:50:00 · 7551 阅读 · 0 评论 -
FNDWRR.exe后面的temp_id是如何生成的--解析Oracle EBS request log/output的url
我们在EBS的view concurrent request 界面里, 通常会点击log或output, 然后在菜单里选copy file,从IE里来获取相应的log或output文件. 相应的url是http://host:port/OA_CGI/FNDWRR.exe?temp_id=2391709&login=APPLSYSPUT/PUB@VIS 这个url是如何生成的呢? 通过查看FNDRS原创 2007-12-25 11:03:00 · 6683 阅读 · 0 评论 -
How to enable Apache, OC4J and OPMN logging in Oracle Applications R12
Subject: How to enable Apache, OC4J and OPMN logging in Oracle Applications R12 Doc ID: Note:419原创 2007-12-10 22:08:00 · 963 阅读 · 0 评论 -
Application Object Library AOL/J Setup Test Suite
Application Object Library AOL/J Setup Test SuiteThe AOL/J Setup Test suite consists of Java Server Pages (JSPs) and can be used to diagnose AOL/J setup issues. These JSPs exercise various features原创 2007-12-09 20:46:00 · 1028 阅读 · 0 评论 -
Oracle Application Hints and Tips
I came accross following site about oracle application the other day. Quite useful site. http://www.sap-img.com/oracle-database/oracle-application-hints-and-tips.htm原创 2008-02-01 12:11:00 · 774 阅读 · 0 评论 -
Modifying BOM using BOM_BO_PUB.PROCESS_BOM
EBS Version: 11.5.8Requirement: User need to disable bom component by uploading a csv file which containing the TOP level assemblies to be disable by adding disable_date to all the components/subassem原创 2008-01-25 17:15:00 · 5849 阅读 · 0 评论 -
OM:Defaulting Rules using PLSQL APIs
Defaulting Rules using PLSQL APIs http://blog.oraclecontractors.com/?p=310 Order Management provides the ability to default a number of attributes onto the Sales Order Header and Lines based u转载 2008-12-18 14:33:00 · 4681 阅读 · 0 评论