General Ledger - EBS (MOSC)

MOSC Banner

GLBV_CHARTS_OF_ACCOUNTS view is not available in 12.2.6 instance

edited Nov 16, 2018 4:02AM in General Ledger - EBS (MOSC) 2 commentsAnswered

GLBV_CHARTS_OF_ACCOUNTS view is not available in 12.2.6 instance, We are just using this to fetch the "CHART_OF_ACCOUNTS_ID" based on "CHART_OF_ACCOUNTS_NAME". Below is the logic for the same. Kindly suggest us the alternative way of fetching the details. Also let us know the impact and why oracle obsoleted these tables in 12.2.x.

SELECT CHART_OF_ACCOUNTS_ID

                       FROM apps.GLBV_CHARTS_OF_ACCOUNTS

                      WHERE CHART_OF_ACCOUNTS_NAME = 'Global COA'

Thanks,

Avinash

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