R12.2 Apps DBA. Powered by Blogger.

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

No comments :
Go to : 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:
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.

No comments :

Post a Comment

Note: only a member of this blog may post a comment.