General Ledger - EBS (MOSC)

MOSC Banner

Querying GL_BALANCES_V in 11i

edited Feb 27, 2020 5:35AM in General Ledger - EBS (MOSC) 6 commentsAnswered ✓

Hi

Are you able to help me with my query please.

I am trying to extract GL Balance data from an 11i instance in both entered and converted currency for migration into R12.

I am in fact intereeted in GL_BALANCES_V.FUNCTIONAL_YEAR_TO_DATE value - this is not available in GL_BALANCES table.

(This is the YTD Converted value in GL SYSADMIN > Inquiry > Account form.

When I querying GL_BALANCES_V from SQL*plus - the records are only displaying values in SET_OF_BOOKS_ID, PERIOD_NAME etc, but all other columns including CODE_COMBINATION_ID, FUNCTIONAL_YEAR_TO_DATE are blank. (FND_GLOBAL.APPS_INITIALIZE is not effective either)

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

EBS GL Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center