Error When Using 'Show Adjustment' on Element Entry: ORA-01403 (Doc ID 1918488.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to perform an adjustment on an element entry using the 'Show Adjustment' feature, the following error occurs.

ERROR
-----------------------
FRM-40735: ON-INSERT trigger raised unhandled exception ORA-01403.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to the element entry form for an affected employee.
2. Select the element > click to view input values > click show adjustment > select adjustment type > enter value.
4. Save the change and get the error



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