New Interview Questions

1. What is interface and conversion and what interface you developed explain complete process along with error handling part.
2. API name and table for element entry
3. How to do conversion process.
4. Inbound interface name and outbounf interface name that you worked on.
5. AOL basics like tables for value set and types of value sets and table for indepdent VS.
6. Pragmatic autonomous transaction.
7. SQL function for string
8. Cascading Decode statement.
9. Bulk collect with limit syntax and limitation .
10. The largest component you have ever worked on explain that.
11. Unix basics command for file access.
12. XML publisher reports registration steps.
13. Trigger
14. All base tables name for Oracle HRMS
15. Workflow tables.
16. Hint in SQL
17. Public and private API in Oracle
18. Ref cursor and usage of that.
19. Collection type variables.
20. Count(*) will generate no data found exception or not if conditions don’t match in where clause.
21. How to generate XML file from PLSQL package.
22. How to migrate template from one instance to other.
23. How to skip records from ctl file.
24. What will be status after awaiting for shipping in o2c.
25. How to submit request set from back end.
26. Profile objective creation and order of precedence at different level.
27. Ddl dml and command for SQL.
28. Max number of the columns in oracle tables?
29. Total attributes in table atnd what is Global attribute.
30. Total segments in table kff enabled table.
31. Total size of any object in oracle database .
32. What is AuthID in create or replace. Package.
33. Difference between procedure and Function.
34. INOUT parameters what is the purpose of nocopy with that?
35. What is lookups and what all are the tables for the same.
36. If emp is terminated then what will be the current employer flag in per_all_peope_f table.
37. When to use NOCOPY parameters in parameters.

1. How to swap to different column values in a table
2. What is pragma autonomous transaction
3. API for emo cretion
4. How to continue the interface process if any errors comes in between
5. Ame steps to create rule for salary proposal
6.table to get the salary info And table if no payroll module is implemented.
7. PTO and absence formula for grade rule n fast formula
8. If we want to roll back the element entry processed through the batch process how we will do it
9. what is Batch process
10. Setup for Core HR , Payroll and setup level definition and what it is like organization, business group and payroll
11. Organization hierarchy for implementation setup
12. Payroll full life cycle before payroll process and after payroll process
Advertisements

Oracle Payroll Short Notes

Payroll

Payroll Description:

Date Offset

  • Check
  • Scheduled Run
  • Cut Off
  • Payslip

Costing: Costing and Suspense Account

Negative Payment Allowed/ Multiple Assignments

Consolidation Set

Payment Method:

GL Flex Field Mapping

Update Payroll Run Purpose?

Assignment Set: Criteria/Ammendment

Element Set: Include/Exclude/Element Rules/Classification Rules

GL Daily Rates

Conversion Rate Types

Monetary Units

Balance Set

Total Compensation

Earnings: Calculation Rule/ Termination Rules/Element Type/

Deduction

Element Description: Recalculation Events/Proration/Input Values/Balance Feeds/DFF

Multiple Entries/

 

How does the Retro Notification Report and Retropay (Enhanced) Work?

The retrospective changes made will be recorded in pay_process_events with the following details:

  • pay_process_events.effective_date as the effective date (back date) in the system on which the change/update was made
  • pay_process_events.creation_date as the system date when the change/update was made.

When the Retro Notification report (RNR) is run, it will check for the date stored in pay_recorded_requests.recorded_date with attribute_category RETRONOT_ASG. This will tell RNR till which date the events are processed for an assignment. And will find the new events (i.e. events with creation_date after the recorded_date) and process them. It will create retro assignments (pay_retro_assignments) and retro entries (pay_retro_entries)

The Retropay(Enhanced) will process the assignments for which records were inserted into pay_retro_assignments by last RNR. It reprocesses all payroll actions (Quick Pay, Run, Balance Adjustments and Reversals) and creates retro entries where variances in balances are found.

If you do any further retrospective changes, the date stored in pay_process_events.creation_date would be greater than the pay_recorded_requests.recorded_date. Hence it would be processed in the next RNR run. This RNR would insert a new record in pay_retro_assignments and the same would be picked up by Retropay (Enhanced).

 

Doc ID 1213203.1

Extra Information Types (EIT) in Oracle Applications

In this blog I will explain how to create EIT in Oracle HRMS.EITs are basically Descriptive Flexfields (DFF).Standard product has EIT DFFs defined in forms such as Person,Assignment,Job etc.We can add segments to the defined DFF based on our requirements so that it will appear in corresponding screen.Compared to SIT EIT has added security.We can enable EIT  for specific responsibility.

Following steps needs to be perform to create EIT.

1) Create the DFF segments.

Navigate to Application Developer > Flexfield > Descriptive > Segments.

Query for Extra Person Information under Human Resources application.

Uncheck Freeze Flexfield Definition and create the segment.

Click on Segments.Enter the segment details.

Click on save.In the Descriptive Flexfield Segments window check the Freeze Flexfield Definition.Save your work.

2) Register the Extra Information Types.

Navigate to Super HRMS Manager responsibility.Select Register Extra Information Types (EITs) standard concurrent program from the SRS window.Give appropriate values and submit.

3) Assign the EIT to responsibility.

Navigate to Security > Information Types Security under any HRMS responsibility.

Choose the appropriate responsibility (Here I am using Human Resources, Vision Enterprises). Assign the above created EIT.

Save your work.

4) Test the EIT.

Navigate to Human Resources, Vision Enterprises responsibility.Choose any person of type Employee.Click on Others and choose Extra Information.

Save your work.

The above entered information will get populated in PER_PEOPLE_EXTRA_INFO.

The API to create EIT information is HR_PERSON_EXTRA_INFO_API.

Date Track Modes

Update Date Track Modes

CORRECTION : Over writes the data. No history will maintain.
UPDATE : Keeps the history and new change will effect as of effective date
UPDATE_CHANGE_INSERT : Inserts the record and preserves the future
UPDATE_OVERRIDE : Inserts the record and overrides the future

 Delete Date Track Modes

ZAP : wipes all records
DELETE : Deletes  current record
FUTURE_CHANGE : Deletes current and future changes.
DELETE_NEXT_CHANGE : Deletes next change