Setting Up Global Security Profile for Extracting Data from AP_INVOICES_V for EBS R12xxx

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:

Log into the EBS R12xxx database instance using apps user.

Run queries such as the following example queries and get the user_id and responsibility_id for 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

Run the following query in the EBS R12xxx database instance (pass the value based on the user/responsibility combination identified in previous step):
```
Begin
FND_GLOBAL.APPS_INITIALIZE(&l_user_id,&l_responsibility_id,200);
MO_GLOBAL.INIT('SQLAP');
End;
```
Verify the data in AP_INVOICES_V
The view should retrieve data for all organizations in AP.
Extract the data from AP_INVOICES_V.
You can now proceed with the steps for extraction of data from EBS source.