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 Process page.

When to Use

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

Privileges Required

  • Privilege: 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 frequently.
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 on the scheduled processes UI. 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 UI.