ORA-12899: Value Too Large For Column "Synergen"."Sa_job_manager_log"."Status"

Last updated on OCTOBER 16, 2016

Applies to:

Symptoms

The COST ASSET Job fails with the following error if the ALLOCATE COSTS TO ASSETS option of the WORK ORDER PROCESSING Business Rule set to OFF when there are records which need to be processed:

Error in Insert into sa_job_manager_log ORA-12899: value too large for column
"SYNERGEN"."SA_JOB_MANAGER_LOG"."STATUS" (actual: 38, maximum: 30)

Under these circumstances, the COST_ASSET job attempts to return the following message:

'ALLOCATE COSTS TO ASSETS is set to OFF'

However the STATUS column in SA_JOB_MANAGER_LOG (which is where the error message is written to ) has a length of only 30 characters.

STEPS TO REPRODUCE:

Create a Work Order
Add Assets to the Work Order Task Asset List
Activate the Work Order
Incur some costs against the Work Order (for example create a Timesheet that references the Work
Order and Post it).
Finish the Work Order Task.
Run Batch to finish the WO Header
Set the ALLOCATE COSTS TO ASSETS option of the WORK ORDER PROCESSING Business Rule set to OFF
Make sure the COST ASSET job in the Batch Job Control Business Rule is set to YES
CLOSE the Work Order
Run Batch
Check the Job Manager Log for the Cost Asset Job. It fails with the error 'ORA-12899: value too
large for column "SYNERGEN"."SA_JOB_MANAGER_LOG"."STATUS" (actual: 38, maximum: 30)'

Cause