Tuesday, 20 May 2014

PAYROLL Diagram in Oracle HRMS



Important Interview Question:-

What is the difference between Correction and Update in HRMS

A) Correction does the correcting of the record and it will create another record in the table
     Updation, updates the correct record and it will create another record for the person in the table.


What is P_Validate in the API

A) It has 2 modes, True and False.
If you give the value as True for P_validate, it will just check the validations and it will not loads the data into the base tables
where as If you give the  value as False for P_validate, it will check the validations and it will load the data into the base tables.

Uploading PO Attachments from EBS to FTP Server

 create or replace PROCEDURE xx_upload_po_attachment(errbuff out varchar2, retcode out number)  IS CURSOR cur_new_attmt IS    select ponumbe...