Perform Complex Data Analysis Using Data with Multiple Dimensions and Sources

The objective of this use case is to ensure that the item data in the data warehouse synchronizes with Oracle Fusion Cloud Product Lifecycle Management (PLM).

The scenario includes these conditions:

• You're a large multinational manufacturing company and use Oracle Cloud PLM (your single source of truth) to maintain your item and change order data.
• You source your components in multiple currencies and maintain the sourcing information in your legacy material requirements planning (MRP) system.
• You also receive daily the foreign-exchange (forex) rate from your third-party data provider.
• Your data warehouse, where the item data (including change order data), your MRP data, and the daily forex rate are uploaded regularly.
• Your forex risk forecast model factors in the change order schedules.

Therefore, the item data in the data warehouse must be synchronized with Oracle Cloud PLM for the forex risk forecast to closely reflect reality.

Description	Integration Type	Integration Options	Notes
This use-case scenario usually demands: Extraction of large volume of raw data from Oracle Cloud PLM should be performed often. In an on-going mode, the Oracle Cloud PLM data extraction should be incremental, periodic, and automated. The extracted file should be available in secure storage for further processing.	Outbound	You can use Oracle Business Intelligence Cloud Connector (BICC) to perform data extraction by accessing the public view object (PVO).	Neither Publications nor Oracle Transactional Business Intelligence (OTBI) is recommended for this use case.