My Oracle Support Banner

Migration Script extract_from_source.sh Fails With a SQL*Plus Usage Error During "Extracting AMHM Dimension-Ids" (Doc ID 2768517.1)

Last updated on APRIL 23, 2021

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.2 and later
Oracle Financial Services Asset Liability Management - Version 8.0.2 and later
Oracle Financial Services Profitability Management - Version 8.0.2 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When executing the Oracle Financial Services Funds Transfer Pricing (FTP), Profitability Management (PFT), or Asset Liability Management (ALM) 6.1.1 to 8.0.2 migration, the extract_from_source.sh script in the source fails to migrate data and ends with a failed connection to SQL*Plus.

The following is in the extract_from_source.log before it ends:

[2021.03.03 - 12:45:14 PM PST] ======= Extracting application metadata =======
[2021.03.03 - 12:45:14 PM PST] Extracting AMHM Dimension-Ids ...
[2021.03.03 - 12:45:14 PM PST] extracting dimension ids from source.

SQL*Plus: Release 11.2.0.3.0 Production

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Use SQL*Plus to execute SQL, PL/SQL and SQL*Plus statements.

Usage 1: sqlplus -H | -V

-H Displays the SQL*Plus version and the
usage help.
-V Displays the SQL*Plus version.

Usage 2: sqlplus [ [<option>] [{logon | /nolog}] [<start>] ]

.
.
.
Refer to the SQL*Plus User's Guide and Reference for more information.
[2021.03.03 - 12:45:14 PM PST] Error while extracting dimension-ids. Please check the log file for details.

As a result of this issue, the migration fails.

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