Manage Incremental Planning Collections Artifacts
Use the Manage Incremental Planning Collections Artifacts scheduled process to create, maintain, drop, or truncate net-change planning collection log tables.
Log tables contain details about the changes made to entities that are supported in net-change or incremental collections. These changes include deleting, updating, or creating an entity or an attribute of an entity. For example, details might show changes made to the date or to the quantity of a purchase order schedule.
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 create, maintain, drop, or truncate net-change planning collection log tables.
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 log tables, and who are responsible for reviewing and addressing issues related to incremental-refresh or net-change collections log tables 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 at any time based on your requirements. It’s recommended to not run the process 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 Manage Incremental Planning Collections Artifacts process. | Drop | Select Yes to drop log tables for one or more collection entities. | Drop log tables for net change or incremental refresh for the selected entities. |
Truncate | Select Yes to truncate log tables for one or more collection entities. | Truncate log tables for net change or incremental refresh for the selected entities. | |||
Create | Select Yes to create log tables for one or more collection entities. | Create log tables for net change or incremental refresh for the selected entities. | |||
Repair | Select Yes to repair log tables for one or more collection entities. | Repair log tables for net change or incremental refresh for the selected entities. | |||
Approved Supplier Lists | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Bookings History Measures | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Calendars | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Category Set | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Currencies | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Customer Item Substitution Relationships | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Customer | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Demand Classes | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
External Forecasts | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Fiscal Calendars | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Forecast Measures | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Geographies | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Item | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Item Costs | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Item Structures | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Item Subinventories | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Movement Requests | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
On Hand | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Order Promising Configuration Rules | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Order Orchestration Reference Objects | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Organization Parameters | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Planner | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Planned Order Supplies | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Planning Attribute Values | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Purchase Orders and Requisitions | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Price List | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Resource Availability | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Resources | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Routings | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Safety Stock Levels | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Sales Order | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Shipments History | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Shipping Methods | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Sourcing | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Subinventories | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Supplier Capacities | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Suppliers | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Transfer Orders | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Unit of Measure | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Work Order Supplies | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Work Definition | Optional | Select the entity whose log table you want to drop, truncate, create, or repair. | Yes or No | NA | NA |
Troubleshooting Information
- You can view the status of the Manage Incremental Planning Collections Artifacts process in the Scheduled Processes work area.
- The validation errors and warning messages that prevented the Manage Incremental Planning Collections Artifacts 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 Incremental Planning Collections Artifacts scheduled process that is 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 error message is related to a time out, resubmit the scheduled process. Also ensure that users haven't made any create, modify, or delete changes to Oracle Supply Chain Execution modules.
- If the reason for the failure isn’t clear from the logs, review the diagnostic logs and contact product support for more help.