Firstly read the article Audit Trail in Apps
Why are the steps for Auditing slightly different in Oracle HRMS?
This is mainly due to Date-Tracking feature which is HRMS/Payroll Specific.
For Auditing HRMS tables.....
Step 1. Check if Profile AuditTrail:Activate at site level
select fnd_profile.value('AUDITTRAIL:ACTIVATE') from dual ;
Step 2. Defined Audit Group and Audit Table in sysadmin
Step 3. Run process 'AuditTrail Update Tables' from System Administrator
Step 4. Run process 'Audit Trail Update Datetracked Tables' --From HRMS Superuser
Having followed the above steps will cause data to be created in shadow HR tables, names of these tables end with _A.
To move the data from 'shadow tables' into 'HR_AUDIT and HR_AUDIT_COLUMNS', you need to run process 'Audit Report' from HRMS Super User responsibility. The shortname of this program is PAYAUDIT.
Next you can check....
SELECT OLD_VALUE, NEW_VALUE FROM HR_AUDITS AUD, HR_AUDIT_COLUMNS ADC WHERE AUD.AUDIT_ID = ADC.AUDIT_ID AND AUD.TABLE_NAME = 'PER_ALL_PEOPLE_F' AND ADC.COLUMN_NAME = 'a column name being tested against'
That completes the Audit for tables in Oracle HRMS/Payroll.
Subscribe to this comment's feedwritten by Amita , July 09, 2007
Currently, the New Hire process in HRSS is split into 3 different transactions:
1. New Hire - Step 1 - this transaction is the seeded New Hire transaction with personalizations and field level controls extension
2. New Hire Step 2 - this transaction is actually the SIT's of Applicant Details, Job History and Company Property
3. New Hire Step 3 - this transaction is actually the Assignment EIT's of Job Info
Given that HRSS does not have date tracking, I cannot complete steps 2 and 3 when the New Hire is created with a future date. There is no way for me to find the future dated new hire in order to complete steps 2 and 3.
So can you give me work around for this please
Thank you
Amita
written by Krishna Prasad Rapolu , July 10, 2007
What is version of the applications you are using?
As SSHR not supports the date track features.But some SSHR screens facilated with the dated information.
I believe that New Hire SSHR functionality facilitates with the effective dated information in the first screen.
Are you able to perform the Steps 2 & 3 with the current dated New hire?
Regards
KP/..
written by Amita , July 10, 2007
The version for
RDBMS : 9.2.0.5.0
Oracle Applications : 11.5.10.2
Yes I am able to perform the step2 and step 3 for the current dated hire ...but I have created an employee performing step1 with future effective date say 07/16/2007 then I cannnot see that employee to perform the step 2 and step 3 .
While I see that person from the core form when I alter my date tracking effective date to 07/16/2007.
- Amita
written by Amita , July 10, 2007
Yes my challenge is in getting the person in the SSHR listing to go further and populate the SIT AND EIT ..yes the current snapshot[datetrack=sysdate] makes these two records invisible to the user. but in the advanced search if I try searching based on the first name , last name and hire date=07/16/2007 the result set is no data exist .
Deviation in design is not possible at this stage ....but option 2 is something I can propose on the table .is there a way I can tweak the static query used in sshr by opening up the java page in jdevloper ?
Thanks
Amita
written by A Passi , July 10, 2007
Yes, you can extend the ViewObject. but I didn't think that was an ideal solution, primarily because BC4J extensions get applied at site level, and hence extending the VO Query must be the last option.
I also suggest you raise a SR on Metalink.
Thanks,
Anil Passi
| < Prev | Next > |
|---|
I am starting my work on Oracle benefits.
Can you post the flow and tables related to Oracle benefits.
Thanks in advance