AIM: This query is used for getting the data of AR Receipt in account receivable. Script: SELECT ABA.NAME Receipt_Batch ,DECODE(ACRA.STATUS,’APP’,’APPLIED’,’UNID’,’UNIDENTIFIED’,’UNAPP’,’UNAPPLIED’,’REV’,’REVERSED’,ACRA.STATUS) STATE ,acra.RECEIPT_NUMBER ,ACRA.COMMENTS ,sum(unapp.amount_applied) Unapplied_Amount ,ACRA.TYPE ,ACRA.AMOUNT RECEIPT_AMOUNT ,ARM.NAME RECEIPT_MENTHOD…
Read MoreThis Query is used for getting the AP invoice for TDS during the current financial Year. Script: SELECT SEGMENT1 SUPPLIER_NUMBER ,VENDOR_NAME SUPPLIER_NAME ,ACTUAL_SECTION_CODE SECTION_CODE ,aia.invoice_num ,aia.invoice_date , jt.TAX_AMOUNT tax_amount ,SUM(JT.AMOUNT) …
Read MoreAIM: Component is used for Create the Requisition against the Blanket Purchase Agreement For different Locations. SCRIPT: CREATE OR REPLACE PACKAGE BODY APPS.XXTTK_BPO_PKG IS PROCEDURE XXTTK_REQ ( ERRORBUF OUT VARCHAR2…
Read MoreDECLARE paslrec po_approved_supplier_list_rec; paarec po_asl_attributes_rec; padrec po_asl_documents_rec; chvrec chv_authorizations_rec; psicrec po_supplier_item_capacity_rec; psitrec po_supplier_item_tolerance_rec; x_errors po_asl_api_error_rec; x_session_key NUMBER; x_return_status VARCHAR2 (30); x_return_msg VARCHAR2 (2000); BEGIN — Populating values in paslrec paslrec…
Read MoreAPPLIES TO: Oracle Applications Manager – Version 12.2 to 12.2 [Release 12.2Cloud] Information in this document applies to any platform. SYMPTOMS: Trying to install 12.2 E-Business Suite on Linux and…
Read MoreAPPLIES TO: Oracle Applications Manager – Version 12.0 to 12.0.4 [Release 12] Information in this document applies to any platform. This problem can occur on any platform. SYMPTOMS: Error running…
Read MoreIssue: SSO is unable to establish a connection to EBS as the APPS password is wrongly updated. —— Error: ——- [2015-11-25T11:45:23.966-05:00] [wls_ods2] [ERROR] [DIP-20050] [oracle.dip.prodapp_calif_I] [tid: prodapp_calif_I] [userId: <anonymous>] [ecid:…
Read MoreYou can retry all errored activities for the specific item type, or you can choose to retry only activities for a particular work item of that item type, activities for…
Read MoreCAUSE : ———- Incorrect data is present in the OPP queue table AQ$FND_CP_GSM_OPP_AQTBL_S, which occurs when the concurrent managers are not shutdown correctly. A quick sql query shows orphaned OPP…
Read Moreset linesize 300; set pagesize 1000; spool rac_redo_switch_rate.log set heading off; select ‘******************************************************’ from dual; select ‘**** Redolog Switch Rate by Date and Hour ****’ from dual; select ‘******************************************************’ from…
Read More