My Oracle Support Banner

famrcpi.sql Failing During Upgrade (Doc ID 433273.1)

Last updated on AUGUST 13, 2019

Applies to:

Oracle Assets - Version 11.5.10.2 and later
Information in this document applies to any platform.
Applicable on 11.5.10 upgrades as well as R12

Symptoms

Upgrade the following error occurs:

ORA-01722: invalid number occurred while executing the SQL statement:

ALTER TABLE FA_MC_ADJUSTMENTS MODIFY ( SET_OF_BOOKS_ID DEFAULT NVL (TO_NUMBER ( SUBSTRB ( USERENV ( 'CLIENT_INFO') ,45,10 ) ) ,-1 ) )
Error occurred in file /apps/oraprod/finprodappl/fa/11.5.0/patch/115/sql/famrcpi.sql with arguments ''.

Changes

This occurs during an upgrade to 11.5.10.

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.