The process of configuring the adapter includes configuring the adapter from either the Web Console or the Data Management Console, creating Oracle E-Business Suite control tables, and configuring the Remote Services Profile to call the adapter.
You can configure the adapter from either the Web Console or the Data Management Console.
from the Data Management Console, expand the Adapters folder.
The Adapters folder opens.
The Add Adapter to Configuration pane opens.
Default value (-1) indicates that all individual Responsibility ID security rules will be combined. If another value were provided, only that specific Responsibility ID would be used for data access privileges.
Select a profile from the drop-down menu to indicate the level of profile in which to store the CONNECTION_ATTRIBUTES command. The global profile, edasprof.prf, is the default.
If you wish to create a new profile, either a user profile (user.prf) or a group profile if available on your platform (using the appropriate naming convention), choose New Profile from the drop-down menu and enter a name in the Profile Name field (the extension is added automatically).
Store the connection attributes in the server profile (edasprof).
If you wish to create a new profile, either a user profile (user.prf) or a group profile if available on your platform (using the appropriate naming convention), choose New Profile from the drop-down list and enter a name in the Profile Name input box. (The extension is added automatically.)
Next step: When the configuration is complete, the next step is to create adapter control tables by running the oesfiles procedure. For details, see How to Create the Adapter Control Tables .
. . . -* APP PATH OESSEC IBISAMP -* ENGINE SQLORA SET CONNECTION_ATTRIBUTES VIS VIS/apps,9AA42BAE9EC283A8 SET USER=ORAAPPS ENGINE ORAAPPS SET APPS RESP_ID -1
You can create the adapter control tables from either the Web Console or the Data Management Console.
from the Data Management Console, right-click the server and select Connect.
0 NUMBER OF RECORDS IN TABLE= 2546 LINES= 2546
ORAUSER.FOC: Oracle eBusiness Suite User Info
0 NUMBER OF RECORDS IN TABLE= 42094 LINES= 42094
ORASYSF.FOC: Oracle eBusiness Suite Table Info
0 NUMBER OF RECORDS IN TABLE= 10290 LINES= 10290
ORAUSRAP.FOC: Oracle eBusiness Suite App Info
<VER1> # Site Profile: Adapter Oracle E-Business Suite # Description: Enables remote user authentication against # the Oracle E-Business Suite and passes necessary # parameters to set the system context for the user # Set default responsibility ID and application ID # Calling application must set and validate the resp ID # and appl ID before passing them to the procedure. If # these are not validated they will still be passed, but # invalid data may be returned for the user. If no values # are set, these defaults will be used in setting the system # context. In which case, certain database views will be # unusable. # Bind MR User to WF User <ifdef> IBIMR_user IBIC_user=&IBIMR_user <endif> <ifdef> IBIMR_pass IBIC_pass=&IBIMR_pass <endif> # Responsibility ID (IBIWF_respid) <ifndef> IBIWF_respid IBIWF_respid=0 <endif> # Application ID (IBIWF_applid) <ifndef> IBIWF_applid IBIWF_applid=0 <endif> # Execute parameterized call to OESLOGIN _site_profile=&_site_profile\EX OESLOGIN OES_RESP_ID=&IBIWF_respid, _site_profile=&_site_profile\n OES_APPL_ID=&IBIWF_applid, PASSTHRU=ON _site_profile=&_site_profile\n-RUN # Enable these &variables to be passed to the server <SET> IBIWF_respid(PASS) <SET> IBIWF_applid(PASS)