Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 273 Oracle Analytics and AI News
- 48 Oracle Analytics and AI Videos
- 16.2K 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
Oracle Fusion BICC PVOs - Invoice processing
I am looking for PVOs related to AP - invoice processing - Invoices, approval, validation, payment information, etc. I do see a couple of PVOs that say Invoices in this Doc ID:
How to Review Database Lineage Mappings, Check For Columns and View Objects for BICC PVOs? (Doc ID 2626555.1)
oracle.apps.projects.billing.workarea.invoice.publicView.analytics.InvoiceHeaderExtractPVO
oracle.apps.projects.billing.workarea.invoice.publicView.analytics.InvoiceLineExtractPVO
However, they say Projects.Billing, etc so not sure if they are related to AP invoices. Could any one please provide details how I can find PVOs related to AP Invoices.
Answers
-
@Arun Kumar Bangalore , Welcome to the Oracle Analytics Community!
You are correct those are not related to AP invoices.
Please use this payable invoice view object that contains information about invoices such as invoice number, invoice date, invoice amount, supplier, currency and so on. There is one row for each invoice.
Data Store Key : FscmTopModelAM.FinExtractAM.ApBiccExtractAM.InvoiceHeaderExtractPVO
Primary Keys : ApInvoicesInvoiceId
Initial Extract Date : ApInvoicesCreationDate
Incremental Extract Date : ApInvoicesLastUpdateDate
Please refer this doc for more details
Hope it helps!
0 -
BICC and PVOs are not Oracle Analytics products, therefore this isn't the right forum for it.
They are covered in a parallel, but independent, forum:
There are lot of categories there, including some related to data and analysis for Fusion products, like BICC and PVOs.
0
