My Oracle Support Banner

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 01, 2019

Applies to:

Oracle Treasury - Version 12.2.4 to 12.2.8 [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 gets the error message below.



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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.