Tuesday, December 31, 2013

Alliance 2014



Looking forward to another Alliance!  Here are the details for 2014. 

http://www.alliance-conference.com/e/in/eid=248&s=8467&print=1&req=info

Here are the sessions that I will be presenting this year.


Session Title:Best practices for applying Campus Solutions Maintenance
Session Number:33081
Track:Technical
Crosslisted Track:Oracle
Session Type:Vendor
Sub-Categorization:Select A Value
Room Assignment:Section 313 + 316 => Mon, Mar 10, 2014 (01:45 PM - 02:45 PM)
Initial Submission:Sep 23, 2013 10:54 AM America/Arizona


Co-Presenting

Troubleshooting CS-HCM and Other Campus Solutions Web Services

Session Number: 33107
Track: Technical
Sub-Categorization: Select A Value
Session Type: Oracle Application
Tags: AAWS, Integration, Peoplesoft 9.0, Split
Primary Presenter: Daune' Oliveira [Principle Technical Support Engineer - Oracle]
Co-Presenter: Jeromy McMahon [Principle Technical Support Engineer - Oracle]
Co-Presenter 2: Andrew Cesario [Senior Principle Technical Support Engineer - Oracle]
Time: Mar 12, 2014 (10:30 AM - 11:30 AM)

Monday, September 9, 2013

How to TEST? Using Generic Service Tester - Service: SCC_USERREG - Service Operation: SCC_USERREG_AUTHENTICATE

In the next few weeks, I am going to post some good samples and How To's for testing AAWS (Admission Application Web Services) and NUR (New User Registration).


How do I test?
Service Name:  SCC_USERREG
Service Operation: SCC_USERREG_AUTHENTICATE

Navigate to:  
Set Up SACR -> System Administration ->Utilities -> Generic Service Tester -> Service Tester



Enter in a valid user to test.  In this sample, I am using the same PS user.

Friday, July 19, 2013

AAWS - Admissions Application Web Services - Listing of great KM docs from Oracle

Here is a listing of KM docs regarding AAWS.

AAWS - CS 9.0 Bundle #23 Functional Documentation and Additional Features October 2011 (Doc ID 1371376.1)

Campus Solutions 9.0 Generic Service Tester Tool (Doc ID 1478817.1)

1323959.1 - AAWS - Data Mapping and Entity Catalog
1373575.1 - AAWS - Sample XML Files for SAD_GETAPPL_REQ and SAD_CREATEAPPL_REQ


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





Thursday, May 2, 2013

Entity Property Sync

Where is the Entity Sync within Campus Solutions?

Set Up SACR > System Administration > Entity >Entity Property Sync

Once you are on the page/component, click the "Sync All Entity Properties" button.