Converstion | API | Table |
Organization | hr_organization_api.create_hr_organization | hr_all_organization_units |
Job | hr_job_api.create_job | hr.per_jobs pj, |
hr.per_job_definitions pjd | ||
Organization Update | hr_organization_api.update_organization | hr_all_organization_units |
EIT | hr_person_extra_info_api.create_person_extra_info | PER_PEOPLE_EXTRA_INFO |
SIT | hr_sit_api.create_sit | hr.per_person_analyses ppa, |
hr.per_special_info_types psit, | ||
hr.per_analysis_criteria pac, | ||
applsys.fnd_id_flex_structures_tl fifs | ||
Address | hr_ae_person_address_api.create_ae_person_address | hr.per_addresses |
Assignments | hr_assignment_api.update_emp_asg | hr.per_all_assignments_f |
Basic Salary | hr_maintain_proposal_api.insert_salary_proposal | HR.PER_PAY_PROPOSALS |
Contact | hr_contact_rel_api.create_contact | hr.per_contact_relationships |
DOCR | HR_DOCUMENT_EXTRA_INFO_API.create_doc_extra_info | hr_document_types hdt, |
hr_document_extra_info hdei, | ||
Element | pay_element_types_api.create_element_type | hr.pay_element_types_f |
Element Links | pay_element_link_api.create_element_link | hr.pay_element_links_f |
Employee | hr_employee_api.create_employee | Per_all_people_f |
Fast Formula | ff_functions_api.create_function | FF_FUNCTIONS |
ff_function_parameters_api.create_parameter | FF_FUNCTION_PARAMETERS |
Oracle Technical Experience and Test Cases Shared from different resource and through self leanings.
March 4, 2016
HRMS API with tables
Subscribe to:
Posts (Atom)
COALESCE-SQL
Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...
-
In HRMS we do use date with timestamp for EIT ans SIT segments. To change the format od the date we can use fnd_date . canonical_to_date ...
-
Converstion API Table Organization hr_organization_api.create_hr_organization hr_all_organization...
-
Create the concurrent program.to move you need to extract the ldt and upload the same through the script for nay other instance.Below have ...