Payables and Cash Management - EBS (MOSC)

MOSC Banner

ce_ldr% valuesets missing values when called from a custom pl/sql concurrent program

edited Aug 20, 2021 7:36AM in Payables and Cash Management - EBS (MOSC) 4 commentsAnswered ✓

EBS R12.1.3

I have a requirement to create a Concurrent Program (custom pl/sql wrapper) that will amongst other things, call the seeded Bank Statement Loader program.  I have used the same valuesets that are attached to the Bank Statement loader (CE_LDR%); however, when I try to enter my parameter for a specific bank account, the bank account that I need is not there.

I traced this to an issue with view  (ce_security_profiles_v).

When I initialize in pl/sql tool  (same user_id, app, responsibility)

example....

fnd_global.apps_initialize(2089,75846, 2003)

cep_standard.init_security;

and query against the view; I get the correct results. However when I login to the application with the same credentials and try to submit the custom concurrent program from the concurrent program submit screen, I do not get the same values in the drop down for bank branch and account.

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