FRM-40735:ON-UPDATE New Locations in Oracle HRMS

Problems while creating the New Locations in Oracle R12

ERROR DETAIL:

Not able to Create the new Locations as well as Update the existing Locations in Oracle.

ERROR MESSAGE:

“FRM-40735:ON-UPDATE trigger raised unhandled exception ORA-29273”

SYMPTOMS:

Responsibility: Human Resources.

Navigation: Work Structures >Locations.

When try to create the Locations and save, the following error appears.

CAUSE:

The "IRC: Geocode Host" was enable with the following setting http://elocation.oracle.com/servlets/lbs with out the DMZ being setup.

The problem is that if the elocation function is enabled, then any type of address form that is trying too be updated it will error out. This is because this function tries to make a call to the elocation severs which is outside the DMZ. What is happening is that the application is trying to get the longitude and latitude data and trying to update tables like the hr_locations_all table and per_addresses table. In this case the DMZ was not setup so the application could not make the call and thus will error out.

SOLUTION:

To implement the solution, please execute the following steps:

1. Go into the responsibility: System Administrator

2. Navigate to Profile > System.

Click on Open and Query the Profile Option "IRC: Geocode Host".

Click on Find.

3. Clear the value at the Site level for the profile option "IRC: Geocode Host" and save.

4. Retest the issue:

Now again go to Location form in oracle.

You can now create the location and save.