My Oracle Support Banner

GLPPOSS: Posting Errors: error detected in glpcsl() - ORA-01458: invalid length inside variable character string (Doc ID 3027995.1)

Last updated on JUNE 14, 2024

Applies to:

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

Symptoms


Attempting to post a manual journal batch in General Ledger shows error in the log file.

SHRD0118: Updated Yes record(s) in table: sl_seq_flag
SHRD0180: glpcsl() - Performing action >> insert_sl_batches...
SHRD0117: Inserted 1 record(s) into GL_JE_BATCHES
SHRD0180: glpcsl() - Performing action >> insert_1sl_headers...
PERF0005: Oracle error detected in glpcsl() - ORA-01458: invalid length inside variable character string
PPOS0002: Posting terminated with fatal errors


The issue can be reproduced at will with the following steps:
1. GL Responsibility >Journals > Enter > Find
2. Query for a specific subledger journal > Post button
3. Observe GLPPOSS: Posting: Single Ledger concurrent runs and errors

Changes

Create a new Secondary Ledger with Conversion Level: Journal.

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!

In this Document
Symptoms
Changes
Cause
Solution
References


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