View Accounting WIll Not Pull Up Any Accounting Information Bug 5652295 [ID 376862.1]

Bug 5652295 : VIEW ACCOUNTING LINES DOES NOT SHOW ANY INVOICE DATA ONLY PAYMENTS

Applies to:

Oracle Payables – Version: 11.5.10
This problem can occur on any platform.
PATCHSET:11I.AP.N
PATCHSET:11I.AP.M
PATCHSET:11I.AP.O
FORM:XLAIQACL.FMB – View Accounting Lines
FORM:APXINWKB.FMB – Invoice Workbench
FORM:APXPAWKB.FMB – Payment Workbench

Symptoms

The view accounting screen will not pull up any lines.

Cause

The ap_lookup_gt table is not getting populated properly.
Ran independent queries using the view AP_INV_AEL_SL_V Found that the view works fine if the ap_lookup_gt table is not linked in.
Per 5115918 – Find Accounting Lines(Ap – Xlaiqacl) Performance Issue
++ 1. Description -> No rows will be returned on querying the transactions in -> View Accounting lines after the performance fix

Bug 5652295 – View Accounting Lines Does Not Show Any Invoice Data Only Payments
++ 1. Description:  -> View Accounting Lines is not displaying the lines related  -> to invoices, when queried without mentioning the document class.

Solution

1. Apply patch 5137245 – 1 Off For Bug 5115918:11.5.10.Ap.M:Find Accounting Lines(Ap – Xlaiqacl) Performa

2.  Apply patch 5652295 – View Accounting Lines Does Not Show Any Invoice Data Only Payments

References

BUG:5115918 – NO DATA FOUND WHEN ACCOUNTED TRANSACTIONS FROM VIEW ACCOUNTING
PATCH:5137245 – 1 OFF FOR BUG 5115918:11.5.10.AP.M:FIND ACCOUNTING LINES(AP – XLAIQACL) PERFORMA
BUG:5652295 – VIEW ACCOUNTING LINES DOES NOT SHOW ANY INVOICE DATA ONLY PAYMENTS

Advertisements

What Fields in Tables Ap_Invoices_Interface and Ap_Invoice_Lines_Interface Should Be Populated to Import Invoices Matched to Purchasing Order (PO)?

  • goal: What fields in tables ap_invoices_interface and ap_invoice_lines_interface should be populated to import invoices matched to Purchasing order ( PO )?
  • fact: APXIIMPT – Payables Open Interface Import
  • fact: Oracle Payables 11.5
  • fact: Oracle Payables 11
  • fact: Oracle Payables 10.7
fix:

PO MATCHED INVOICES 
AP_INVOICES_INTERFACE:

================
Required Columns
================
INVOICE_ID                (Populated from AP_INVOICES_INTERFACE_S.NEXTVAL)
INVOICE_NUM               (Must be unique to the supplier)
PO_NUMBER                 (An approved, not cancelled, not closed or final closed PO. Validated against PO_HEADERS)
INVOICE_AMOUNT            (Positive Amount)
SOURCE                    (Must be in select lookup_code from ap_lookup_codes where lookup_type='SOURCE')
ORG_ID                    (Required in Multi-Org Environment. Validated against AP_SYSTEM_PARAMETERS_ALL.ORG_ID)
================
Optional Columns
================
INVOICE_DATE                  (Defaulted to SYSDATE)
INVOICE_TYPE_LOOKUP_CODE      (Defaulted to 'STANDARD')
INVOICE_CURRENCY_CODE         (Defaulted from PO_VENDOR_SITES.INVOICE_CURRENCY_CODE)
EXCHANGE_RATE_TYPE            (Defaulted from AP_SYSTEM_PARAMETERS.DEFAULT_EXCHANGE_RATE_TYPE)
TERMS_ID or TERMS_NAME        (Defaulted from PO_VENDOR_SITES.TERMS_ID)
DOC_CATEGORY_CODE             (Only populated if using automatic voucher number)    
PAYMENT_METHOD_LOOKUP_CODE    (Defaulted from PO_VENDOR_SITES.PAYMENT_METHOD_LOOKUP_CODE)
PAY_GROUP_LOOKUP_CODE         (Defaulted from PO_VENDOR_SITES.PAY_GROUP_LOOKUP_CODE)
ACCTS_PAY_CODE_COMBINATION_ID (Defaulted from PO_VENDOR_SITES.ACCTS_PAY_CODE_COMBINAITON_ID)
GROUP_ID                      (Group identifier. Suggest to use it)
STATUS                        (DO NOT POPULATE IT)  

==========================
AP_INVOICE_LINES_INTERFACE
==========================
Required Columns for PO Matched Lines
=====================================
INVOICE_ID                (Populated from AP_INVOICES_INTERFACE.INVOICE_ID)
INVOICE_LINE_ID           (Populated from AP_INVOICE_LINES_INTERFACE_S.NEXTVAL)
LINE_NUMBER               (A unqiue number to the invoice)
LINE_TYPE_LOOKUP_CODE     ('ITEM')
AMOUNT                    (Should be QUANTITY_INVOICED * UNIT_PRICE)
======================================
If MATCH_OPTION is 'P', then populate:
======================================
RELEASE_NUM or PO_RELEASE_ID           (For Blanket Release only, validated against PO_RELEASES_ALL)
PO_NUMBER or PO_HEADER_ID              (Validated against PO_HEADER_ALL)
PO_LINE_NUMBER or PO_LINE_ID           (Validated against PO_LINES_ALL)
PO_SHIPMENT_NUM or PO_LINE_LOCATION_ID (Validated against PO_LINE_LOCATIONS_ALL)
======================================
If MATCH_OPTION is 'R', then populate:
======================================
RECEIPT_NUMBER                             (Validated against RCV_SHIPMENT_HEADERS.RECEIPT_NUM)
RCV_TRANSACTION_ID or PO_LINE_LOCATION_ID  (Validated against RCV_TRANSACTIONS)
======================================
Optional Columns for PO Matched Lines:
======================================
QUANTITY_INVOICED                (Populated if different from PO shipment)
UNIT_PRICE                       (Populated if different from PO shipment) 
MATCH_OPTION                     ('P' or 'R' or Defaulted from PO_VENDOR_SITES.MATCH_OPTION)
ACCOUNTING_DATE                  (Defaulted from INVOICE_DATE or SYSDATE)
FINAL_MATCH_FLAG                 (Populated 'Y' if it is final matching)
INVENTORY_ITEM_ID                (Validated against PO_LINES.INVENTORY_ITEM_ID)
INVENTORY_DESCRIPTION            (Validated against PO_LINES.INVENTORY_ITEM_DESCRIPTION)
SHIP_TO_LOCATION_CODE            (Populated if different from PO shipment)
PRICE_CORRECTION_FLAG            (Populated 'Y' if it is price correction)