XLADRPGLT: Purge Temporary Journal Import Interface Tables Created by Subledger Accounting with Errors ORA-06550 PLS-00201 (Doc ID 1440204.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle General Ledger - Version 12.0.4 and later
Oracle Subledger Accounting - Version 12.0.4 and later
Information in this document applies to any platform.
XLADRPGLT program: Purge Temporary Journal Import Interface Tables Created By Subledger Accounting

*** Checked for Relevance on 23-May-2012 ***

Symptoms

Running the program "Purge Temporary Journal Import Interface Tables Created By Subledger Accounting" gives the following error in the log file:

XLADRPGLT module: Purge Temporary Journal Import Interface Tables Created By Subledger Accounting
....
ORACLE error 6550 in FDPSTP

Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00201: identifier 'XLA_PURGE_PKG.DROP_GLT' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

----

 

Checking the versions in the package shows that the file is not installed

strings -a $XLA_TOP/patch/115/sql/xlapurge.pkb |grep '$Header'

Returns "No such file"

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