EGL: Error In Journal Edit(GL_JEDIT) Process While Re-Editing The Interunit Journals. (Doc ID 1931219.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

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

Symptoms

When attempting to run Journal Edit(GL_JEDIT) process while Re-Editing the interunit journals the following error occurs.

ERROR
-----------------------
 "File: /u/data002/pt85312b-retail/src/psappeng/aedebug.hSQL error.
  Stmt #: 1623 Error Position: 0 R eturn: 8010 - {DB2 FOR OS/390}{ODBC DRIVER}{DSN10015} ?
  DSNT408I SQLCODE = -206, ERROR: IU_LINE_TYP E IS NOT VALID IN THE CONTEXT WHERE? IT IS USED ? DSNT418I SQLSTATE = 42703 SQLSTATE RETURN CODE
  Failed SQL stmt: DELETE FROM PS_JRNL_IUW4_TAO4 WHERE IU_LINE_TYPE = 'x'
  ABENDED at Step IU_PROCESSOR.A007Wrk4.Delete (SQL) "

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1: Create 2 regular journals(Ex: 'JRNL1', 'JRNL2') and 1 interunit journal(ex: 'JRNL3')
2: Navigate to Edit journal run control page and Add a new run control id
3: Create 2 request for the new Run control id by clicking on '+' button for 'Request' scroll in the runcontrol page
4: In the first request scroll, enter the Business unit and the journal id from as 'JRNL1' and Journal id to as JRNL3'
5: In the Second request scroll, enter the Business unit and the journal id from as 'JRNL3' and Journal id to as JRNL3'
6: Save the page and run the process GL_JEDIT.
7: Process goes to No Success while processing the Second request in the run control page


Cause

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