My Oracle Support Banner

AME Journal Batch Approval Error: ORA-01400: Cannot Insert NULL Into ("GL"."GL_WF_ACTION_HISTORY"."WF_APPROVER_NAME"). (Doc ID 2850249.1)

Last updated on MAY 23, 2022

Applies to:

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


When submitting AME journal batch for approval, the following error occurs WF notification

ERROR Message: ORA-01400: cannot insert NULL into ("GL"."GL_WF_ACTION_HISTORY"."WF_PREPARER_NAME"

Error Stack: GL_AME_JE_WF_PKG.insertactionhistory(Inserting into the audit table for the approver notification sent., ORA-01400: cannot insert NULL into ("GL"."GL_WF_ACTION_HISTORY"."WF_APPROVER_NAME")) GL_AME_JE_WF_PKG.Insert_Action_History(Insert_Action_History: 004 - Calling insertActionHistory.,
ORA-01400: cannot insert NULL into ("GL"."GL_WF_ACTION_HISTORY"."WF_APPROVER_NAME")) Wf_Engine_Util.Function_Call(GL_AME_JE_WF_PKG.INSERT_ACTION_HISTORY, GLBATCH, 1026-21, 301746, RUN)

The issue can be reproduced at will with the following steps:
1. Go to General Ledger Responsibility
2. Journal > Enter
3. Enter the Journal and submit for Approval.
4. Then go to Workflow Administrator Responsibility
5. Status > Monitor
6. Query the notification with 'Type Internal Name' as 'GLBATCH' and
    Item Key with '&Batch id'.
7. Open the error out notification activity.

Due to this issue, journal cannot be posted


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.