Missing Columns in BICC PVO but columns available in the underlying Oracle database tables
Summary:
While analyzing the BICC Object Views for sending the data to Traget System—similar to the BIP extracts—for the following three Oracle tables, I noticed that some columns available in the underlying Oracle database tables are not present in the corresponding BICC Public View Object(PVO) . As a result, we are unable to send the same number of columns to Traget System.
Oracle Table Name | BICC View Object (s) | Missing Columns |
---|---|---|
XLA_AE_LINES | 1. FscmTopModelAM.FinExtractAM.XlaBiccExtractAM.SubledgerJournalLineExtractPVO 2. FscmTopModelAM.FinXlaJrnlEnterJrnlAM.JournalEntryLinePVO | MULTIPERIOD_CLASS_CODE |
XLA_DISTRIBUTION_LINKS | 1. FscmTopModelAM.FinExtractAM.XlaBiccExtractAM.SubledgerJournalHeaderExtractPVO 2. FscmTopModelAM.FinExtractAM.XlaBiccExtractAM.SubledgerJournalDistributionExtractPVO | APPLIED_ACCOUNT_PRIORITIES |