Find Records/Tables within a Default Message - PERSON_BASIC_SYNC - Sample SQL

Provide a listing of records for a particular message.  This example is PERSON_BASIC_SYNC.



SELECT DISTINCT C.recname,
                D.rectype "Tables Only",
                C.msgname,
                A.defaultver
FROM   psmsgdefn A,
       psmsgver B,
       psmsgrec C,
       psrecdefn D
WHERE  A.msgname = B.msgname
       AND A.defaultver = B.apmsgver
       AND C.msgname = B.msgname
       AND C.apmsgver = B.apmsgver
       AND D.recname = C.recname
       AND D.rectype = 0
       AND A.msgname = 'PERSON_BASIC_SYNC'
ORDER  BY C.recname ASC 

RECNAME	Tables Only	MSGNAME	DEFAULTVER
ADDRESSES	0	PERSON_BASIC_SYNC	INTERNAL
EMAIL_ADDRESSES	0	PERSON_BASIC_SYNC	INTERNAL
NAMES	0	PERSON_BASIC_SYNC	INTERNAL
NATIONALITY_GER	0	PERSON_BASIC_SYNC	INTERNAL
PERSON	0	PERSON_BASIC_SYNC	INTERNAL
PERSONAL_PHONE	0	PERSON_BASIC_SYNC	INTERNAL
PERSON_BRA	0	PERSON_BASIC_SYNC	INTERNAL
PERSON_FRA	0	PERSON_BASIC_SYNC	INTERNAL
PERSON_SA	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_BRA	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_CAN	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_CHE	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_DEU	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_EFFDT	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_ESP	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_FPS	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_FRA	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_IND	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_ITA	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_JPN	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_MEX	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_USA	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_USF	0	PERSON_BASIC_SYNC	INTERNAL
PERS_HUKOU_CHN	0	PERSON_BASIC_SYNC	INTERNAL
PERS_NID	0	PERSON_BASIC_SYNC	INTERNAL
PERS_SMOKER	0	PERSON_BASIC_SYNC	INTERNAL
PERS_WRKLIF_CHN	0	PERSON_BASIC_SYNC	INTERNAL
PERS_WRKLV_CHN	0	PERSON_BASIC_SYNC	INTERNAL
PLACE_ORIG_CHE	0	PERSON_BASIC_SYNC	INTERNAL

SOA error log - Navigation

Integrations - AAWS / HCM Split
Question:  Where can I set the SOA error log for reviewing integrations?



The SOA error log Navigation

Answer:  The path for the log is set in Set Up SACR > System Administration > Integration > Logging

Campus Solutions / HCM Split documentation - List of KM docs on My Oracle Support

Great listing of Knowledge Management docs to review within My Oracle Support concerning the CS/HCM Split. (Campus Solutions Split from HCM)

http://support.oracle.com


CS/HR Split

• Campus Solutions to HCM Integration:  A Case Study on Integration Using the Owner Subscriber Option (Doc ID 1297158.1)

• Campus Solutions CS - HCM Integration Support Released! (Doc ID 1267773.1)

• CS Bundle #19 Functional Documentation for Campus Solutions 9.0 & Feature Pack 4(Doc ID 1259484.1)

• Campus Solutions Announces Support and Documentation Availability for the Subscriber Only Model of the CS-HCM Separate Instance Integration (Doc ID 1320568.1)

• Campus Solutions Announces Support and Documentation Availability for the Subscriber Only Model of the CS-HCM Separate Instance Integration (Doc ID 1320568.1) 

• CS/HCM Subscriber Only or Subscriber/Subscriber KM doc - (Doc ID 1412093.1)

Please note that HR core maintenance will still need to be applied to Campus Solutions.