Manage Planning Collections Data Storage Objects
Use the Manage Planning Collections Data Storage Objects scheduled process to list or repair database partitions used by Oracle Fusion Cloud Supply Chain Planning.
There are two types of database partitions:
- Database partitions for instances. An instance database partition is created and linked to a source system, which is created by the Manage Planning Source Systems task. An instance partition stores the data related to a specific source system.
- Database partitions for plans. A plan database partition is created and linked to a plan, which is created by the Manage Plans task. A plan partition stores data related to a specific plan.
The process is applicable to these products:
- Oracle Supply Planning
- Oracle Demand and Supply Planning
- Oracle Sales and Operations Planning
- Oracle Demand Planning
- Oracle Replenishment Planning
- Oracle Global Order Promising
- Oracle Backlog Management
When to Use
Use this process to retrieve a list of database partitions for source systems or plans, or to repair any issues related to database partitions that were identified during Oracle Supply Chain Planning processes.
Privileges Required
- Perform Order Orchestration and Planning Data Collection (MSP_PERFORM_ORDER_ORCHESTRATION_AND_PLANNING_DATA_COLLECTION_PRIV)
Specifications
Review these specifications before setting up this scheduled process:
Specification | Description |
Job Type | Ad hoc job. It's recommended that it not be scheduled. To be submitted by users who have an understanding of database partitions and are responsible for reviewing and addressing issues related to database partitions in Oracle Supply Chain Planning |
Frequency | When required, on an as-needed basis. |
Time of Day | After work hours is preferred, but it can be submitted any time based on your requirements. It’s recommended to run the process while users are not working on the plan, or when the data-collection process is running. |
Duration | Typically, a few minutes. However, the time might vary based on data and other conditions. |
Compatibility | There should be only one instance of the job running at any one time. |
Parameters
Parameter | Optional or Required | Description | Parameter Value | Special Combinations Required | Notes |
Action | Required | Action to be performed by the Manage Planning Collections Data Storage Objects process. |
List |
None | Lists the database partitions. |
Repair | None | Repairs the database partitions. If the database table has a missing or excess partition, the process will repair the issue by creating the missing partition or deleting the excess partition. |
Troubleshooting Information
- You can view the status of the Manage Planning Collections Data Storage Objects process in the Scheduled Processes work area.
- The validation errors and warning messages that prevented the Manage Planning Collections Data Storage Objects from completing display in the error log.
- After you submit the scheduled process, you can perform any of these tasks in
the Scheduled Processes work area:
- Resubmit it
- Put it on hold
- Cancel the process
- Release the process
- For a long-running Manage Planning Collections Data Storage Objects process that's not finishing and appears to be stuck, click the Cancel Process button and then resubmit the job.
- If the job fails:
- Review the error messages in the log file.
- If the reason for the failure isn’t clear from the logs, review the diagnostic logs and contact product support for more help.