Oracle Fusion BICC PVOs - Invoice processing

Arun Kumar Bangalore

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.

RVohra

@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!

Gianni Ceresa

@Arun Kumar Bangalore ,

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: https://community.oracle.com/customerconnect

There are lot of categories there, including some related to data and analysis for Fusion products, like BICC and PVOs.