Error: “Post-processing of request 4667897 failed at 30-Apr-2021 15:54:50 with the error message: One or more post-processing actions failed. Consult the OPP service log for details.” … oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.xdo.XDOException”…
Read MoreThe below query gives the Vendor delivery performance details with po approval TAT and delivery TAT. SELECTpo_number,vendor_name,po_creation_date,po_approved_date,po_item_code,po_item_description,po_quantity,po_price,rate_type,exchange_rate_date,exchange_rate,po_line_amt,pr_to_po_creation_tat,po_creation_to_approval_tat,need_by_date,mrn_date,actual_material_receipt_date,mrn_tat,delivery_tatFROM(SELECT DISTINCTpoh.segment1 po_number,poh.creation_date po_creation_date,aps.vendor_name vendor_name,poh.approved_date po_approved_date,mtl.segment1 po_item_code,pol.po_line_id,pol.item_description po_item_description,pol.quantity po_quantity,pol.unit_price po_price,poh.rate_type,poh.rate_date exchange_rate_date,poh.rate exchange_rate,( pol.quantity *…
Read MorePlease make sure to open the period where you want to post the journal. Let us create the following journal on a spreadsheet- Navigation- Go to General Accounting Dashboard and…
Read MoreOverview Under Funds disbursement page, users can submit Payment Process Requests (PPR) to generate payments. There is an option to submit a single Payment Process Request or schedule Payment Process…
Read MoreIntroduction: AP-query to get List of Suppliers which have not made payments since 2 years in Oracle EBS either invoice or payment. Query: select distinct a.vendor_id, b.ORG_ID, a.segment1 SUPPLIER_NUMBER, a.VENDOR_TYPE_LOOKUP_CODE…
Read MoreNID UTILITY IN ORACLE 12C DATABASE We can change both DBID and DB NAME using NID utility, the following will show how to change the DB NAME using NID utility.…
Read MoreOverview In this document, we are going to see about the prevention of dialog Page close by disabling the escape key and hide the close button. Technologies and Tools…
Read MoreUser was unable to apply the 6 receipt to the invoices for UK and they were getting the below error , “Error message: FRM-40654: Record has been updated .Requery block…
Read Morebusiness noticed that the receipt application is missing and the missed transaction level balance is not updated .. means transaction is not applied any receipt but it is showing ZERO…
Read MoreAssume that there is a requirement for a login page, the password you want to make hide and show when the user clicks a button or icon. You can achieve…
Read More