BICC - Selecting Columns from Data Stores Impacts other reports
SummaryHow to configure BICC reports
We are currently working on our migration to Oracle Fusion. I am tasked with looking at extracting data via BICC.
How can I configure exports for two different groups who need different information in the exported report?
We have 2 offerings that use the same data store. However, these offerings want to include different columns. From what I've seen so far, when I edit the datastore while viewing offeringA, the columns selected in offeringB also change (same data store, so I guess that makes sense?).
For example, in DataStore FscmTopModelAM.EgpStructuresPublicModelAM.StructureExplosionStgPVO, one extract should include the inventoryitemid for child/item/parent along with quantity and description (essentially enough information to build out the BOM in a 3rd party tool). The other extract should only include the item numbers, descriptions and related language and approvals (A user manually reviewing offerings and approvals for technical writing purposes). Obviously it is possible for both groups to just get more information than they want, but it would be very easy to break one group or the other's processes by introducing a new column that one group needs.