Invalid or Processing status records - Generate Run Balances

There can be following reasons for processing status

1) Generate run balances process is still running

2) You had PROCESS_TIMEOUT for this process and that limit is reached so process was gracefully terminated.

3) Generate run balances process has been terminated or killed due to some reason

so you can wait till process complete sucessfully in case of process still running.

You can find what are all balances which are in invalid or processing status with following SQL

SELECT * FROM PAY_BALANCE_VALIDATION;

Now you have two options in case of PROCESS_TIMEOUT or termination/killed

OPTION 1: Retry the GRB (Preferred Solution as it starts back up where it left off)

Resp: Responsibility Generate Run Balance was Submitted Under

Nav: Process & Reports > Submit Process & Reports > Single Request

Name: Retry US Payroll Process (US Legislation)

Parameters:

- Process Year: 4712

- Process Type: Magnetic Report

- Process: LOV

The LOV should show the Generate Run Balance process that have executed.

Select the process to retry.

OPTION 2: Start the process over (Note: All previous will be lost)

In order to get the status to change from Processing - you must manually switch the status flag (Contact Support for information concerning how to perform this) from P (Process) to I (Invalid).

Then the process can be submitted again with the MODE parameter set to ALL INVALIDS.

NOTE: That running the ALL BALANCES or ALL INVALIDS (if there is a large quantity) for ASSIGNMENT Level will process for a long time.

Please note that it is recommended that when ever executing the GRB or ARDB for ALL BALANCES or ALL INVALID (if a large amount exist) that the PROCESS_TIMEOUT parameter should be set on the Pay_Action_Parameters table to control the execution time of the process.