Journal Import Throws Error: sqlerror trapped at get_fixed_ctype , ORA-01403: no data found (Doc ID 2300601.1)

Last updated on SEPTEMBER 08, 2017

Applies to:

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

Symptoms

Journal Import concurrent requests fail with error for all submissions.

ERROR
Error in: gllsys
Function return status: 0
Function Err Message: sqlerror trapped at get_fixed_ctype
Function warning number: -1
*****************************************************
sqlcaid: sqlabc: 0 sqlcode: 1403 sqlerrml: 25
sqlerrmc:
ORA-01403: no data found

sqlerrp: sqlerrd: 0 0 0 43 0 538976288
sqlwarn: sqltext:
*****************************************************SHRD0044: Process logging off database and exiting ...


STEPS
The issue can be reproduced at will with the following steps:
1. GL Responsibility > Journal > Import > Run 
2. Journal Import program is thrown
3. Observe it errors out for all requests

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