My Oracle Support Banner

GLXJEENT Change Period Generates Error FRM-40735: ON-UPDATE Trigger No Data Found (Doc ID 2391278.1)

Last updated on DECEMBER 03, 2019

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.


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

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