BATCH SCHEDULER CRASHES WITH ERRORS ORA-20998/ALG-01440 (Doc ID 2045499.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Health Insurance Claims Management - Version 10.14.2.3 and later
Information in this document applies to any platform.

Symptoms

On Production : 10.14.2.3 version, Technology

Batch scheduler crashes with errors ORA-20998/ALG-01440

17 14:26:53:(start_job - sys_sav_pck.start_job) ORA-20998: Transactie mislukt - 1 melding(en)! Eerste melding: ALG-01440: De gegevens van een beeindigde scriptaanvraag kunnen niet worden gewijzigd. (14399722).
ORA-06512: in "OZG_OWNER.QMS_TRANSACTION_MGT", regel 1623
ORA-06512: in "OZG_OWNER.CG$AUS_ALG_SCRIPT_AANVRAGEN", regel 172
ORA-04088: Fout bij uitvoering van trigger 'OZG_OWNER.CG$AUS_ALG_SCRIPT_AANVRAGEN'.
ORA-06512: in "OZG_OWNER.SYS_SAV_PCK", regel 4085
ORA-06512: in regel 1


ERROR
-----------------------
ORA-20998: Transaction failed
ALG-01440: The details of a terminated batch request cannot be modified. (#1#).

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Not possible to reproduce

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, other processing may go wrong, potentially targets can not be met (payment terms, etc.)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms