Why is the ISO_CURRENCY_CD Column Default Value Changed to Null After 4.5.36 DUP Script Run? (Doc ID 216412.1)

Last updated on MARCH 04, 2009

Applies to:

Oracle Financial Services Applications (OFSA) - Version: 4.5
Oracle Financial Data Manager - Version: 4.5 to 4.5.40
Information in this document applies to any platform.

Goal

Before upgrading to 4.5.36, the ISO_CURRENCY_CD columns on LEDGER_STAT and OFSA_AUDIT_TRAIL previously had been set to the functional currency.  Why was the ISO_CURRENCY_CD column default value changed to null as below in the 4.5.36 database upgrade (DUP) scripts?

ALTER TABLE ledger_stat
MODIFY iso_currency_cd
DEFAULT NULL;

ALTER TABLE ofsa_audit_trail
MODIFY iso_currency_cd
DEFAULT NULL;

Solution

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