Monday, December 19, 2011

How to make an Oracle Report Type concurrent program produce an excel friendly output?

›
Comma can be concatenated between the column values, however a better option is to create tab delimited file, as it takes care of commas wi...
4 comments:

Can you do fnd_request.submit_request from SQL Plus/Toad in Oracle?

›
You will need to initialize the global variables first using fnd_global.apps_initialize(user_id => :user_id, resp_id => :resp_id, ...
1 comment:

How do you link a Host type concurrent program to Concurrent Manager?

›
Assuming your executable script is LOADPO.prog, then use the commands below cd $XXPO_TOP/bin ln -s $FND_TOP/bin/fndcpesr $XXPO_TOP/bin/LO...
2 comments:

How to make concurrent program end with warning?

›
If the concurrent program is of type PL/SQL, you can assign a value of 1 to the retcode OUT Parameter. For a Java Concurrent program, us...
2 comments:

In self service, you wish to change the background color and the foreground text of the OA Framework screens to meet your corporate standards. How will you do it?

›
You will need to do the below steps Go to Mid Tier, and open $OA_HTML/cabo/styles/custom.xss Enter below text( change colours as needed) ...
1 comment:

In OA Framework Self-Service screen, you wish to disable a tab. How will you do it?

›
Generally speaking, the tabs on a OA Framework page are nothing but the SubMenus. By entering menu exclusion against the responsibility, you...
1 comment:

Which table is used to provide drill down from Oracle GL into sub-ledger

›
GL_IMPORT_REFERENCES column GL_SL_LINK_ID
2 comments: