Running the pre-processor after registering user-hook in oracle apps / Alternative of pre-processor

To run the pre-processor run one of the following commands:

cd $PER_TOP/admin/sql
Log into SQLPLUS as the APPS user
SQL> @hrahkall.sql

or

SQL> @hrahkone.sql


The first script will create all hook package bodies, whilst the second will
create hook package bodies for one API module only, and prompt for that
api_module_id.

==========================================================

Sometimes if you don't have server credentials then you can use below alternative to run the pre-processor through sqlplus

Log in to database through apps

SQL> @hrahkall.sql

instead of running above script you can execute below statement

exec hr_api_user_hooks_utility.create_hooks_all_modules;

SQL> @hrahkone.sql

instead of running above script you can execute below statement

exec hr_api_user_hooks_utility.create_hooks_one_module(p_module_id);

Important Tables in HRMS

Important Tables in HRMS

person details

• per_all_people_f

Assignment details

• per_all_assignments_f

person type details 

• per_person_types
• per_person_type_usages_f

Termination details

• per_periods_of_service

Person SIT

• per_person_analyses
• per_analysis_criteria

Person EIT

• per_people_extra_info

HR Locations

• hr_locations_all

HR Organizations

• hr_all_organization_units

HR Jobs

• per_jobs
• per_job_definitions

HR Grades

• per_grades
• per_grade_definitions

HR Positions

• hr_all_positions_f
• per_position_definitions

People Group

• pay_people_groups

Employee address

• per_addresses

Employee Phones

• per_phones

Employee Qualifications

• per_qualifications

Employee Contracts

• per_contracts_f

Organization additional information / organization classification/ organization eit details

• hr_organization_information

All self service transaction details are stored in the below tables.

For all hr transactions

- hr_api_transactions
- hr_api_transaction_steps
- hr_api_transaction_values

for payroll related transactions, e.g. salary change

- per_pay_transactions

=====================================================

History tables for SSHR transactions

PQH_SS_TRANSACTION_HISTORY
PQH_SS_STEP_HISTORY
PQH_SS_VALUE_HISTORY
PQH_SS_APPROVAL_HISTORY        

======================================================


You can use above all tables in AME for tracking the self service transactions.

you can use transaction_id of hr_api_transactions and per_pay_transactions in  AME test workbench to see the attributes values, approvals , rules.

Join these tables with wf_notifications to identify status of the transaction.

How to Rollback SSHR Transaction in oracle apps

How to Rollback SSHR Transaction in oracle apps.

execute hr_transaction_api.rollback_transaction(p_transaction_id);

commit;

Note:

p_transaction_id is the transaction_id that you will find in hr_api_transaction table.

After executing the above statement you will not find any record in hr_api_transaction