ce_ldr% valuesets missing values when called from a custom pl/sql concurrent program
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.