UNABLE TO UPDATE LOCATION: ORA-20000: Cll_f255_hr_locations_t1 - ERROR: ORA-04092: Cannot ROLLBACK

(Doc ID 1952488.1)

Last updated on DECEMBER 04, 2015

Applies to:

LAD Add-on Localizations - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

CURRENT BEHAVIOR:
-----------------------------------------------------------------------------------------------------------------------
Changes in the Brazilian Receivables Responsibility raise the following error:

ORA-20000: cll_f255_hr_locations_t1 - ERROR: ORA-04092: cannot ROLLBACK in a trigger
ORA-00942: table or view does not exist
ORA-06512: at "APPS.CLL_F255_HR_LOCATIONS_T1", line 40
ORA-04088: error during execution of trigger 'APPS.CLL_F255_HR_LOCATIONS_T1'
ORA-06512: at "APPS.HR_LOCATION_API", line 1024

EXPECTED BEHAVIOR
-----------------------------------------------------------------------------------------------------------------------
Perform the changes without errors


STEPS TO REPRODUCE:
-----------------------------------------------------------------------------------------------------------------------
Receivables > System > Organisations > Locations
Query for a Brazilian location and trying to update.

 

SIMILAR ISSUES CAN OCCUR FOR OTHER CLL_F255 TRIGGERS.

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