-
http://mumnai.blogspot.com/2012/06/sla-technical-perspective-of-ap-to-gl.html

http://www.oracleappsquery.com/?q=oracle-apps-r12-AP-Accounts-Payables-useful-sql-scripts-queries

http://oracleapps88.blogspot.com/p/scripts.html

https://knoworacle.wordpress.com/2010/05/24/oracle-apps-ebs-technical-common-sql-scripts-for-regular-investigations/

http://www.orafinapps.com/knowledge-categories.php?KTID=6

http://chigulla.blogspot.com/2013/07/sql-query-to-check-ap-invoice-and.html

http://www.oracleerp.org/post/r12-0-6-sql-for-ar-ap-aging-based-on-7-buckets

http://snipplr.com/view/62697/oracle-apslagl-link-query/

http://orafinappssetups.blogspot.com/2013/02/how-do-you-undo-accounting-in-r12.html

http://eoracleapps.blogspot.com/2011/03/query-to-get-unpaid-invoices-oracle.html

http://alloracleapps.com/oracle_apps/apps_functional/apps-functional-modules/ap/script-to-get-ap-invoice-aging-for-prepaymentadvances/

http://www.oracleerp4u.com/2010/06/ap-po-technical-link.html

http://sairamgoudmalla.blogspot.com/2010/08/script-to-cancel-ap-invoices.html

http://mumnai.blogspot.com/2012/06/sla-technical-perspective-of-ap-to-gl.html

http://surendranathebs.blogspot.com/p/common-issues.html

http://www.shareoracleapps.com/2010/10/api-to-find-ap-invoice-status.html

http://ebsanil.blogspot.com/2012/09/sql-query-to-check-if-ap-invoices-is.html

https://sites.google.com/site/oracler12ebtax/oracle-r12-ebtax-sql-queries-for-functional-implementers-for-troubleshooting

http://www.erpschools.com/scripts/procure-to-pay-cycle-query

http://www.oracleforall.com/ebs-script-tables/

Comments

Post a Comment

Popular posts from this blog

AP Invoice Rejection - Errors

-
Account Required.  Accounting information is missing for this line. Acct Date Beyond Enc Year.  Accounting date (ACCOUNTING_DATE) is beyond the encumbrance year and the Use PO Encumbrance Financials option is enabled. Acct Date Not In Open Pd.  Accounting date (ACCOUNTING_DATE) is not in an open period. Amount Billed Would Be Below Zero.  This transaction would reduce the amount billed on the purchase order to below zero. Amount Unpaid Too Small.  The prepayment amount that you are trying to apply (PREPAY_APPLY_AMOUNT) exceeds the invoice amount. Note:  For invoices that include prepayments (that is, the invoice amount has already been reduced by the amount of the prepayment) the prepayment amount cannot exceed the unpaid invoice amount. Applying More Than Avail.  You are applying a prepayment to the invoice and the amount you are applying is greater than the prepayment amount available for application. You can see a prepayment’s available a...
Read more

AP Invoice Rejections

-
Select aii.Invoice_num , air.PARENT_TABLE, air.REJECT_LOOKUP_CODE, air.parent_id From apps. AP_INTERFACE_REJECTIONS air, apps. AP_INVOICE_LINES_INTERFACE aili, apps. AP_INVOICES_INTERFACE aii WHere aii.invoice_id=aili.invoice_id AND  aili.invoice_id=air.parent_id AND aii.Invoice_num = ‘Invoice Number’ aii.INVOICE_ID, aii.SOURCE, aii.invoice_num, (select decode(count(*),0,'Invoice N/A','Invoice Available') from ap_invoices_all where org_id = aii.ORG_ID and invoice_num = aii.INVOICE_NUM) Inv_in_Base, aii.CREATION_DATE, aii.invoice_date,  aii.GL_DATE, ail.LINE_NUMBER, aii.REQUEST_ID, aii.invoice_currency_code, nvl(airh.REJECT_LOOKUP_CODE,airl.REJECT_LOOKUP_CODE) Rejection_Reason, (select decode(count(INACTIVE_DATE),0,'Site is Active','Site is Inactive') from po_vendor_sites_All where vendor_site_id = aii.VENDOR_SITE_ID) Site_STatus from ap_invoice_lines_interface ail, AP_INTERFACE_REJECTIONS airh, AP_INTERFACE_REJECTIONS airl, ap_invoices_interface aii,...
Read more

GL Interface

-
STATUS NOT NULL VARCHAR2(50)   LEDGER_ID   NUMBER(15)   ACCOUNTING_DATE NOT NULL DATE   CURRENCY_CODE NOT NULL VARCHAR2(15)   DATE_CREATED NOT NULL DATE   CREATED_BY NOT NULL NUMBER(15)   ACTUAL_FLAG NOT NULL VARCHAR2(1)   USER_JE_CATEGORY_NAME NOT NULL VARCHAR2(25)   USER_JE_SOURCE_NAME NOT NULL VARCHAR2(25)   CURRENCY_CONVERSION_DATE   DATE   ENCUMBRANCE_TYPE_ID   NUMBER   BUDGET_VERSION_ID   NUMBER   USER_CURRENCY_CONVERSION_TYPE   VARCHAR2(30)   CURRENCY_CONVERSION_RATE   NUMBER   AVERAGE_JOURNAL_FLAG   VARCHAR2(1)   ORIGINATING_BAL_SEG_VALUE   VARCHAR2(25)   SEGMENT1   VARCHAR2(25) ...
Read more