Creating an Address for an Organization Location Receive Address Style Error: FRM-40735: ON-INSERT Trigger Raised Unhandled Exception ORA-12899

(Doc ID 1539037.1)

Last updated on OCTOBER 12, 2017

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.
PERWSLOC.fmb

Symptoms

On 12.1.3 in Production:

Get following error occurs when trying to setup organization location related information
after entering address related information and trying to save.
 
ERROR
-----------------------

FRM-40735: ON-INSERT trigger raised unhandled exception ORA-12899. 
 

Steps to Reproduce
The issue can be reproduced at will with the following steps:

Navigation:
        Inventory Super User Responsibility > Setup > Organizations > Locations
Query the location
Address Details tab
Address Style: GERENCIA
Enter address information
Click on the OK button
Save and receive the following error:

FRM-40735: ON-INSERT trigger raised unhandled exception ORA-12899. 
ORA-01403: no data found

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the users are not able to successfully create organization location due to errors.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms