Payroll Balance Initialization Errors

Query 

SELECT pbh.batch_name

,pbh.batch_status

,pbl.LINE_SEQUENCE

,pbl.PAYROLL_RELATIONSHIP_NUMBER

,pbl.ASSIGNMENT_NUMBER

,pbl.BALANCE_NAME

,pbl.DIMENSION_NAME

,pbl.batch_line_status

,pbl.value

,LISTAGG(pml.line_text, '; ') WITHIN

GROUP (

ORDER BY pbl.LINE_SEQUENCE

) "Error_list"

FROM pay_bal_batch_headers pbh

,pay_bal_batch_lines pbl

,pay_message_lines pml

WHERE pbh.batch_name = nvl(:Batch_Name, pbh.Batch_Name)

AND pbl.batch_id = pbh.batch_id

AND pbl.batch_line_status = 'E'

AND pml.source_type = 'L'

AND pml.source_id = pbl.batch_line_id

GROUP BY pbh.batch_name

,pbh.batch_status

,pbl.LINE_SEQUENCE

,pbl.PAYROLL_RELATIONSHIP_NUMBER

,pbl.ASSIGNMENT_NUMBER

,pbl.BALANCE_NAME

,pbl.DIMENSION_NAME

,pbl.batch_line_status

,pbl.value

Comments

Post a Comment

Popular posts from this blog

HCM Extracts

  Common Entities used in HCM Extracts Person - PER_EXT_SEC_PERSON_UE Worker Payroll - PER_EXT_PAY_EMPLOYEES_UE Extract Assignment Basic Information - PER_EXT_SEC_ASSIGNMENT_BASIC_UE Assignments Range - PER_EXT_SEC_ASSIGNMENT_RANGE_UE Extract Current and Future Persons - PER_EXT_SEC_PERSON_NOW_FUTURE_UE Extract Current and Future Assignments - PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE
Read more

HCM Data Loader

 Configure HCM Data Loader Parameters Setup and Maintenance > Configure HCM Data Loader > Open task SELECT * FROM hrc_dl_parameters Role for HCM Data Loader Human Resource Integration Specialist List of all Business Objects supported by HDL Under View Business Objects in Data Exchange Types of Keys supported by HDL GUID Oracle Fusion Global Unique ID Hexadecimal Can NOT use while creating new records Source Keys Combination of two fields Source System Owner HRC_SOURCE_SYSTEM_OWNER lookup under Setup and Maintenance > Common Lookups Source System ID  Alphanumeric value Can be used while creating new records Surrogate Keys Can NOT use while creating new records System generated Unique Numeric value for that record User Keys Can be used while creating new records Part of the Business Object that they belong to e.g. JobCode|SetCode Table which stores Source, Surrogate and GUIDs HRC_INTEGRATION_KEY_MAP Update Source Keys once set Yes, using SourceKey.dat Purge HDL Staging ...
Read more