Jun 23, 2015

PeopleSoft : Data Base Links(DBLinks)

DBLink:
  • Data Base Link provides you the control on the tables from other database.
  • It allows you to query against other databases using the syntax TABLENAME@DBLINK.
Syntax:
  • Use the following code to create a database link:

            create database link "database_link_name"
      connect to username
      identified by "password"
      using 'connection_name';
Example:

     create database link "HRDEV"
      connect to sysadm
      identified by "sysadm"
      using 'HR89DEV';

Usage:

  • We can select any record from HR89DEV database.
    • SELECT * FROM PS_JOB@HRDEV;

Jun 22, 2015

PeopleSoft : Job Code Full Sync Process (Integration Broker)

Activate Data Publish Rules In Source

    • Go to Enterprise Components > Integration Definitions >Full Data Publish Rule
    • Search for "JOBCODE_FULLSYNC” message.
    • If the rule is Inactive then make the status to Active and save the rule.
Activate Outbound Routing In Soruce      
    • Go to People Tools >> Integration Broker >> Integration Setup >> Service Operations
    • Search for “JOBCODE_FULLSYNC” Service Operation
    •  Navigate to the Routings tab.
    •  Select the outbound routing between "Source" to "Target"
    •  If the Routing is Inactive then click on ‘Activate Selected Routings’ button.

     Activate Inbound Routing In Destination
  •     Go to PeopleTools > Integration Broker > Integration Setup > Service Operations
  •       Search for “JOBCODE_FULLSYNC” Service Operation
  •       Navigate to the Routings tab.    
  •       Select the inbound routing between "Source" to "Target"   
  •       If the Routing is Inactive the click on 'Activate Selected Routings' button.  


    Run “Full Table Data Publish” Process In Source
       
  •       
    Go to Enterprise Components > Integration Definitions > Initiate Processes > Full Data Publish
  •      
    Provide run control id in search page.
  •      
    In run control page select process frequency as “Once”
  •       
    Select Message Name “JOBCODE_FULLSYNC”
  •       
    Click on “Run” button


  •       Select EOP_PUBLISHT (Full Table Data Publish) process
  •       Click “Ok” button.
 
    
    Verify IB Messages Were Posted In Source
  •      Go to PeopleTools > Integration Broker > Service Operations Monitor > Monitoring > Asynchronous Services
  •      In Monitor Overview tab select queue level as Pub Con, Group By Service Operation
  •      Select proper time period
  •      Verify messages for JOBCODE_FULLSYNC service operation
   
  •      If messages are in Error or Timeout state then click on message count.
  •      You will navigate to Publication Contracts tab on the same page.
  •      Click on Details link for timed out or error message
  •      Find out the root cause.
       Verify IB Messages Were Received In Destination
  •     Go to PeopleTools > Integration Broker > Service Operations Monitor > Monitoring > Asynchronous Services
  •       In Monitor Overview tab select queue level as Sub Con, Group By Service Operation  
  •       Select proper time period
  •       Verify messages for JOBCODE_FULLSYNC service operation

     Note: If messages were not received then bounce pubsub servers.