General Ledger - EBS (MOSC)

MOSC Banner

What does the SUMMARY_FLAG field in the GL_CODE_COMBINATIONS table?

edited Jan 22, 2020 4:02AM in General Ledger - EBS (MOSC) 5 commentsAnswered

Hi everyone

I have a doubt, in the table gl_code_combinations we have 2 records with the same combination, this it shows us the following error when we try to search the combination or when we try to post in the forms:

APP-FND-01564: ORACLE error 1422 in FDFGVD

Cause: FDFGVD failed due to ORA-01422: exact fetch returns more than requested number of rows.

In this case we change the field summary_flag from "N" to "Y" in one of the records, inactivate it, and we add end date, cause the view have the filter summary_flag != "Y", that fixed the error but don´t know if this is correct or how its can affect to us, we have 1 post record that affect the combination that we inactivated.

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