Use these instructions to set up the global security profile for extracting data from
AP_INVOICES_V for EBS R12xxx.
Ensure that you perform the following steps before you extract the data for EBS R12xxx from the database instance for Accounts Payable Fact group in Financials Offering.
To set the global security profile for extracting data from
AP_INVOICES_V for EBS R12xxx:
responsibility_idfor a user with Multi-org access having the global security profile set:
Example queries for an Operations user with Payables Vision Operations (USA) responsibility:
select USER_ID,USER_NAME from FND_USER where USER_NAME = 'OPERATIONS'; --1318 select APPLICATION_ID,RESPONSIBILITY_ID,RESPONSIBILITY_NAME from FND_RESPONSIBILITY_VL where APPLICATION_ID=200 and RESPONSIBILITY_NAME ='Payables, Vision Operations (USA)'; --50554
Begin FND_GLOBAL.APPS_INITIALIZE(&l_user_id,&l_responsibility_id,200); MO_GLOBAL.INIT('SQLAP'); End;