After Running XLADRPGLT: Program "Purge Temporary Journal Import Interface Tables Created by Subledger Accounting" Observed Many Invalids XLA_GLT% Synonyms in CUSTOM SCHEMA (Doc ID 2898210.1)

Last updated on MARCH 22, 2024

Applies to:

Symptoms

After running XLADRPGLT: Program "Purge Temporary Journal Import Interface Tables Created by Subledger Accounting" observed many invalids XLA_GLT% synonyms in CUSTOM schema.

The related tables and synonyms were deleted by this program in APPS schema, but not for CUSTOM schema too.

Have the related Patch 10382869 which will purge the synonyms for the purged XLA_GLT% tables, but these were not purged from CUSTOM schema, only from APPS schema.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. GL Super User responsibility > View requests> Submit a new request
2. Run Purge Temporary Journal Import Interface Tables Created By Subledger Accounting to remove the XLA_GLT% tables and synoyms
3. Tables deleted and synonyms with APPS schema, but we could see CUSTOM_APPS schema synonyms are not removed and in invalid status
    Used the below sql query to check for CUSTOM_APPS schema:

Changes

Cause

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