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:

Supply Planning
Demand and Supply Planning
Sales and Operations Planning
Demand Planning
Replenishment Planning
Global Order Promising
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	A spontaneous 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 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.