OBI Apps 220.127.116.11.1: POSTED_ON_DT_WID Column In AP PAYMENT SCHEDULES ALL
Last updated on SEPTEMBER 27, 2016
Applies to:Business Intelligence Applications Consumer - Version 18.104.22.168.1 and later
Information in this document applies to any platform.
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:
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.
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