Expand Structure for Business Intelligence
Use the Expand Structure for Business Intelligence scheduled process to load item structure hierarchies as an expanded flat list to Oracle Transactional Business Intelligence (OTBI) for use in structure and component analyses.
When this process runs, the hierarchical view of the selected structures is converted into a flat list view that also includes the structure level for each component.
You can use this process to:
- Load item structures for a particular organization.
- Load only the latest revision or all revisions of items within the structures.
- Load alternate structures for selected items.
When to Use
Use this process when you want to run structure reports and get a flat view of the selected item, and when you want to analyze updates to the structures of the selected items over different revisions as an expanded flat list.
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 item structures and updates to the items. |
| Time of Day |
As and when required based on when the business intelligence reports need to be run. Preferably after work hours at 00:00:00 a.m. if there's a huge volume of item data to be converted. |
| Duration | Based on the data volume. |
| Compatibility |
There’s no current functional need to run multiple instances of this process simultaneously. |
Parameters
Use this table format for parameters:
| Parameter | Optional or Required | Description | Parameter Value | Special Combinations Required | Notes |
|---|---|---|---|---|---|
| Items | Required |
The name of the item for which you want to see expanded structure levels. |
To load data for a single structure in an organization, provide the item name. To load data for multiple structures, provide the item names as comma-separated values.
|
None | NA |
| Organization | Required |
The organization of the item for which the records must be processed. |
Organization code | None | NA |
| Latest Revision | Optional |
Select which structures for the item should be loaded: Structures that are currently effective, structures that will become effective in the future, or all structures for the item.
|
Yes /No /All Yes = Load currently effective structures No = Load future effective structures All = Load all structures |
NA | NA |
| Include Alternate Structure | Optional | If set to Yes, loads the alternate structures specified for the selected item. |
Yes /No |
NA | NA |
Troubleshooting Information
- Any changes made to the structures after the last run of the scheduled process are loaded in the next run.
- The validation errors and warning messages for item structures and organization display in the log file.
- No interactive warning validations are performed.
- After the program is submitted, you can Resubmit, Put on Hold, Cancel Process, and Release Process.
- The list of item names can’t exceed 4000 characters.
- The log will include detailed runtime information including validation results for nonexistent items and organizations, incomplete load warnings, and SQL errors.