General Ledger - EBS (MOSC)

MOSC Banner

How is the owner of the XLA_GLT... tables determined ?

edited May 19, 2019 5:04AM in General Ledger - EBS (MOSC) 3 commentsAnswered

Hello,

We are are running an eBS 12.2.7.

The SLA creates temporary tables when the accounting is done and transferred to GL.

Those XLA_GLT tables can be dropped by running the "Purge Temporary Journal Import Interface Tables Created By Subledger Accounting" (XLADRPGLT).

The tables are dropped but the synonyms are not.

I was looking at those tables/synonyms and found the owner of the synonyms looks like SYS_2CRRCP7AG1ES7PHTNB7RQPDGMW.

There are 9 different owners (select distinct owner...) :

SYS_5#Q2WF_F4Z0#BQD759X00_EZ62

SYS_7ZOXG5UKED8DQNBMDGKBTT$B3J

SYS_90XJ9K8I2DHK19Q5DOZHRZZP8Z

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center