How to Run_HRMS_DBScripts.sh for OIM EBS HRMS Integration
Introduction-When you are doing OIM-EBS HRMS integration, there is requirement to create integration service account for this integration. After you download the connector from Oracle website, you have to copy connector folder in the Linux server location where EBS HRMS is installed. Unzip the connector bundle and from the script folder, execute following script. Enter following inputs as per your environment.
[oracle@ipod-elphx01 scripts]$ sh Run_HRMS_DBScripts.sh
ORACLE_HOME is ::
/u01/app/oracle/EBSPH01/11.2.0.4.15
Enter the System User Name ::
system
Enter the name of the database ::
EBSPH01
Would you like to create new user for connector operations [y/n]:y
Are you running this script with EBS target 12.1.x [y/n]:y
SQL*Plus: Release 11.2.0.4.0 Production on Fri May 8 13:46:30 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connecting to APPS
Enter password:
Connected.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Package created.
Package body created.
Package created.
Package body created.
Package created.
Package body created.
Package created.
Package body created.
Disconnecting APPS
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Connecting to system
Enter password:
Connected.
Enter New database Username to be created::EBS_OIM_HR
Enter the New user password::
old 1: CREATE USER &USERNAME identified by &USERPWD
new 1: CREATE USER EBS_OIM_HR identified by B0arsHead123
User created.
old 1: alter user &USERNAME enable editions
new 1: alter user EBS_OIM_HR enable editions
User altered.
grant connect, resource to EBS_OIM_HR
old 1: grant connect, resource to &USERNAME
new 1: grant connect, resource to EBS_OIM_HR
Grant succeeded.
grant create synonym to EBS_OIM_HR
old 1: grant create synonym to &USERNAME
new 1: grant create synonym to EBS_OIM_HR
Grant succeeded.
grant alter any procedure to EBS_OIM_HR
old 1: grant alter any procedure to &USERNAME
new 1: grant alter any procedure to EBS_OIM_HR
Grant succeeded.
grant execute on APPS.HR_EMPLOYEE_API to EBS_OIM_HR
old 1: grant execute on APPS.HR_EMPLOYEE_API to &USERNAME
new 1: grant execute on APPS.HR_EMPLOYEE_API to EBS_OIM_HR
Grant succeeded.
grant execute on APPS.HR_PERSON_API to EBS_OIM_HR
old 1: grant execute on APPS.HR_PERSON_API to &USERNAME
new 1: grant execute on APPS.HR_PERSON_API to EBS_OIM_HR
Grant succeeded.
grant execute on APPS.HR_CHANGE_START_DATE_API to EBS_OIM_HR
old 1: grant execute on APPS.HR_CHANGE_START_DATE_API to &USERNAME
new 1: grant execute on APPS.HR_CHANGE_START_DATE_API to EBS_OIM_HR
Grant succeeded.
grant execute on APPS.HR_PERSON_ADDRESS_API to EBS_OIM_HR
old 1: grant execute on APPS.HR_PERSON_ADDRESS_API to &USERNAME
new 1: grant execute on APPS.HR_PERSON_ADDRESS_API to EBS_OIM_HR
Grant succeeded.
grant execute on APPS.HR_PERSON_ADDRESS_BK1 to EBS_OIM_HR
old 1: grant execute on APPS.HR_PERSON_ADDRESS_BK1 to &USERNAME
new 1: grant execute on APPS.HR_PERSON_ADDRESS_BK1 to EBS_OIM_HR
Grant succeeded.
grant execute on APPS.HR_API to EBS_OIM_HR
old 1: grant execute on APPS.HR_API to &USERNAME
new 1: grant execute on APPS.HR_API to EBS_OIM_HR
Grant succeeded.
grant execute on APPS.HR_CONTINGENT_WORKER_API to EBS_OIM_HR
old 1: grant execute on APPS.HR_CONTINGENT_WORKER_API to &USERNAME
new 1: grant execute on APPS.HR_CONTINGENT_WORKER_API to EBS_OIM_HR
Grant succeeded.
grant execute on APPS.HR_ASSIGNMENT_API to EBS_OIM_HR
old 1: grant execute on APPS.HR_ASSIGNMENT_API to &USERNAME
new 1: grant execute on APPS.HR_ASSIGNMENT_API to EBS_OIM_HR
Grant succeeded.
grant execute on APPS.FND_GLOBAL to EBS_OIM_HR
old 1: grant execute on APPS.FND_GLOBAL to &USERNAME
new 1: grant execute on APPS.FND_GLOBAL to EBS_OIM_HR
Grant succeeded.
grant select on APPS.PER_ALL_ASSIGNMENTS_F to EBS_OIM_HR
old 1: grant select, update on APPS.PER_ALL_ASSIGNMENTS_F to &USERNAME
new 1: grant select, update on APPS.PER_ALL_ASSIGNMENTS_F to EBS_OIM_HR
Grant succeeded.
grant select on APPS.PER_PEOPLE_F to EBS_OIM_HR
old 1: grant select, update on APPS.PER_PEOPLE_F to &USERNAME
new 1: grant select, update on APPS.PER_PEOPLE_F to EBS_OIM_HR
Grant succeeded.
grant select on APPS.PER_PERSON_TYPES to EBS_OIM_HR
old 1: grant select, update on APPS.PER_PERSON_TYPES to &USERNAME
new 1: grant select, update on APPS.PER_PERSON_TYPES to EBS_OIM_HR
Grant succeeded.
grant select on APPS.PER_PERIODS_OF_SERVICE to EBS_OIM_HR
old 1: grant select, update on APPS.PER_PERIODS_OF_SERVICE to &USERNAME
new 1: grant select, update on APPS.PER_PERIODS_OF_SERVICE to EBS_OIM_HR
Grant succeeded.
grant select on APPS.PER_PERIODS_OF_PLACEMENT to EBS_OIM_HR
old 1: grant select, update on APPS.PER_PERIODS_OF_PLACEMENT to &USERNAME
new 1: grant select, update on APPS.PER_PERIODS_OF_PLACEMENT to EBS_OIM_HR
Grant succeeded.
grant select on APPS.PER_ADDRESSES to EBS_OIM_HR
old 1: grant select, update on APPS.PER_ADDRESSES to &USERNAME
new 1: grant select, update on APPS.PER_ADDRESSES to EBS_OIM_HR
Grant succeeded.
grant select on APPS.PER_PERSON_TYPE_USAGES_F to EBS_OIM_HR
old 1: grant select, update on APPS.PER_PERSON_TYPE_USAGES_F to &USERNAME
new 1: grant select, update on APPS.PER_PERSON_TYPE_USAGES_F to EBS_OIM_HR
Grant succeeded.
grant select on APPS.PER_ALL_PEOPLE_F to EBS_OIM_HR
old 1: grant select, update on APPS.PER_ALL_PEOPLE_F to &USERNAME
new 1: grant select, update on APPS.PER_ALL_PEOPLE_F to EBS_OIM_HR
Grant succeeded.
grant execute on APPS.OIM_EMPLOYEE_WRAPPER to EBS_OIM_HR
old 1: grant execute on APPS.OIM_EMPLOYEE_WRAPPER to &USERNAME
new 1: grant execute on APPS.OIM_EMPLOYEE_WRAPPER to EBS_OIM_HR
Grant succeeded.
grant execute on APPS.OIM_EMPLOYEE_ADDRESS_WRAPPER to EBS_OIM_HR
old 1: grant execute on APPS.OIM_EMPLOYEE_ADDRESS_WRAPPER to &USERNAME
new 1: grant execute on APPS.OIM_EMPLOYEE_ADDRESS_WRAPPER to EBS_OIM_HR
Grant succeeded.
grant select, update on APPS.HZ_PARTIES to EBS_OIM_HR
old 1: grant select, update on APPS.HZ_PARTIES to &USERNAME
new 1: grant select, update on APPS.HZ_PARTIES to EBS_OIM_HR
Grant succeeded.
grant select, update on APPS.PER_JOBS to EBS_OIM_HR
old 1: grant select, update on APPS.PER_JOBS to &USERNAME
new 1: grant select, update on APPS.PER_JOBS to EBS_OIM_HR
Grant succeeded.
grant select, update on APPS.PER_GRADES to EBS_OIM_HR
old 1: grant select, update on APPS.PER_GRADES to &USERNAME
new 1: grant select, update on APPS.PER_GRADES to EBS_OIM_HR
Grant succeeded.
grant select, update on APPS.HR_ALL_ORGANIZATION_UNITS to EBS_OIM_HR
old 1: grant select, update on APPS.HR_ALL_ORGANIZATION_UNITS to &USERNAME
new 1: grant select, update on APPS.HR_ALL_ORGANIZATION_UNITS to EBS_OIM_HR
Grant succeeded.
grant select, update on APPS.PER_VALID_GRADES to EBS_OIM_HR
old 1: grant select, update on APPS.PER_VALID_GRADES to &USERNAME
new 1: grant select, update on APPS.PER_VALID_GRADES to EBS_OIM_HR
Grant succeeded.
grant select, update on APPS.FND_LOOKUP_VALUES_VL to EBS_OIM_HR
old 1: grant select, update on APPS.FND_LOOKUP_VALUES_VL to &USERNAME
new 1: grant select, update on APPS.FND_LOOKUP_VALUES_VL to EBS_OIM_HR
Grant succeeded.
grant execute on APPS.OIM_FND_GLOBAL to EBS_OIM_HR
old 1: grant execute on APPS.OIM_FND_GLOBAL to &USERNAME
new 1: grant execute on APPS.OIM_FND_GLOBAL to EBS_OIM_HR
Grant succeeded.
Enter the hostname for network acl [Input will be ignored If DB version is earlier than 11g] ::spod-elphx01
old 1: grant execute on APPS.OIM_FND_GLOBAL to &USERNAME
new 1: grant execute on APPS.OIM_FND_GLOBAL to EBS_OIM_HR
Grant succeeded.
old 5: DBMS_NETWORK_ACL_ADMIN.add_privilege('OracleEBS.xml', UPPER('&USERNAME'), TRUE, 'connect');
new 5: DBMS_NETWORK_ACL_ADMIN.add_privilege('OracleEBS.xml', UPPER('EBS_OIM_HR'), TRUE, 'connect');
old 6: DBMS_NETWORK_ACL_ADMIN.assign_acl ( acl => 'OracleEBS.xml', host => '&hostname');
new 6: DBMS_NETWORK_ACL_ADMIN.assign_acl ( acl => 'OracleEBS.xml', host => 'sapod-delphix01');
PL/SQL procedure successfully completed.
Commit complete.
Commit complete.
Disconnecting system
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Connecting EBS_OIM_HR
Enter the name of the database ::EBSPH01
Connected.
create or replace synonym PER_PEOPLE_F for APPS.PER_PEOPLE_F
Synonym created.
create or replace synonym PER_ALL_ASSIGNMENTS_F for APPS.PER_ALL_ASSIGNMENTS_F
Synonym created.
create or replace synonym PER_PERIODS_OF_SERVICE for APPS.PER_PERIODS_OF_SERVICE
Synonym created.
create or replace synonym PER_PERIODS_OF_PLACEMENT for APPS.PER_PERIODS_OF_PLACEMENT
Synonym created.
create or replace synonym HR_EMPLOYEE_API for APPS.HR_EMPLOYEE_API
Synonym created.
create or replace synonym HR_PERSON_API for APPS.HR_PERSON_API
Synonym created.
create or replace synonym HR_CHANGE_START_DATE_API for APPS.HR_CHANGE_START_DATE_API
Synonym created.
create or replace synonym PER_ADDRESSES for APPS.PER_ADDRESSES
Synonym created.
create or replace synonym PER_PERSON_TYPE_USAGES_F for APPS.PER_PERSON_TYPE_USAGES_F
Synonym created.
create or replace synonym PER_ALL_PEOPLE_F for APPS.PER_ALL_PEOPLE_F
Synonym created.
create or replace synonym PER_JOBS for APPS.PER_JOBS
Synonym created.
create or replace synonym PER_GRADES for APPS.PER_GRADES
Synonym created.
create or replace synonym HR_ALL_ORGANIZATION_UNITS for APPS.HR_ALL_ORGANIZATION_UNITS
Synonym created.
create or replace synonym HR_PERSON_ADDRESS_API for APPS.HR_PERSON_ADDRESS_API
Synonym created.
create or replace synonym HR_CONTINGENT_WORKER_API for APPS.HR_CONTINGENT_WORKER_API
Synonym created.
create or replace synonym HR_ASSIGNMENT_API for APPS.HR_ASSIGNMENT_API
Synonym created.
create or replace synonym HR_PERSON_ADDRESS_BK1 for APPS.HR_PERSON_ADDRESS_BK1
Synonym created.
create or replace synonym hr_api for APPS.hr_api
Synonym created.
create or replace synonym HZ_PARTIES for APPS.HZ_PARTIES
Synonym created.
create or replace synonym PER_PERSON_TYPES for APPS.PER_PERSON_TYPES
Synonym created.
create or replace synonym PER_VALID_GRADES for APPS.PER_VALID_GRADES
Synonym created.
create or replace synonym FND_LOOKUP_VALUES_VL for APPS.FND_LOOKUP_VALUES_VL
Synonym created.
Connecting EBS_OIM_HR
Enter the name of the database ::EBSPH01
Connected.
create or replace synonym OIM_EMPLOYEE_WRAPPER for APPS.OIM_EMPLOYEE_WRAPPER
Synonym created.
create or replace synonym OIM_EMPLOYEE_ADDRESS_WRAPPER for APPS.OIM_EMPLOYEE_ADDRESS_WRAPPER
Synonym created.
create or replace synonym OIM_FND_GLOBAL for APPS.OIM_FND_GLOBAL
Synonym created.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Package created.
Package body created.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Thanks and Regards,
Team Identity Tiffin
Comments
Post a Comment