Description:
Use this window to define each work location used by your enterprise. This window contains information and notified the problems, such as Inventory Organization, that is used by other Oracle Applications.
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 enabled with the following setting http://elocation.oracle.com/servlets/lbs without the DMZ being setup.
The problem is that if the elocation function is enabled, then any type of address form that is trying to be updated, it will error out. This is because this function tries to make a call to the location servers, 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 set up, 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
- Navigate to Profile > System.
Click on Open and Query the Profile Option “IRC: Geocode Host.”
Click on Find.
- Clear the value at the Site level for the profile option “IRC: Geocode Host” and save.
- Retest the issue:
Now again, go to Location form in oracle.
You can now create the location and save.
Summary:
This Post explained that the errors in the new location with notification code in application bottom.
queries?
Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your question.
