Could not Reserve Record Error while Updating Grade Step Placements

Run the following scripts to Update Object version number which is the cause of this issue

Step 1:

create table per_spinal_point_plac_bkp as select * from per_spinal_point_placements_f;

Step 2: (Check no of rows to be updated)

SELECT count(*)

  FROM per_spinal_point_placements_f

 WHERE object_version_number IS NULL;

Step 3: Update Object Version Number

UPDATE per_spinal_point_placements_f

   SET object_version_number = 1

 WHERE object_version_number IS NULL;

How to Change Hire Data of the Employee

Step 1

Navigate to HRMS Super User à People à Enter & Maintain à Search for the Employee for which Original Hire date has been changed

Step 2

Change the Latest Start Date on Enter & Maintain Screen à Save à Check the Following tables to check if the hire dates have changed

select person_id,effective_start_date from per_all_people_f where employee_number   = <EMPLOYEE_NUMBER>

 select date_start from per_periods_of_service where person_id = <PERSON_ID>

Step 3 (Only if Required)

Use the following API to change the Original Hire Date

hr_change_start_date_api.update_start_date

Employee Wise Costing Information - Organization Level

SELECT per.employee_number,
       per.full_name,
       haou.name,
       pcak.segment2 division,
       pcak.segment3 department
  FROM per_people_x per,
       per_assignments_x paaf,
       hr_all_organization_units haou,
       pay_cost_allocation_keyflex pcak
 WHERE     per.person_id = paaf.person_id
       AND paaf.primary_flag = 'Y'
       AND paaf.assignment_status_type_id IN (1, 2)
       AND paaf.assignment_type = 'E'
       AND haou.organization_id = paaf.organization_id
       AND pcak.cost_allocation_keyflex_id = haou.cost_allocation_keyflex_id

Error: " XXX Not a valid responsibility for the current user. Please contact your System Administrator."

1) Login with System Administrator Responsibility
2) Navigate to Profile > System, click on User and enter the user name
3) Search for profile 'Applications Start Page'. Delete the value set at user level and save
4) Go to Functional Administrator -> Clear Cache
5) Try logging into the account and try again

Standard WHO Columns

The following are the Standard WHO Columns in most of the Oracle tables:

1. created_by
2. creation_date
3. last_update_date
4. last_updated_by
5. last_update_login

• Use fnd_profile.VALUE ('USER_ID') for retrieving the user_id which will be used by created_by column.
• Creation date and last_update_date will be normally SYSDATE.
• last_updated_by is same as created_by
• Use USERENV ('SESSIONID') for getting the last_update_login id.

Oracle - FRM-92050 failed to connect to Server -- *Solved

If you are trying to connect to Apps 11i/R12 instance from IE 8 and getting an error
“FRM-92050 failed to connect to Server /forms/servlet -1“  while opening form.. Follow the steps as given below to get rid of the same..



Then check version of IE

If version of IE is 8 then disable XSS filter




Steps to disable XSS filter