Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Invoice Line data not appearing DW_AP_SLA_EXPENSE_DIST_CF table
Our team has entered test data in the Oracle Financials Cloud application that is unexpectedly not being populated in the Expense Distribution fact table.
Is there an undocumented filter condition that is being applied in the FAW pipeline that excludes records from being populated in the DW_AP_SLA_EXPENSE_DIST_CF table if the associated Invoice (DW_AP_INVOICE_CF) has INVOICE_ACCOUNTING_STATUS_CODE ='UNACCOUNTED'?
Best Answer
-
@Keith Antone - "AP Invoices" subject area[DW_AP_INVOICE_CF] returns all invoices created before the Initial Extract Date defined in the config, plus their installments. Irrespective whether the invoices are accounted or not. However, "AP Expense" subject area[DW_AP_SLA_INVOICE_SCHEDULE_CF] returns the invoice distributions of only accounted invoices. The invoices not yet accounted will not show up in "AP Expense" subject area.
Currently, we don't have a subject area to return AP Invoice Lines and their matched "Purchase Orders" data if they are not accounted yet.
Kindly let us know if this clarifies. Thank you.0
Answers
-
@Keith Antone - Yes, there is a filter in pipeline and if the invoice is unaccounted, it will not be available as FAW supports only accounted invoices. This is as per design.
0 -
@Sumanth V -Oracle We are seeing invoices with INVOICE_ACCOUNTING_STATUS_CODE = 'UNACCOUNTED' flow into the DW_AP_INVOICE_CF and DW_AP_SLA_INVOICE_SCHEDULE_CF. The associated Expense Distributions are not available
in FAW for these invoices.
0