1. Scheduled Processes for SCM
  2. Redefine Item Tables

Redefine Item Tables

Use the Redefine Item Tables scheduled process to partition the item tables in Oracle Fusion Cloud Applications.

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.
  • Partition Item Data: Partitions item interface table data and production table data. The interface table data is partitioned based on the batch ID and the production table data is partitioned based on the organization ID and subpartitioned based on the item ID.
  • Delete Unused Partition: Deletes the partition. You can delete the partition when you purge all or some interface records. You can use this action to remove or delete partitions that don’t have any data.
 None None

Troubleshooting Information

  • You can view the status of the Redefine Item Tables process in the Scheduled Processes work area.
  • When the program is submitted, you can Resubmit, Put on Hold, Cancel Process, or Release Process as provided by the Scheduled Processes work area.
  • Purge interface records before partitioning.
  • Use this process only after consulting Oracle Support. Once the data is partitioned, it can't be undone.