May 2, 2010

Payroll elements

Important things to be noted in Element descprition:

  • Primary classification: Wether earning,deduction,allowance,information etc..
  • Priority:Execution priority for each element;
  • Recurring or non recurring;Recurring means it will appear for all payroll proccess,non-recurring means it will appear for single payroll proccess.
  • Standard
While linking it you will define wether it is costed or not.
at No comments:
Labels:

Difference between conversions and interfaces

Converstions are one time proccess.Can be suggested for upgrade proccess.

e.g:from 11i to R12

Interface is repeating and can be done scheduled for pre-productions process.
at No comments:
Labels:
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...

  • FND_CANONICAL
    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 ...
  • Fast Formula Results Upload
    Extract Query: SELECT 'RULE',  PET.Element_Name,  TO_CHAR(PPR.legislation_code) ATTRIBUTE1,  TO_CHAR(PPR.assignment_status_typ...
  • FNDLOAD UPLOAD(RTF,XSL),DOWNLOAD
    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 ...