AutoAccounting: Need Help Navigating to Lookup Set with SQL Statement
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