When I navigate to Home > Financial Management > Post to WIP page, enter a date range then click on 'Apply' > 'Post' button
I get 'System Error. Contact system administrator' no output is generated in log file.
When I run a Post To Wip job then the following error gets generated in the bg-ca.log file.
ERROR 2018-05-22 13:01:26,914 [Dispatch Post to WIP : bg@serverexample (tenant=clarity)] niku.njs (clarity:admin:23250649__9590FC00-4FAC-4B3C-A3BF-24BD0A725488:Post to WIP) Error executing job: 5077036
com.niku.union.persistence.PersistenceException:
SQL error code: 21000
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-21000: error number argument to raise_application_error of -1 is out of range
ORA-06512: at "SCHEMA.PAC_PRC_POSTTOWIPS_SP", line 961
ORA-06512: at "SCHEMA.PAC_PRC_POSTTOWIP_JOB_SP", line 201
ORA-06512: at "SCHEMA.PAC_PRC_POSTTOWIP_JOB_SP", line 201
ORA-06512: at line 1
The stored procedure 'PAC_PRC_POSTTOWIPS_SP' is erroring when attempting to insert data into the tables: PPA_WIP and PPA_WIP_VALUES
This could be because of wrong filtering, or database sequencing error, or environmental issue