Getting ORA-20002 & ORA-04088 on CURRENCIES_BR2 Importing into OFSA_CURRENCIES

(Doc ID 252211.1)

Last updated on JULY 29, 2008

Applies to:

Oracle Financial Services Applications (OFSA) 4.5
Oracle Financial Data Manager - Version: 4.5
This problem can occur on any platform.

Symptoms

You cannot import ISO_CURRENCY_CD values 000, 001, and 002 into OFSA_CURRENCIES.  You receive the following errors:

IMP-00058: ORACLE error 20002 encountered
ORA-20002: Currency codes beginning with 0 are not allowed.
ORA-06512: at "dbowner.CURRENCIES_BR2", line 13
ORA-04088: error during execution of trigger 'dbowner.CURRENCIES_BR2'

You currently do not have any rows with ISO_CURRENCY_CD values 000, 001, and 002 in OFSA_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