Refresh Product Genealogy for Transactional Business Intelligence

This process is used to synchronize the Genealogy Composition data and Genealogy Where Used data to the aggregate data sources for Oracle Fusion Transactional Business Intelligence (OTBI).

You can access this report from the Scheduled Processes work area.

When to Use

The process should be run regularly to refresh OTBI data sources.

Privileges Required

  • Process Product Genealogy Transactions (CSE_PROCESS_PRODUCT_GENEALOGY_TRANSACTIONS_PRIV)

Specifications

Use these specifications when you run the scheduled process.

Specification Description
Job Type On an scheduled basis. You should set it up to run often.
Frequency Depending on your reporting and analysis requirements, daily or weekly is recommended.
Time of Day Any time.
Duration Typically, it will take several minutes, depending on the volume of data being processed.
Compatibility There should be only one instance of the job running at any one time.

Parameters

There are no parameters for this process.

Troubleshooting Information

  • Once submitted, you can view the status of the process in the Scheduled Processes work area. A successfully completed process, as well as any child processes, will end in Succeeded status.
  • If issues are encountered, the process or any of its subprocesses may be Warning or Error. The specific validation errors and warning messages that prevented the process from completing successfully are displayed in the error log(s).
  • Any interactive warning validations are NOT performed.
  • When the process is submitted, you can Resubmit, Put on Hold, Cancel Process, Release Process as provided by the Scheduled Processes work area.