When New Location Added to HRMS, ESTAB_LOC_US Table is not Sync'd With LOCATION_SYNC When Integrating to Campus Solutions 9.0

(Doc ID 1601838.1)

Last updated on APRIL 25, 2016

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 and later
Information in this document applies to any platform.


To reiterate, how is it possible to use integration broker to keep the ESTAB_LOC_US table sync'd between HR (owner) and CS (subscriber)?

A new location is added to the HRMS database. A LOCATION_SYNC message is generated and received by Campus Solutions 9.0 production database, but errors out because the ESTABID value is missing. The source HRMS database LOCATION_TBL.ESTABID value is also blank.  



Establishment ID is required in Location definition. (1000,939)

Error saving Component Interface. {Establishment ID is required in Location definition. (1000,939)}

Component Interface Save method failed for transaction number 1 (18022,57)

Attempt to call abstract method/property OnError of object class PS_PT:Integration:INotificationHandler. (180,845)


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms