Price optimization enhancement for Sales Order Header and Sales Order Lines in BICC

Price optimization process name and other attributes of Sales Orders and Sales Order Lines can now be extracted from the Oracle Business Intelligence Cloud Connector (BICC) using the following datastores:

Datastore: 

CrmAnalyticsAM.CrmExtractAM.MooBiccExtractAM.SalesOrderHeaderExtractPVO

• BuOrgId

• ExternalHostName

• ExternalProcessName

• OptyCustPartyId

• OptyCustPartyType

• OwnerResourcePartyId

Datastore: 

CrmAnalyticsAM.CrmExtractAM.MooBiccExtractAM.SalesOrderLineExtractPVO

• ExternalAssetKey

• ExternalParentAssetKey

• ExternalRootAssetKey

• ParentExternalOrderLineNumber

Users can now extract the price optimization process name and the above attributes of Sales Orders and Sales Order Lines for analysis, data validation or integration with any other applications they use.

Steps to enable and configure

You don't need to do anything in BICC to enable this feature. 

Tips and considerations

The new attributes must be added to the appropriate datastore before they can be extracted in BICC. For setup guidance, refer to the Edit a Data Store for an Offering in Creating a Business Intelligence Cloud Extract documentation.

Key resources

Oracle Business Intelligence Cloud Connector (BICC)

Access requirements

Anyone who has access to BICC will have access to this Data Store in BICC.