Oracle Apps Error Codes

Oracle Apps Error Codes:

[APP-51000] Invalid position This position does not exist at all, or is not completely within the assignment's date range.

[APP-51001] This vacancy does not exist

[APP-51002] Cannot submit report Possible causes could be that the report does not exist, The concurrent request manager is not working.

[APP-51003] Assignment must have a valid pay period at actual termination date

[APP-51005] Person type must be a type of EMP at actual termination date

[APP-51006] Payroll must have a valid pay period at actual termination date

[APP-51007] Actual termination date must exist before setting final process date

[APP-51008] Person type must be a type of EX_EMP at final process date

[APP-51009] This position is not in the same business group as the assignment.

[APP-51010] Formula return &RET_NAME exceeds size limit of &LIM_SIZE characters.

[APP-51011] Person does not exist at specified date

[APP-51012] Cannot rehire a person who is not a type of EX_EMP

[APP-51013] This person does not have a previous period of service

[APP-51014] Cannot rehire a person unless a final processing date exists for their previous period of service

[APP-51015] The rehire date must be later than the final processing date of the previous period of service

[APP-51017] Assignment Number must be null for applicant assignments

[APP-51018] Hierarchy Level must be greater than 0. The Hierarchy level specified must be greater than 0.

[APP-51019] Primary Key Constraint Error Combination of Entity Name and Pattern Purpose is not unique.

[APP-51020] Unique Key Constraint Error. Combination of Entity Name and Pattern Purpose is not unique.

[APP-51021] Unique Key Constraint Error. Combination of Pattern Purpose and Hierarchy Level is not unique.

[APP-51022] Invalid primary key specified. The Primary key specified is invalid.

[APP-51023] The Pattern Bit Specified is not unique. Pattern Bit specifed is not unique.

[APP-51024] Multiplier must be positive whole number. Multiplier must be greater than 0.

[APP-51026] This record is locked by another user. The Object specified is currently locked. Try again later.

[APP-51027] API Error. Invalid Object Version Number. Invalid Object Version Number. Re-query and try again.

[APP-51028] Employment category is not valid

[APP-51029] Choose a date on which the assignment includes a payroll

[APP-51030] There is a gap in the continuity of Primary Addresses.

[APP-51030] There is a gap in the continuity of Primary/Main Addresses.

[APP-51031] Employee is a supervisor, changing hire will invalidate this.

[APP-51032] Employees previous Employment,has not been closed for more than a day.

[APP-51033] Future dated salary administration records exist

"Team Work" More We Less Me.

          Sameer Patil

Steps For Creating User Hook

Steps For Creating User Hook :Oracle HRMS

Step 1: Find the API for which HOOK has to write.

            There are mainly two tables:

             1)HR_API_HOOKS

             2)HR_API_MODULES

Note:For understanding types of hook search in oracle metalink.

Step 2: Create A PL/SQL  Procedure which fits requirements.

Step 3: Now Register created procedure into Required Hook:

             API for Registering User Hook:

                   . HR_API_HOOK_CALL_API.CREATE_API_HOOK_CALL
                   . HR_API_HOOK_CALL_API.UPDATE_API_HOOK_CALL
                   . HR_API_HOOK_CALL_API.DELETE_API_HOOK_CALL

Step 4: Once Hook registered. We need to run the Pre Processors which will taken care by DBA.

Step 5: Once done with all above steps verify the status of user hook in the table called:

             HR_API_HOOK_CALLS