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?
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
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.
SELECT hr.NAME, poh.segment1, por.release_num, por.wf_item_type, por.wf_item_key FROM po_headers_all poh, po_releases_all por, hr_all_organization_units hr WHERE poh.org_id = hr.organization_id AND por.org_id = poh.org_id AND poh.po_header_id = por.po_header_id AND poh.segment1 = ‘796’ AND por.release_num = ’49’
Use the following API column in your SQL respectively:AP_INVOICES_PKG.GET_PREPAY_AMOUNT_APPLIED(AI.INVOICE_ID) PREPAY_AMOUNT_APPLIEDandAP_INVOICES_PKG.GET_AMOUNT_WITHHELD( AI.INVOICE_ID) AMOUNT_WITHHELD
Get the ‘Mass Transaction Number’ form ‘Mass Reclassification’ screen. (After ‘Previewing’ the Mass Transaction). Navigation: Fixed Asset user->Navigator->Mass Transaction->Reclassifications SQL> SELECT * FROM FA_MASS_RECLASS_ITF FAM WHERE FAM.MASS_RECLASS_ID=xxx; * xxx is the Mass Transaction Number
Change the profile option ‘GLDI: Budget Wizard Privileges’ to entry for that responsibility.
To check if the FA Security by Book functionality is enabled for a responsibility:Login to the responsibility. Query the profile option “FA: Security Profile” (Other > Profile). If the “Default Value” is defined, then you have the Security by Book enabled for the responsibility. If the “Default Value is not defined (i.e. null), then you… Continue reading How to check if you have the Security by Book functionality enabled?