My Oracle Support Banner

Error In Quick Pay Run "FRM-40735 ON-INSERT Trigger Raised Unhandled Exception ORA-01722" (Doc ID 2891189.1)

Last updated on FEBRUARY 08, 2023

Applies to:

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

Symptoms

R12.HR_PF.C.Delta.15 12.2.11 on Application


User getting below error on quick pay window at the bottom while running quick pay for an employee



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




STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Login to HRMS Manager -> Enter and Maintain

2. Query for the errored employee -> save quick pay run

3. Could see above error at the bottom of the form



Changes

 Statutory information Soft coded flexfield enabled for Assignment. 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.