I am looking for a PVO for PJB_BILLING_CONTROLS table

Question

I am looking for a PVO for PJB_BILLING_CONTROLS table. If not, is there any other table/ PVO that I can use to get the below columns:

contract_id,SOFT_LIMIT_AMOUNT,contract_line_id,version_type,ITD_REVENUE_AMOUNT

Mohit Sobti · Answer

Hi Daniel- We checked in OTBI but the required columns are not available there for us to create the report. Is there a document link that you can share for creating BICC extract. The documents I can see are for creating custom VO's in BICC for custom_objects

Daniel Ryan · Answer

Hi @Mohit Sobti

The only ones available as standard in FAIDP are

FscmTopModelAM.PrjExtractAM.PjbBiccExtractAM.BillingAccountingEventExtractPVO

FscmTopModelAM.PrjExtractAM.PjbBiccExtractAM.BillingEventExtractPVO

FscmTopModelAM.PrjExtractAM.PjbBiccExtractAM.BillingMethodTLExtractPVO

Do you know if the column is available anywhere in OTBI? if it is then you can create a single column report and look at the generated SQL in developer mode or the console log and it should tell you the PVO.

If there isn't a PVO, you can create your own BICC extract to do the data augmentation.