Procurement - EBS (MOSC)

MOSC Banner

What table stores requisition preferences in v12.2.5?

edited Apr 4, 2017 9:17AM in Procurement - EBS (MOSC) 2 commentsAnswered ✓

R12.2.5 Purchasing - Internal Requisitions

I'm trying to write a trigger-based alert that compares requisition charge accounts to those set in preferences.  We have a workflow that builds requisition charge accounts to avoid coding errors, but when a user puts in an account combo in their preferences, it overrules everything.  But in order to write such an alert to compare these two things, I need to read the user's requisition preferences and I don't know where to find them.

Here is a visual of what I'm trying to find in a table:

Where are requisition preferences stored?  I'd imagine that it is stored as a GL CCID somewhere.

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