Payables and Cash Management - EBS (MOSC)

MOSC Banner

Verify user profiles that have AP: Use Invoice Batch Controls set to No

edited Sep 4, 2019 3:03AM in Payables and Cash Management - EBS (MOSC) 4 commentsAnswered ✓

Good Morning

We are currently trying to find out which of our users have AP: Use Invoice Batch Controls set to No . We are unable to locate the site flag using the FND_PROFILE_OPTIONS_VL table.

We are looking to write an sql script to extract this information however we are unable which table or tables should be used to locate users who have  AP: Use Invoice Batch Controls set to No

May I ask for advice please?

Thanking you in advance

Noel

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

EBS Payables Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center