| what values are allowed in API's..? [message #384804] |
Thu, 05 February 2009 04:42  |
MrDuke
Messages: 41
Registered: July 2007
Location: Coventry, UK
|
Member |
|
|
hello.
I've created a UNIX wrapper that includes PLSQL scripts that creates a temp table, loads Employee data in from HR System and using 2 API's, loads the information into relevant ORACLE tables.
As part of my testing, I'm finding there's a multitude of different values in several fields from our HR system that are not being allowed by the API's/ORACLE tables.. So, my question is, could someone please point in the direction of where I can get documentation that will tell me what values are and are NOT allowed in the Hr_Employee_Api.create_gb_employee and Hr_Person_Address_Api.create_person_address API's and in the tables PER_ALL_PEOPLE_F and PER_ADDRESSES.
many thanks..
Steven
|
|
|
|
| Re: what values are allowed in API's..? [message #384880 is a reply to message #384804] |
Thu, 05 February 2009 10:24  |
MrDuke
Messages: 41
Registered: July 2007
Location: Coventry, UK
|
Member |
|
|
..actually thats what I'm trying to find.. I need to now the following 'allowed' lookup values for..
- P_SEX - Valid values are defined by the SEX lookup type.
- P_MARITAL_STATUS - Valid values are defined by the MAR_STATUS lookup type.
- P_NATIONALITY - . Valid values are defined by the NATIONALITY lookup type.
- P_TITLE - . Valid values are defined by the TITLE lookup type.
- P_STUDENT_STATUS - If this employee is a student, this field is used to capture their status. Valid values are defined by the STUDENT_STATUS lookup type.
..eg, whats allowed for marital_status - 'M'arried, 'S'ingle,'W'idowed, 'LivingInSin'....?
thanks
Steven
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
