My Oracle Support Banner

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

Last updated on FEBRUARY 27, 2019

Applies to:

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


Journal Import concurrent requests fail with error for all submissions.

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
ORA-01403: no data found

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

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


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

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