GLXJEENT Change Period Generates Error FRM-40735: ON-UPDATE Trigger No Data Found

(Doc ID 2391278.1)

Last updated on APRIL 25, 2018

Applies to:

Oracle General Ledger - Version 12.2.4 and later
Information in this document applies to any platform.


After migration from AIX to Linux and partitioning of tables GL_JE_HEADERS, GL_JE_LINES
the following error is seen in the journals enter form when try to change journal periods.

From the Journals enter form then select journal - change period from menu.
Select the change period dialog box, enter period and then OK.
A warning dialog box on changing period, select - Yes.
The following Error is seen:
ORA-1403 No Data Found
ORA-1403 No Data Found
FRM-40735 ON-UPDATE trigger raised unhandled exception ORA-1403


 This was not occurring prior to the migration from AIX to Linux and the partitioning of tables GL_JE_HEADERS, GL_JE_LINES.


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