You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BICC - Selecting Columns from Data Stores Impacts other reports

Received Response
13
Views
1
Comments
edited Mar 24, 2021 10:07PM in Reporting and Analytics for ERP 1 comment

Summary

How to configure BICC reports

Content

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!