My Oracle Support Banner

R12: ORA-00907: GLLDEL, Program - Delete Journal Import Data (Doc ID 1097747.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle General Ledger - Version 12.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 13-Jun-2013***

Executable:GLLDEL - Delete Journal Import Source


Symptoms

When attempting to delete data from GL_INTERFACE, using the program Delete Journal Import Data (GLLDEL) the following error occurs.

ERROR
-----------------------
R_LDEL0008: An internal error has been encountered while executing a sql statement.
R_LDEL0009: The following will show the contents of the sqlca and oraca.
R_LDEL0010: This information is intended primarily for
R_LDEL0011: support representatives and/or database administrators.

*****************************************************
R_LDEL0012: sqlcode: -907
R_LDEL0013: sqlerrmc:
ORA-00907: missing right parenthesis

*****************************************************
R_LDEL0018: orastxtc:



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Choose the "Program - Delete Journal Import Data"
2. Enter the source and the other parameters 
3. Submit the program


 

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.