Projects - EBS (MOSC)

MOSC Banner

AutoAccounting: Need Help Navigating to Lookup Set with SQL Statement

edited Feb 5, 2014 7:28PM in Projects - EBS (MOSC) 2 commentsAnswered ✓

Hi All-

We're running into an AA issue where the user is getting a "cannot create flexfield" error. It's a new expenditure type and I'm certain the issue is that a lookup set needs to be updated, however, the rule in question uses SQL and not a standard AA lookup set in PA. I can't find the lookup set anywhere and I'm hoping that someone here can steer me in the right direction.

Here's the navigation:

Bring up Misc Trans Clearing Account

In the second segment (Account), I see the rule is MISC CLEARING ACCOUNT

I query up that rule and I see that it is derived using the following SQL: SELECT (XYZ_PA_AUTOACCT_CLR_ACCT.misc_clear_acct(:1)) from dual

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