Alex Zhang's Blog

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

  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

 :/servlets/oracle.apps.icx.common.SystemInfoTest">http://:/servlets/oracle.apps.icx.common.SystemInfoTest:/servlets/IsItWorking">http://:/servlets/IsItWorking:/servlets/oracle.apps.icx.common.Connect

 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

 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

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

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

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

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

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

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

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,

select distinct name  from all_source where name  LIKE ORACLE% wfa_html BIS_RG_SCHEDULER_PVT 

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.

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 "

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

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

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_

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

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

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

1. There are 4 levels in Oracle 11i Multiple Organization Hierarchy.Business Group   |   |-Legal entity--   |                        |                            |-Operating Unit---                   

Objective: To import and AutoInvoice Invoice/Credit/Debit Memo in batch.

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

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   

Doc ID: Note:299187.1 Type: PROBLEM   Last Revision Date: 21-AUG-2006

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

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

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

Oracle ERP 11i 维护经验（根据BBS上内容整理的）1. 在oracle applications 11i 中如何快速获得上次查询的SQL 语句方法：我们不必使用SQL Trace 来获得，有一个简单的办法，即：帮助->诊断->检查->在"块"中输入"system"，在"字段"输入" last_query "，然后把鼠标移动到"值"，你就可以看到你所要的SQL 语句，简单吧

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),

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

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 

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

Subject: How to enable Apache, OC4J and OPMN logging in Oracle Applications R12   Doc ID: Note:419

我们在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

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

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

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

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