Category: Oracle Application

Oracle Application

How we Track Purchasing Commitment with our Reporting Budget Without Using Encumbrance Accounting

My following article on Oracle Application published in ‘Oracle Metalink Customer Knowledge Exchange‘. The Doc ID:  Note: 553588.1 How we Track Purchasing Commitment with our Reporting Budget Without Using Encumbrance Accounting In our 11.5.10.2 apps installation we are using reporting budget only (without budgetary control and not using encumbrance accounting). It was not possible for… Continue reading How we Track Purchasing Commitment with our Reporting Budget Without Using Encumbrance Accounting

How I Used RedHat Command Line Utilities to Automate Rapid Clone on my Test and Dev Instances

My following article on Oracle Application published in ‘Oracle Metalink Customer Knowledge Exchange’. The Doc ID:  Note: 454393.1 How I Used RedHat Command Line Utilities to Automate Rapid Clone on my Test and Dev Instances We are running single node Oracle Application R11i production system on RedHat AS3 for our telecom sector business. I have… Continue reading How I Used RedHat Command Line Utilities to Automate Rapid Clone on my Test and Dev Instances

How to reject pre-approved status blanket release?

Navigate to Responsibility -> Workflow Administrator->Status Monitor.Find the workflow item by entering:Type Internal Name: POAPPRV & User Key: 9999 (Your PO number) & click ‘Go’. From the search result select appropriate workflow and click Activity History->Skip->Back to sender.

How to find number of asset created in a period along with start and end asset number?

SELECT p.period_name, p.period_counter, COUNT (a.asset_number) COUNT,   MIN (a.asset_number) start_number, MAX (a.asset_number) end_number   FROM fa_additions_b a, fa_deprn_periods p   WHERE a.creation_date BETWEEN p.period_open_date AND NVL (p.period_close_date, SYSDATE)   AND p.BOOK_TYPE_CODE=’MY_BOOK1′ GROUP BY p.period_name, p.period_counter ORDER BY p.period_counter

How do I find which organization is master to which child organization?

SELECT p.organization_id clild_organization_id,   p.organization_code clild_organization_code,   c.organization_name child_organization_name,   p.master_organization_id,   m.organization_code master_organization_code,   m.organization_name master_organization_name FROM mtl_parameters p,   org_organization_definitions m,   org_organization_definitions c WHERE p.master_organization_id = m.organization_id AND p.organization_id = c.organization_id ORDER BY p.organization_code

How to change display setting for Oracle Application?

You will typically receive the following error while running a pdf report, when the display is not working properly. Xlib: connection to “myhost01:0.0” refused by server Xlib: No protocol specified REP-3000: Internal error starting Oracle Toolkit. REP-3000: Internal error starting Oracle Toolkit. If you need to change the display setting:a. OAM->Sitemap->Autoconfig-><CONTEXT_NAME> (Applications Tier) ->Edit Parameter->… Continue reading How to change display setting for Oracle Application?

Which ports are used by Oracle Application R11i by default?

To view the ports used by your current Oracle Application installation navigate toOAM->Site Map->Hosts->View Configuration. It will show the list of ports. It is created during installation and saved as config.txt  under $APPL_TOP. Typical values are like Data Port 9100 Discoverer port 8000 FND Java Cache Port Range Forms Servlet Port Range 18000-18009 iMeeting iMon… Continue reading Which ports are used by Oracle Application R11i by default?

Where is the adpatch log file located?

Patch log files:$APPL_TOP/admin/<SID>/log/adpatch.lgii.e. /appltest/testappl/admin/TEST/log/adpatch.lgi Errors and warnings are$APPL_TOP/admin/<SID>/log/adpatch.logi.e. /appltest/testappl/admin/TEST/log/adpatch.log

Where is the concurrent manager log located?

Concurrent manger is started by script adcmctl.sh. This is located at$COMMON_TOP/ admin/scripts/<CONTEXT_NAME >something like at /appltest/testcomn/admin/scripts/TEST_myhost01. View this file and will get a line near at the beginning like LOGFILE=”/appltest/testcomn/admin/log/TEST_myhost01/adcmctl.txt”This is the concurrent manger log.