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 is run, 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.
- 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
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
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 are displayed 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 nonexisting items and organizations, incomplete load warnings, and SQL errors.
- If the process does not complete, review the process log, correct the identified issues and rerun the job.