Description: Demonstrates how to install and configure PeopleSoft Employee Reconciliation connector. This connector only uses trusted reconciliation (OIM users are created based on data from an authoritative source such as PeopleSoft).
References: https://docs.oracle.com/cd/E22999_01/index.htm
https://docs.oracle.com/cd/E22999_01/doc.111/e25370/toc.htm
Connector Installation
1. Unzip the connector bundle to "$MW_HOME/Oracle_IDM1/server/ConnectorDefaultDirectory" directory (E.g. unzip PSFT_ER-11.1.1.5.0.zip -d $MW_HOME/Oracle_IDM1/server/ConnectorDefaultDirectory/).
2. Run the Connector Installer in Oracle Identity Manager System Administration.
 |
| Oracle Identity System Administration |
 |
| Provisioning Configuration > Manage Connector |
 |
| Click Install |
 |
| Specify connector, click load, and then continue |
 |
| Connector Installation Progress |
 |
| Install Complete |
3. Adjust the PSFT HRMS IT Resource if needed.
 |
| Default IT Resource Configuration |
Deploying the PeopleSoft Listener
Incremental reconciliation for this connector is real-time. When data is added or updated on PeopleSoft target system, a PeopleCode event is generated. Then the event generates a message such as PERSON_BASIC_SYNC (for creation of new OIM user) and WORKFORCE_SYNC (for updates on OIM user) to send to the listener. The PeopleSoft listener is responsible for parsing the incoming messages and creating reconciliation events.
1. Set the following environment variables. Adjust variables accordingly.
export ORACLE_COMMON=$MW_HOME/Oracle_IDM1/common
export WLS_HOME=$MW_HOME/wlserver_10.3
export JAVA_HOME=/home/oracle/jdk1.6.0_38
export ORACLE_HOME=$MW_HOME/Oracle_IDM1
export ANT_HOME=$MW_HOME/modules/org.apache.ant_1.7.1
export PATH=$ANT_HOME/bin:$PATH
2. Adjust the deploy.properties file, which is located in "$MW_HOME/Oracle_IDM1/server/ConnectorDefaultDirectory/PSFT_ER-11.1.1.5.0/listener" directory.
3. Navigate to ""$MW_HOME/Oracle_IDM1/server/ConnectorDefaultDirectory/PSFT_ER-11.1.1.5.0/listener" directory and run the following command:
ant setup-listener
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 | Buildfile: build.xmlTrying to override old definition of datatype wldeploycheck-wl-home:check-oracle-common:check-oracle-home:check-env-vars:setup-archive: [mkdir] Created dir: /home/oracle/Oracle/Middleware/Oracle_IDM1/server/ConnectorDefaultDirectory/PSFT_ER-11.1.1.5.0/listener/deployable-archive [copy] Copying 4 files to /home/oracle/Oracle/Middleware/Oracle_IDM1/server/ConnectorDefaultDirectory/PSFT_ER-11.1.1.5.0/listener/deployable-archive [copy] Copied 5 empty directories to 1 empty directory under /home/oracle/Oracle/Middleware/Oracle_IDM1/server/ConnectorDefaultDirectory/PSFT_ER-11.1.1.5.0/listener/deployable-archive [copy] Copying 1 file to /home/oracle/Oracle/Middleware/Oracle_IDM1/server/ConnectorDefaultDirectory/PSFT_ER-11.1.1.5.0/listener/deployable-archive/PeopleSoftOIMListener.ear/PeopleSoftOIMListener.war/WEB-INF/lib [copy] Copying 1 file to /home/oracle/Oracle/Middleware/Oracle_IDM1/server/ConnectorDefaultDirectory/PSFT_ER-11.1.1.5.0/listener/deployable-archive/PeopleSoftOIMListener.ear/PeopleSoftOIMListener.war/WEB-INF/lib [copy] Copying 1 file to /home/oracle/Oracle/Middleware/Oracle_IDM1/server/ConnectorDefaultDirectory/PSFT_ER-11.1.1.5.0/listener/deployable-archive/PeopleSoftOIMListener.ear/PeopleSoftOIMListener.war/WEB-INF/lib [echo] Updating deployment descriptor (web.xml)deploy: [echo] Deploying the listener[passwdreader] Enter weblogic admin password: [wldeploy] weblogic.Deployer -debug -verbose -noexit -name PeopleSoftOIMListener -source /home/oracle/Oracle/Middleware/Oracle_IDM1/server/ConnectorDefaultDirectory/PSFT_ER-11.1.1.5.0/listener/deployable-archive/PeopleSoftOIMListener.ear -targets oim_server1 -adminurl t3://localhost:7001 -user weblogic -password ******** -deploy [wldeploy] weblogic.Deployer invoked with options: -debug -verbose -noexit -name PeopleSoftOIMListener -source /home/oracle/Oracle/Middleware/Oracle_IDM1/server/ConnectorDefaultDirectory/PSFT_ER-11.1.1.5.0/listener/deployable-archive/PeopleSoftOIMListener.ear -targets oim_server1 -adminurl t3://localhost:7001 -user weblogic -deploy [wldeploy] [WebLogicDeploymentManagerImpl.<init>():115] : Constructing DeploymentManager for J2EE version V1_4 deployments [wldeploy] [WebLogicDeploymentManagerImpl.getNewConnection():158] : Connecting to admin server at localhost:7001, as user weblogic [wldeploy] [ServerConnectionImpl.getEnvironment():286] : setting environment [wldeploy] [ServerConnectionImpl.getEnvironment():289] : getting context using t3://localhost:7001 [wldeploy] [ServerConnectionImpl.getMBeanServer():237] : Connecting to MBeanServer at service:jmx:t3://localhost:7001/jndi/weblogic.management.mbeanservers.domainruntime [wldeploy] [ServerConnectionImpl.getMBeanServer():237] : Connecting to MBeanServer at service:jmx:t3://localhost:7001/jndi/weblogic.management.mbeanservers.runtime [wldeploy] [DomainManager.resetDomain():36] : Getting new domain [wldeploy] [DomainManager.resetDomain():39] : Using pending domain: true [wldeploy] [MBeanCache.addNotificationListener():96] : Adding notification listener for weblogic.deploy.api.spi.deploy.mbeans.TargetCache@174323d5 [wldeploy] [MBeanCache.addNotificationListener():103] : Added notification listener for weblogic.deploy.api.spi.deploy.mbeans.TargetCache@174323d5 [wldeploy] [MBeanCache.addNotificationListener():96] : Adding notification listener for weblogic.deploy.api.spi.deploy.mbeans.ModuleCache@55c79dfc [wldeploy] [MBeanCache.addNotificationListener():103] : Added notification listener for weblogic.deploy.api.spi.deploy.mbeans.ModuleCache@55c79dfc [wldeploy] [ServerConnectionImpl.initialize():169] : Connected to WLS domain: oim_domain [wldeploy] [ServerConnectionImpl.init():159] : Initializing ServerConnection : weblogic.deploy.api.spi.deploy.internal.ServerConnectionImpl@d2f41a5 [wldeploy] [BasicOperation.dumpTmids():713] : Incoming tmids: [wldeploy] [BasicOperation.dumpTmids():715] : {Target=oim_server1, WebLogicTargetType=server, Name=PeopleSoftOIMListener}, targeted=true [wldeploy] [BasicOperation.deriveAppName():141] : appname established as: PeopleSoftOIMListener [wldeploy] <Aug 26, 2015 8:04:32 AM EDT> <Info> <J2EE Deployment SPI> <BEA-260121> <Initiating deploy operation for application, PeopleSoftOIMListener [archive: /home/oracle/Oracle/Middleware/Oracle_IDM1/server/ConnectorDefaultDirectory/PSFT_ER-11.1.1.5.0/listener/deployable-archive/PeopleSoftOIMListener.ear], to oim_server1 .> [wldeploy] [BasicOperation.dumpTmids():713] : Incoming tmids: [wldeploy] [BasicOperation.dumpTmids():715] : {Target=oim_server1, WebLogicTargetType=server, Name=PeopleSoftOIMListener}, targeted=true [wldeploy] [BasicOperation.loadGeneralOptions():628] : Delete Files:false [wldeploy] Timeout :3600000 [wldeploy] Targets: [wldeploy] oim_server1 [wldeploy] ModuleTargets={} [wldeploy] SubModuleTargets={} [wldeploy] } [wldeploy] Files: [wldeploy] null [wldeploy] Deployment Plan: null [wldeploy] App root: /tmp/oracle/./config/deployments/PeopleSoftOIMListener [wldeploy] App config: /tmp/oracle/./config/deployments/PeopleSoftOIMListener/plan [wldeploy] Deployment Options: {isRetireGracefully=true,isGracefulProductionToAdmin=false,isGracefulIgnoreSessions=false,rmiGracePeriod=-1,retireTimeoutSecs=-1,undeployAllVersions=false,archiveVersion=null,planVersion=null,isLibrary=false,libSpecVersion=null,libImplVersion=null,stageMode=null,clusterTimeout=3600000,altDD=null,altWlsDD=null,name=PeopleSoftOIMListener,securityModel=null,securityValidationEnabled=false,versionIdentifier=null,isTestMode=false,forceUndeployTimeout=0,defaultSubmoduleTargets=true,timeout=0,deploymentPrincipalName=null,useExpiredLock=false} [wldeploy] [wldeploy] [BasicOperation.execute():445] : Initiating deploy operation for app, PeopleSoftOIMListener, on targets: [wldeploy] [BasicOperation.execute():447] : oim_server1 [wldeploy] Task 0 initiated: [Deployer:149026]deploy application PeopleSoftOIMListener on oim_server1. [wldeploy] Task 0 completed: [Deployer:149026]deploy application PeopleSoftOIMListener on oim_server1. [wldeploy] Target state: deploy completed on Server oim_server1 [wldeploy] [wldeploy] Target Assignments: [wldeploy] + PeopleSoftOIMListener oim_server1 [wldeploy] [ServerConnectionImpl.close():332] : Closing DM connection [wldeploy] [ServerConnectionImpl.close():352] : Unregistered all listeners [wldeploy] [ServerConnectionImpl.closeJMX():372] : Closed JMX connection [wldeploy] [ServerConnectionImpl.closeJMX():384] : Closed Runtime JMX connection [wldeploy] [ServerConnectionImpl.closeJMX():396] : Closed Edit JMX connectiongrant-keystore-permissions: [echo] Granting keystore access permissions to the listener. [java] Aug 26, 2015 8:04:50 AM oracle.iam.connectors.psft.common.deploy.PermissionsHandler main [java] INFO: Connecting to admin server t3://localhost:7001 with user weblogic [java] Aug 26, 2015 8:04:50 AM oracle.iam.connectors.psft.common.deploy.PermissionsHandler main [java] INFO: Starting the keystore grant for /home/oracle/Oracle/Middleware/Oracle_IDM1/server/ConnectorDefaultDirectory/PSFT_ER-11.1.1.5.0/listener/deployable-archive/PeopleSoftOIMListener.ear/PeopleSoftOIMListener.war/WEB-INF/lib/- [java] Aug 26, 2015 8:04:50 AM oracle.iam.connectors.psft.common.deploy.PermissionsHandler initDomainRuntimeServerConnection [java] INFO: Connecting to admin server.. [java] Aug 26, 2015 8:04:51 AM oracle.iam.connectors.psft.common.deploy.PermissionsHandler initDomainRuntimeServerConnection [java] INFO: Connection initialized [java] Aug 26, 2015 8:04:51 AM oracle.iam.connectors.psft.common.deploy.PermissionsHandler main [java] INFO: Granting keystore permissions to PSFT archive libraries.. [java] Aug 26, 2015 8:04:51 AM oracle.iam.connectors.psft.common.deploy.PermissionsHandler grantRWPermissionsToJar [java] INFO: URL /home/oracle/Oracle/Middleware/Oracle_IDM1/server/ConnectorDefaultDirectory/PSFT_ER-11.1.1.5.0/listener/deployable-archive/PeopleSoftOIMListener.ear/PeopleSoftOIMListener.war/WEB-INF/lib/- doesn't jave access to RW keystores. Initiating the grant operation [java] Aug 26, 2015 8:04:51 AM oracle.iam.connectors.psft.common.deploy.PermissionsHandler grantRWPermissionsToJar [java] INFO: Permission for OIM Authenticator set in system-jazn-data.xml successfully [java] Aug 26, 2015 8:04:51 AM oracle.iam.connectors.psft.common.deploy.PermissionsHandler main [java] INFO: Granting keystore permissions to cached archive.. [java] Aug 26, 2015 8:04:52 AM oracle.iam.connectors.psft.common.deploy.PermissionsHandler grantRWPermissionsToJar [java] INFO: URL ${domain.home}/servers/${weblogic.Name}/stage/PeopleSoftOIMListener/PeopleSoftOIMListener.ear/PeopleSoftOIMListener.war/WEB-INF/lib/- doesn't jave access to RW keystores. Initiating the grant operation [java] Aug 26, 2015 8:04:52 AM oracle.iam.connectors.psft.common.deploy.PermissionsHandler grantRWPermissionsToJar [java] INFO: Permission for OIM Authenticator set in system-jazn-data.xml successfully [java] Aug 26, 2015 8:04:52 AM oracle.iam.connectors.psft.common.deploy.PermissionsHandler main [java] INFO: Grant finished [java] Aug 26, 2015 8:04:52 AM oracle.iam.connectors.psft.common.deploy.PermissionsHandler closeConnection [java] INFO: Connection to admin server closedsetup-listener:BUILD SUCCESSFULTotal time: 30 seconds |
4. Verify application is deployed on WebLogic. Also, check if proper codebase permissions are granted in WebLogic EM console.
 |
| Note: Custom jars for validation and transformation needs to be place in the lib directory. |
Testing Reconciliation
A test script is given in the PeopleSoft Employee Reconciliation connector in order to validate the PeopleSoft listener. A PeopleSoft message XML file (E.g. PERSON_BASIC_SYNC = creation of new OIM user, WORKFORCE_SYNC = updates on OIM user) is required to send information to the PeopleSoft listener which parses the data and then OIM creates a reconciliation event based on the data received. Given below are sample PeopleSoft messages.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0"?> | |
| <PERSON_BASIC_SYNC> | |
| <FieldTypes> | |
| <PERSON class="R"> | |
| <EMPLID type="CHAR"/> | |
| </PERSON> | |
| <ADDRESSES class="R"/> | |
| <NAMES class="R"> | |
| <EMPLID type="CHAR"/> | |
| <NAME_TYPE type="CHAR"/> | |
| <EFFDT type="DATE"/> | |
| <EFF_STATUS type="CHAR"/> | |
| <COUNTRY_NM_FORMAT type="CHAR"/> | |
| <NAME type="CHAR"/> | |
| <NAME_INITIALS type="CHAR"/> | |
| <NAME_PREFIX type="CHAR"/> | |
| <NAME_SUFFIX type="CHAR"/> | |
| <NAME_ROYAL_PREFIX type="CHAR"/> | |
| <NAME_ROYAL_SUFFIX type="CHAR"/> | |
| <NAME_TITLE type="CHAR"/> | |
| <LAST_NAME_SRCH type="CHAR"/> | |
| <FIRST_NAME_SRCH type="CHAR"/> | |
| <LAST_NAME type="CHAR"/> | |
| <FIRST_NAME type="CHAR"/> | |
| <MIDDLE_NAME type="CHAR"/> | |
| <SECOND_LAST_NAME type="CHAR"/> | |
| <SECOND_LAST_SRCH type="CHAR"/> | |
| <NAME_AC type="CHAR"/> | |
| <PREF_FIRST_NAME type="CHAR"/> | |
| <PARTNER_LAST_NAME type="CHAR"/> | |
| <PARTNER_ROY_PREFIX type="CHAR"/> | |
| <LAST_NAME_PREF_NLD type="CHAR"/> | |
| <NAME_DISPLAY type="CHAR"/> | |
| <NAME_FORMAL type="CHAR"/> | |
| <NAME_DISPLAY_SRCH type="CHAR"/> | |
| <LASTUPDDTTM type="DATETIME"/> | |
| <LASTUPDOPRID type="CHAR"/> | |
| </NAMES> | |
| <PERS_ORG_REL_WK class="R"> | |
| <EMPLID type="CHAR"/> | |
| <PER_ORG type="CHAR"/> | |
| <POI_TYPE type="CHAR"/> | |
| </PERS_ORG_REL_WK> | |
| <PERS_DATA_EFFDT class="R"/> | |
| <PERS_NID class="R"/> | |
| <NAME_TYPE_VW class="R"/> | |
| <ADDRESS_TYPE_VW class="R"/> | |
| <EMAIL_ADDRESSES class="R"/> | |
| <PERSON_IMCHAT class="R"/> | |
| <PERSONAL_PHONE class="R"/> | |
| <PERS_SMOKER class="R"/> | |
| <PERSON_BRA class="R"/> | |
| <PERS_DATA_BRA class="R"/> | |
| <PERS_DATA_CAN class="R"/> | |
| <PERS_DATA_CHE class="R"/> | |
| <PLACE_ORIG_CHE class="R"/> | |
| <PERS_HUKOU_CHN class="R"/> | |
| <PERS_WRKLIF_CHN class="R"/> | |
| <PERS_WRKLV_CHN class="R"/> | |
| <PERS_DATA_DEU class="R"/> | |
| <NATIONALITY_GER class="R"/> | |
| <PERS_DATA_ESP class="R"/> | |
| <PERSON_FRA class="R"/> | |
| <PERS_DATA_FRA class="R"/> | |
| <PERS_DATA_IND class="R"/> | |
| <PERS_DATA_ITA class="R"/> | |
| <PERS_DATA_JPN class="R"/> | |
| <PERS_DATA_MEX class="R"/> | |
| <PERS_DATA_USA class="R"/> | |
| <PERS_DATA_FPS class="R"/> | |
| <PERSON_SA class="R"/> | |
| <PERS_DATA_USF class="R"/> | |
| <PSCAMA class="R"> | |
| <LANGUAGE_CD type="CHAR"/> | |
| <AUDIT_ACTN type="CHAR"/> | |
| <BASE_LANGUAGE_CD type="CHAR"/> | |
| <MSG_SEQ_FLG type="CHAR"/> | |
| <PROCESS_INSTANCE type="NUMBER"/> | |
| <PUBLISH_RULE_ID type="CHAR"/> | |
| <MSGNODENAME type="CHAR"/> | |
| </PSCAMA> | |
| </FieldTypes> | |
| <MsgData> | |
| <Transaction> | |
| <PERSON class="R"> | |
| <EMPLID IsChanged="Y">LSTILLMAN</EMPLID> | |
| <PERS_ORG_REL_WK class="R"> | |
| <EMPLID IsChanged="Y">LSTILLMAN</EMPLID> | |
| <PER_ORG IsChanged="Y">EMP</PER_ORG> | |
| </PERS_ORG_REL_WK> | |
| <PERS_DATA_EFFDT class="R"/> | |
| <PSCAMA class="R"> | |
| <AUDIT_ACTN IsChanged="Y">A</AUDIT_ACTN> | |
| </PSCAMA> | |
| <PERS_NID class="R"/> | |
| <PSCAMA class="R"> | |
| <AUDIT_ACTN IsChanged="Y">A</AUDIT_ACTN> | |
| </PSCAMA> | |
| <NAME_TYPE_VW class="R"> | |
| <NAMES class="R"> | |
| <EMPLID IsChanged="Y">LSTILLMAN</EMPLID> | |
| <NAME_TYPE IsChanged="Y">PRI</NAME_TYPE> | |
| <EFFDT IsChanged="Y">2015-08-01</EFFDT> | |
| <EFF_STATUS IsChanged="Y">A</EFF_STATUS> | |
| <COUNTRY_NM_FORMAT IsChanged="Y">001</COUNTRY_NM_FORMAT> | |
| <NAME IsChanged="Y">Stillman,Lucy</NAME> | |
| <LAST_NAME_SRCH IsChanged="Y">STILLMAN</LAST_NAME_SRCH> | |
| <FIRST_NAME_SRCH IsChanged="Y">LUCY</FIRST_NAME_SRCH> | |
| <LAST_NAME IsChanged="Y">Stillman</LAST_NAME> | |
| <FIRST_NAME IsChanged="Y">Lucy</FIRST_NAME> | |
| <LAST_NAME_PREF_NLD IsChanged="Y">1</LAST_NAME_PREF_NLD> | |
| <NAME_DISPLAY IsChanged="Y">Stillman, Lucy</NAME_DISPLAY> | |
| <NAME_FORMAL IsChanged="Y">Lucy Stillman</NAME_FORMAL> | |
| <NAME_DISPLAY_SRCH IsChanged="Y">STILLMANLUCY</NAME_DISPLAY_SRCH> | |
| <LASTUPDDTTM IsChanged="Y">2015-08-09T12:55:01.000000-0700</LASTUPDDTTM> | |
| <LASTUPDOPRID IsChanged="Y">WVIDIC</LASTUPDOPRID> | |
| </NAMES> | |
| <PSCAMA class="R"> | |
| <AUDIT_ACTN IsChanged="Y">A</AUDIT_ACTN> | |
| </PSCAMA> | |
| </NAME_TYPE_VW> | |
| <PSCAMA class="R"> | |
| <AUDIT_ACTN IsChanged="Y">A</AUDIT_ACTN> | |
| </PSCAMA> | |
| <ADDRESS_TYPE_VW class="R"> | |
| <ADDRESSES class="R"/> | |
| <PSCAMA class="R"> | |
| <AUDIT_ACTN IsChanged="Y">A</AUDIT_ACTN> | |
| </PSCAMA> | |
| </ADDRESS_TYPE_VW> | |
| <PSCAMA class="R"> | |
| <AUDIT_ACTN IsChanged="Y">A</AUDIT_ACTN> | |
| </PSCAMA> | |
| <EMAIL_ADDRESSES class="R"/> | |
| <PSCAMA class="R"> | |
| <AUDIT_ACTN IsChanged="Y">A</AUDIT_ACTN> | |
| </PSCAMA> | |
| <PERSONAL_PHONE class="R"/> | |
| <PSCAMA class="R"> | |
| <AUDIT_ACTN IsChanged="Y">A</AUDIT_ACTN> | |
| </PSCAMA> | |
| </PERSON> | |
| <PSCAMA class="R"> | |
| <LANGUAGE_CD>ENG</LANGUAGE_CD> | |
| <AUDIT_ACTN IsChanged="Y">A</AUDIT_ACTN> | |
| <BASE_LANGUAGE_CD>ENG</BASE_LANGUAGE_CD> | |
| <PROCESS_INSTANCE>0</PROCESS_INSTANCE> | |
| </PSCAMA> | |
| </Transaction> | |
| </MsgData> | |
| </PERSON_BASIC_SYNC> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0"?> | |
| <WORKFORCE_SYNC> | |
| <FieldTypes> | |
| <PER_ORG_ASGN class="R"> | |
| <EMPLID type="CHAR"/> | |
| <EMPL_RCD type="NUMBER"/> | |
| <PER_ORG type="CHAR"/> | |
| <ORG_INSTANCE_ERN type="NUMBER"/> | |
| <POI_TYPE type="CHAR"/> | |
| <BENEFIT_RCD_NBR type="NUMBER"/> | |
| <ROOM_NBR type="CHAR"/> | |
| </PER_ORG_ASGN> | |
| <JOB_JR class="R"/> | |
| <COMPENSATION class="R"/> | |
| <JOB_EARNS_DIST class="R"/> | |
| <JOB_AUS class="R"/> | |
| <JOB_IND class="R"/> | |
| <JOB_MIL class="R"/> | |
| <JOB_USF class="R"/> | |
| <HR_EE_SNR_DATES class="R"/> | |
| <JOB_GPS class="R"/> | |
| <PER_ORG_INST class="R"> | |
| <EMPLID type="CHAR"/> | |
| <ORG_INSTANCE_ERN type="NUMBER"/> | |
| <PER_ORG type="CHAR"/> | |
| <POI_TYPE type="CHAR"/> | |
| <ORIG_HIRE_DT type="DATE"/> | |
| <NEE_PROVIDER_ID type="CHAR"/> | |
| <LASTUPDDTTM type="DATETIME"/> | |
| <LASTUPDOPRID type="CHAR"/> | |
| </PER_ORG_INST> | |
| <JOB class="R"> | |
| <EMPLID type="CHAR"/> | |
| <EMPL_RCD type="NUMBER"/> | |
| <EFFDT type="DATE"/> | |
| <EFFSEQ type="NUMBER"/> | |
| <PER_ORG type="CHAR"/> | |
| <DEPTID type="CHAR"/> | |
| <JOBCODE type="CHAR"/> | |
| <SUPERVISOR_ID type="CHAR"/> | |
| <REG_TEMP type="CHAR"/> | |
| <ACTION type="CHAR"/> | |
| <FULL_PART_TIME type="CHAR"/> | |
| </JOB> | |
| <BEN_PROG_PARTIC class="R"/> | |
| <PER_ORG_ASG_BEL class="R"/> | |
| <PERS_REGIST_BEL class="R"/> | |
| <PER_ORG_ASG_MIL class="R"/> | |
| <PER_ORG_ASG_BRA class="R"/> | |
| <PER_ORG_ASG_HP class="R"/> | |
| <HP_EMPLT_TEACH class="R"/> | |
| <PER_ORG_ASG_JPN class="R"/> | |
| <PER_ORG_ASG_FA class="R"/> | |
| <PER_ORG_ASG_NLD class="R"/> | |
| <PER_ORG_ASG_INT class="R"/> | |
| <PSCAMA class="R"> | |
| <LANGUAGE_CD type="CHAR"/> | |
| <AUDIT_ACTN type="CHAR"/> | |
| <BASE_LANGUAGE_CD type="CHAR"/> | |
| <MSG_SEQ_FLG type="CHAR"/> | |
| <PROCESS_INSTANCE type="NUMBER"/> | |
| <PUBLISH_RULE_ID type="CHAR"/> | |
| <MSGNODENAME type="CHAR"/> | |
| </PSCAMA> | |
| </FieldTypes> | |
| <MsgData> | |
| <Transaction> | |
| <PER_ORG_ASGN class="R"> | |
| <EMPLID IsChanged="Y">LSTILLMAN</EMPLID> | |
| <EMPL_RCD IsChanged="Y">0</EMPL_RCD> | |
| <PER_ORG IsChanged="Y">EMP</PER_ORG> | |
| <ORG_INSTANCE_ERN IsChanged="Y">0</ORG_INSTANCE_ERN> | |
| <BENEFIT_RCD_NBR IsChanged="Y">0</BENEFIT_RCD_NBR> | |
| <PER_ORG_INST class="R"> | |
| <EMPLID IsChanged="Y">LSTILLMAN</EMPLID> | |
| <ORG_INSTANCE_ERN IsChanged="Y">0</ORG_INSTANCE_ERN> | |
| <PER_ORG IsChanged="Y">EMP</PER_ORG> | |
| <ORIG_HIRE_DT IsChanged="Y">2015-01-15</ORIG_HIRE_DT> | |
| <LASTUPDDTTM IsChanged="Y">2015-07-11T10:26:11.000000-0700</LASTUPDDTTM> | |
| <LASTUPDOPRID IsChanged="Y">WVIDIC</LASTUPDOPRID> | |
| </PER_ORG_INST> | |
| <PSCAMA class="R"> | |
| <AUDIT_ACTN>C</AUDIT_ACTN> | |
| </PSCAMA> | |
| <JOB class="R"> | |
| <EMPLID IsChanged="Y">LSTILLMAN</EMPLID> | |
| <EMPL_RCD IsChanged="Y">0</EMPL_RCD> | |
| <EFFDT IsChanged="Y">2015-08-29</EFFDT> | |
| <EFFSEQ IsChanged="Y">0</EFFSEQ> | |
| <PER_ORG IsChanged="Y">EMP</PER_ORG> | |
| <DEPTID IsChanged="Y">GEN</DEPTID> | |
| <JOBCODE IsChanged="Y">002</JOBCODE> | |
| <SUPERVISOR_ID IsChanged="Y">WVIDIC</SUPERVISOR_ID> | |
| <REG_TEMP IsChanged="Y">R</REG_TEMP> | |
| <FULL_PART_TIME IsChanged="Y">F</FULL_PART_TIME> | |
| <ACTION IsChanged="Y">A</ACTION> | |
| <JOB_JR class="R"/> | |
| <PSCAMA class="R"> | |
| <AUDIT_ACTN>A</AUDIT_ACTN> | |
| </PSCAMA> | |
| </JOB> | |
| <PSCAMA class="R"> | |
| <AUDIT_ACTN>A</AUDIT_ACTN> | |
| </PSCAMA> | |
| </PER_ORG_ASGN> | |
| <PSCAMA class="R"> | |
| <LANGUAGE_CD>ENG</LANGUAGE_CD> | |
| <AUDIT_ACTN>C</AUDIT_ACTN> | |
| <BASE_LANGUAGE_CD>ENG</BASE_LANGUAGE_CD> | |
| <PROCESS_INSTANCE>0</PROCESS_INSTANCE> | |
| </PSCAMA> | |
| </Transaction> | |
| </MsgData> | |
| </WORKFORCE_SYNC> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | #provide the OIM Listener name in format http://<COMPUTER_NAME>:<PORT_NO>/PeopleSoftOIMListenerListenerURL=http://10.0.2.15:14000/PeopleSoftOIMListener#specify absolute xml file path with the file name#The Path should not contain spacesXMLFilePath=/home/oracle/Oracle/Middleware/Oracle_IDM1/server/ConnectorDefaultDirectory/PSFT_ER-11.1.1.5.0/test/config/PERSON_BASIC_SYNC_SAMPLE.xml#XMLFilePath=/home/oracle/Oracle/Middleware/Oracle_IDM1/server/ConnectorDefaultDirectory/PSFT_ER-11.1.1.5.0/test/config/WORKFORCE_SYNC_SAMPLE.xml# specify message type# - 'ping' for ping request - 'none' for normal messageMessageType=none# Specify the PeopleSoft IT Resource Name which will handle this requestITResourceName=PSFT HRMS#provide the name of the message to reconcile. For example: PERSON_BASIC_SYNC.VERSION_3MessageName=PERSON_BASIC_SYNC#MessageName=WORKFORCE_SYNC |
 |
| PeopleSoft Listener URL WebLogic Console > Deployments > PeopleSoftOIMListener > Testing |
2. If you are using Oracle Identity Manager release 11.1.2.x or later, then include the jrf.jar, jrf-api.jar, and jrf-client.jar files to the classpath. These JAR files are located in the $ORACLE_COMMON/modules/oracle.jrf_11.1.1 directory.
export ORACLE_COMMON=/home/oracle/Oracle/Middleware/oracle_common
export PATH=$ORACLE_COMMON/modules/oracle.jrf_11.1.1:$PATH
3. Navigate to "$MW_HOME/Oracle_IDM1/server/ConnectorDefaultDirectory/PSFT_ER-11.1.1.5.0/test/config" and then execute "InvokeListener.sh" script.
4. Verify that a reconciliation event is created in Oracle Identity Manager.
 |
| Reconciliation Event for PERSON_BASIC_SYNC |
 |
| Reconciliation Event for WORKFORCE_SYNC This is a defer event. Run the "Run Future Dated Reconciliation" scheduled job when Action Date has passed. |
Hi,
ReplyDeleteThis is Vibhor here.
Thanks for above detailed step by step guide for PSFT connector.
I have one question around future dated event or Defered Event. Lets say at people soft end user job code change and effective from one month from now and people soft send us data in one month advance how Peoplesoft connector will handle same.
Is it going to put that event also as deferred event and after one month when Run Future dated Recon job runs it will update job code of user or Deferred event is only for user termination,hire like those actions.
Thanks for all help in advance.