Track Processing Progress and Review Results

After you run the Create Cost Accounting Distributions process, you can view the status of the process. On the Create Costs Accounting Distributions page, search for the run control and click View Status.

The status for a run control provides the overall status of the Create Cost Accounting Distributions process, the process start time, the process end time if the process has completed, and the process duration.

The status page includes this information for each of the processors:

  • The current status of the processor. The applicable values are Not started, Processing, Completed, and Not scheduled. If a processor isn't selected for the run control, then the corresponding status will be Not scheduled.

  • The commit limit loop count. This is applicable only for the Cost Processor, COGS Recognition, and Cost Distribution processors.

  • If the processor is running, the start date and time in your preferred time zone.

  • If the processor has completed, the end date and time in your preferred time zone.

  • The duration for which the processor ran.

  • The inner loop count. This is applicable only for the Cost Processor.

  • The current step, total steps, and the duration for which the current step has been running.

When the process is running, the status page also displays a ticker that lets you know when the last SQL commit was completed and for how long the current SQL has been running.

The amount of time the process takes to complete depends on the number and complexity of transactions to be processed. If you run the process infrequently and have a large number of transactions, the process would require more time to complete than if you run the process often or have less transactions to process.

Also, the commit limit and the number of transactions to be processed by the run control determine the number of commit limit loops required to complete the process. If you're processing a large number of transactions, multiple commit limit loops may be required. In the case of processing transactions that include transfer orders or work orders, the Cost Processor may have multiple inner loops within a commit loop before moving to the next processor. Also, the processors that run as part of the Create Cost Accounting Distributions process contain multiple steps.

By frequently reviewing the detailed status of each process run, you can get a better understanding of the number of commit limit loops required to complete the process and the overall time required to complete the process.

View Detailed Timings

When the processor runs for multiple commit limit loops, the View Status shows the information for the current commit limit loop. You can download the data for the prior commit limit loops in a spreadsheet format by clicking View Detailed Timings. The spreadsheet provides detailed step timings.

The spreadsheet contains the date and time when the report was generated, the run control name, process ID, commit limit, number of commit limit loops, process start and end time, process status, and process duration.

It also includes this summarized information for each processor:

  • Commit limit loop count, except for Preprocessor

  • Current step / Total steps

  • Start Time of the processor

  • End time of the processor

  • Duration

  • Inner loop count for Cost Processor

The Details part of the timing spreadsheet, provides this information:

  • The start time, end time, and duration of each step in the processor, for all the processors selected as part of the run control.

  • For the Cost Processor, COGS Recognition, and Cost Distribution processors, this detailed step-level timing information is provided for each commit loop.

  • For the Cost Processor this detailed step-level timing information is also provided for each inner loop within a commit loop.

You can also view the status and get the detailed timings spreadsheet for completed run controls.

Review Process Results

After running the cost processors, check processing results in the Cost Accounting work area:

  • View warning and error messages on the Review Cost Accounting Processes page.

  • See additional warning and error messages specific to each transaction on the Transaction Errors tab of the Review Cost Accounting Distributions page.

Purge Prior Cost Accounting Process Errors

If a run control not in use for 60 or more days, the Purge Prior Cost Accounting Process Errors automatically deletes the corresponding cost processing error summary and details, resulting in improved page and process performance.