OBI Apps 11.1.1.7.1: POSTED_ON_DT_WID Column In AP PAYMENT SCHEDULES ALL (Doc ID 1938229.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Goal

In BIAPPS, AP fact design, all the AP Invoices lines have the POSTED_ON_DT_WID as GL_DATE of the invoice except for the PAYMENT SCHEDULE Line entry.
For PAYMENT SCHEDULE LINES, the POSTED_ON_DT_WID is populated as CREATION_DATE/LAST_UPDATE_DATE of the invoice.

Please let us know the reason for populating in that way.

I am referring to the ODI Interface: SDE_ORA_APTransactionFact_PaymentSchedule

The POSTED_ON_DT column has the expression as below:

IIF_NULL('SCH'='SCH',COALESCE(SQ_AP_INVOICES_ALL.INVOICE_DATE,SQ_AP_INVOICES_ALL.LAST_UPDATE_DATE))

In all other AP mappings (Distributions, Payments, Expense and Liability Lines), the POSTED_ON_DT is the ACCOUNTING_DATE.

So, we wanted to know the functional aspect of why in the payment Schedule mapping, POSTED_ON_DT is the populated with Creation date or LAST_UPDATE_DATE of the invoice.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms