Category: Oracle Application

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?