EGL9.2: Spreadsheet Journal Import(JRNL1_WS) Encountered 'ORA-00904: "TSE_PROC_INSTANCE": invalid identifier' Error After Applying PRP Patch 27020107

(Doc ID 2327990.1)

Last updated on NOVEMBER 17, 2017

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:
-------

Encountered below error while importing journal via Spreadsheet Journal Import (JRNL1_WS) with 'edit Journal(s)' checkbox selected.

Imported 0 Journals – System ID (Unit, Journal ID, Date) Reference,
Description:

Steps to Replicate:
---------------------
1. Create a new sheet using JRNL1_WS spreadsheet template
2. Enter details for journal header. Enter journal lines.
3. Import the Journal with Edit Journal(s) option selected


Error:
------

In IB trace file found:

Error Position: 0
Return: 0 - ORA-00904: "TSE_PROC_INSTANCE": invalid identifier
Statement:
Original Statement: DELETE FROM PS_JRNL_CF_BAL_STG WHERE TSE_PROC_INSTANCE IN (:1, :2)


Changes

 Issue encountered after applying PRP <Patch 27020107>

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