BILLING_METHOD_CD Precision and Data Type Modified After Upgrading to FTP/PFT 6.1 (Doc ID 1614940.1)

Last updated on JANUARY 16, 2014

Applies to:

Oracle Financial Services Profitability Management - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Goal

After upgrading the data model from OFSAA 6.0 to 6.1, the table FSI_BILLING_METHOD_CD has the primary key modified from VARCHAR2(5) to NUMBER(5). Existing records on the table were "CPB", "CAB" and "AB" and now due to the change, they cannot be moved back from the backup table to the new table.

Is the conversion explained in any documents?

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