Oracle EBS AP发票 已过账项介绍

Oracle EBS AP发票 已过账项介绍

There are 4 invoice status as  given below
‘S’ – Selected
‘P’ – Partial
‘N’ – Unposted
‘Y’ – Posted

Check  and ensure that the Invoice Id entry should be in the table – AP_INVOICE_DISTRIBUTIONS_ALL
Check  and ensure that the Invoice Id entry should be in the table – AP_SELF_ASSESSED_TAX_DIST_ALL
Check if DIST VAR hold is placed on this invoice. DIST VAR Hold  could be placed  when no distributions exist and the invoice status should be NEEDS REAPPROVAL
Check and ensure that there is NO Hold applied on the Invoice
Check if the Invoice is NOT Cancelled
Check Table – AP_INVOICE_DISTRIBUTIONS_ALL for the Invoice ID match_status_flag IS NOT NULL and count should be 0

SQL to get AP Invoices Validated but Not Posted to General Ledger (GL)

SELECT INVOICE_NUM
FROM AP_INVOICES_ALL
WHERE AP_INVOICES_PKG.GET_APPROVAL_STATUS
(INVOICE_ID,
INVOICE_AMOUNT,
PAYMENT_STATUS_FLAG,
INVOICE_TYPE_LOOKUP_CODE
) ='APPROVED'
AND AP_INVOICES_PKG.GET_POSTING_STATUS(INVOICE_ID)='N

SQL Query to get AP Invoices Validated & Posted to General Ledger (GL)

SELECT INVOICE_NUM
FROM AP_INVOICES_ALL
WHERE AP_INVOICES_PKG.GET_APPROVAL_STATUS
(INVOICE_ID,
INVOICE_AMOUNT,
PAYMENT_STATUS_FLAG,
INVOICE_TYPE_LOOKUP_CODE
) ='APPROVED'
AND AP_INVOICES_PKG.GET_POSTING_STATUS(INVOICE_ID)='P'

-- 刘轶鹤