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.
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.
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
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