R12: AP: Distribution Is Not Created for PO Matched Imported Invoice (Doc ID 2771141.1)

Last updated on JANUARY 30, 2023

Applies to:

Symptoms

When running Payables Open Interface import, invoice distribution is not created for PO matched invoice if the following conditions are met.

• Set end date to the one of AFF(Accounting Flex Field) value
  (i.e. Segment: cost center, Value: ZZZ, Effective end date: 2021/03/31)
• Set the AP_INVOICE_LINES_INTERFACE.DIST_CODE_CONCATENATED which includes above segment value
  (i.e. XX.ZZZ.XX.XXXXX.XXXX)
• Invoice date, GL date and accounting date are prior to segment value's end date.
  (i.e. Accounting date: 2021/03/01)
• Run Payables Open Interface import after segment value's end date.
  (i.e. Sysdate: 2021/04/01)
  
  

In above case, Payables Open Interface import is complete without any error and invoice header and lines are created successfully.
However, distribution is not created and it is unable to add or edit distribution manually via Invoice Workbench as it is PO matched invoice.

Invoice accounting date is prior to segment value's end date.  So code combination is valid on accounting date and distribution should be created successfully.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.