General Ledger - EBS (MOSC)

MOSC Banner

Some seeded value sets (like GL_SRS_PERIOD_NAMES) became invalid after an upgrade from 11.5.10.2 to

edited Feb 6, 2013 11:40AM in General Ledger - EBS (MOSC) 1 commentAnswered
Hello,

A number of seeded table-validated value sets were found not working after an upgrade from 11i to 12.1.3.

An example: GL_SRS_PERIOD_NAMES;

We use it in many reports as a parameter. 

It's table validated. Here's the query:

WHERE CLOSING_STATUS IN ('O','C','P')
  AND LEDGER_ID =:$FLEX$.GL_SRS_LEDGER_ID_UNVALIDATED
  AND APPLICATION_ID = 101
  ORDER BY PERIOD_YEAR DESC, PERIOD_NUM DESC

It looks like the issue is with this GL_SRS_LEDGER_ID_UNVALIDATED value set from the query. It appears to have no validation and no values.

Please let us know where can we find info on replacement value sets

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