ORA-01779 Error Occurs When Creating External/ Manual Payment with "Other form of Payment"
(Doc ID 2391726.1)
Last updated on DECEMBER 11, 2023
Applies to:
Oracle Payroll - Version 12.1 to 12.1 HRMS RUP11 [Release 12.0 to 12.1]Oracle Payroll - Version 12.2 to 12.2 HRMS RUP12 [Release 12.2]
Information in this document applies to any platform.
This note provides a brief overview of
Symptoms
Problem Statement:
When Navigating to FastPath > External/Manual Payment and attempting to create External/Manual Payment with method "Other form of Payment", "Check Number" field is enterable and mandatory. Following error occurs when saving the record.
ORA-01779: cannot modify a column which maps to a non key-preserved table
FRM-40508: ORACLE error: unable to INSERT record.
FRM-40508: ORACLE error: unable to INSERT record.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Log in with HRMS Responsibility.
- Go to FastPath > External/Manual Payments.
- Enter mandatory field Check Number.
- Select Method "Other form of Payment".
- Save.
- Error occurs.
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 |
Cause |
Solution |
References |