R12/XTR: ORA-01779 CANNOT MODIFY A COLUMN WHICH MAPS TO A NON KEY-PRESERVED TABLE XTR_MASTER_CURRENCIES_V (Doc ID 2174576.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Treasury - Version 12.2.4 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.

Symptoms

ORA-01779 CANNOT MODIFY A COLUMN WHICH MAPS TO A NON KEY-PRESERVED TABLE
Authorize Currency : Setup > Policies> Currency Details, After setting up spot rates for USD, User still cannot authorize USD currency.

Every time User try to move USD currency from unauthorized currency column into authorized currency column, User get the error message below.

ERROR
-----------------------
ORA-01779 CANNOT MODIFY A COLUMN WHICH MAPS TO A NON KEY-PRESERVED TABLE


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. in treasury responsibility
2. Setup > Policies> Currency Details
3. Add and maintain currencies for all currencies

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