My Oracle Support Banner

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 AUGUST 29, 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:
-------

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

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.