Oracle Communities

Oracle Analytics and AI

Child Item

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.

Find more posts tagged with

Accepted answers

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!

All comments

RVohra

@Arun Kumar Bangalore , Welcome to the Oracle Analytics Community!

You are correct those are not related to AP invoices.

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.

Arun Kumar Bangalore

@RVohra Thank you and appreciate the excellent information.

RVohra

@Arun Kumar Bangalore , Thanks for the acknowledgement, appreciate it.