Redefine Item Tables
Use the Redefine Item Tables scheduled process to partition the item tables in Oracle Fusion Cloud.
Partitioning database tables helps to improve performance in terms of update and create item records. Items can be partitioned based on item organization for the production table data and batch for the interface table data. Each partition will have multiple organizations or batches. But all the items of one organization in the batch will reside in a single partition. This ensures that the performance improves for querying records, creating records, and updating records.
When to Use
This scheduled process is initiated based on the discussion and recommendation from Oracle support.
Privileges Required
Partition Item Data (EGP_PARTITION_ITEM_DATA_PRIV)
Specifications
Review the following before setting up this scheduled process:
Specification | Description |
---|---|
Job Type | Ad hoc job |
Frequency | On demand |
Time of Day | Long running weekends |
Duration | Variable based on the number of items in the system |
Compatibility | Multiple instances of this job can’t be run in parallel. |
Parameters
Parameter | Optional or Required | Description | Parameter Value | Special Combinations Required | Notes |
---|---|---|---|---|---|
Action | Required | Action that must be performed. |
|
None | None |
Troubleshooting Information
- You can view the status of the Redefine Item Tables process on the scheduled processes UI.
- When the program is submitted, you can Resubmit, Put on Hold, Cancel Process, or Release Process as provided by the Scheduled Processes UI.
- Recommend first to purge interface records before partitioning.
- Invoke this process only after consulting Oracle support. Once the data is partitioned, it can't be undone.