My Oracle Support Banner

EGL9.2: GL_ADB_POST Process Fails With "ORA-01407 Cannot Update" Error While Running the GL Journal Posting Process (Doc ID 2412203.1)

Last updated on JULY 03, 2018

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

 Issue:
-------
GL_ADB_POST Process Fails With "ORA-01407 Cannot Update" Error While Running the GL Journal Posting Process

 

Steps to Replicate:
---------------------

1. Set Up Ledgers For A Unit as below;
1) Definition Tab
Checking On: Report Average Balance
Checking Off: Maintain Balances by Date Code
Checking On: Filter Posted Activity
ADB Calendar: D1
2) Definition Tab - Filter link
Specify Asset, Liability and Equity
3) Journal Post Option
Unchecking Do Not Post Future-Dated Jrnls
2. Create a new chartfield with future-dated effective date
3. Create a journal with future-dated accounting date
4. Edit Journal
5. Mark journals for Posting
6. Run Post Journal

Please follow the replication screenshots for more details.

 

Error:
------
ORA-01407: cannot update
("EMDBO"."PS_LEDG_ADB3_TAO4"."ACCOUNT_TYPE")

 

Changes

 

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!


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