Item Where Used for Business Intelligence

Use the Item Where Used for Business Intelligence scheduled process to load the Where Used data for an item to Oracle Transactional Business Intelligence (OTBI).

When this process runs, the Where Used data for the selected item is converted into a flat list and made available in OTBI to help users analyze where the item has been used across different item structures in an organization.

You can use this process to load Where Used data for:

• A single item belonging to a single organization.
• Multiple items belonging to a single organization.

When to Use

When an item is used in multiple structures across an organization, analyzing Where Used data in the application interface can be cumbersome and result in slow performance. As an administrator, you can circumvent this issue by making the latest Where Used data available in OTBI for use in analyses and reports.

Privileges Required

• Manage Item (EGP_MANAGE_ITEM_PRIV)

Specifications

Review the following before setting up this scheduled process:

Specification	Description
Job Type	Can be run as needed or scheduled at a set time.
Frequency	Depends on the volume of the Item Where Used data that is to be loaded.
Time of Day	As required based on when the Business Intelligence reports need to be run. Preferably after work hours at 00:00:00 AM if there is a huge volume of item data.
Duration	Based on the data volume.
Compatibility	There’s no current functional need to run multiple instances of this process simultaneously.

Parameters

Use this for parameters:

Parameter	Description	Parameter Value	Special Combinations Required	Notes
Items	The item name for which Where Used data is being queried.	To load data for a single item in an organization, provide the item name. To load data for multiple items, provide the item names as comma-separated values.	None	NA
Organization	The organization associated with the item.	Organization code	None	NA

Troubleshooting Information

• Any changes made after the last run of the scheduled process are loaded in the next run.
• The validation errors and warning messages for item and organization data display in the error log.
• No interactive warning validations are performed.
• After the program is submitted, you have the option to do the following: Resubmit, Put on Hold, Cancel Process, and Release Process.
• List of item names can't exceed 4000 characters.
• The process log will include detailed runtime information including validation results for items and organizations that don't exist, incomplete load warnings, and SQL errors.
• If the process does not complete, review the process log, correct the identified issues and rerun the job.