Table Name that stores the HCM Extract Results
The table names are Pay_Object_Actions and Pay_Action_Information. The data generated by the extract can be retrieved using the following tables and the below SQL. For your query, change Object Action ID. select * from pay_action_contexts pac , pay_object_actions oa , pay_action_information pai where oa.object_action_id = 12345 and oa.object_action_id = pac.action_context_id The column mappings from PAY_ACTION_INFORMATION can be retrieved using the following: select de.* from PER_EXT_DATA_ELEMENTS_B de ,pay_report_records_f rr ,pay_report_blocks rb ,per_ext_definitions_vl ed where de.report_record_id = rr.report_record_id and rr.report_block_id = rb.report_block_id and rb.ext_definition_id = ed.ext_definition_id and rr.flex_structure_code = 'PAY_ACTION_INFORMATION.ACTION_INFORMATION_CATEGORY' order by information_column