My Oracle Support Banner

OBIA 7964 Partial Paid / Unpaid AP Invoices are not showing up in AP Aging Report (Doc ID 1675580.1)

Last updated on DECEMBER 23, 2019

Applies to:

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

Goal

On : 7.9.6.4 version, DataWarehouse

Partial Paid / Unpaid AP Invoices are not showing up in AP Aging report

1) Is it possible for you to provide us a shorts description/function of 3 Mappings, which loads data into W_AP_XACT_FS?
  APTransactionFact_Payment
  APTransactionFact_Distributions
  APTransactionFact_PaymentSchedule
 
2) Are Partial Paid / UnPaid invoices considered in Aging Process? For example, INVOICE_TYPE_CODE of CREDIT and STANDARD.

3) There would never be a case where the Invoices extracted from SDE_ORA_APTransactionFact_Payment or _Distributions, would be considered for populating Aging Fact / Aging Report. Is that correct? 

4) What is the difference between W_XACT_TYPE_D.W_XACT_TYPE_CODE of "ORIGINAL" and "APPLICATION" ?  How are invoices tag with this XACT_TYPE_CODE? 

 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


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