My Oracle Support Banner

ORA-00904: "FSI_DATA_IDENTITY"."FISCAL_YEAR_MONTH": Invalid Identifier Errors Running Allocations After Upgrade to (Doc ID 2847704.1)

Last updated on MAY 19, 2023

Applies to:

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


After upgrading database server and client from 12c to 19c and applying 80660 patches, the following error occurs when running allocations in FSI_MESSAGE_LOG and nohup.out from AM server:

ORA-00904: "FSI_DATA_IDENTITY"."FISCAL_YEAR_MONTH": invalid identifier

After checking the log file from patch p31562914, it is discovered that the patch completely failed to apply and the following error happens:

Environment check utility Status : SUCCESS
Shutdown of OFSAAI services started...
Shutdown of OFSAAI services done.
Now checking the Packname....OFS_PFT_PACK
Starting OFSAA Service...
OFSAA Service - OK
Pack Name is OFS_PFT_PACK
CTRL characters removal from patch files started ...
CTRL characters removal from patch files over ...
log file:/install/p31562914_80000_Linux-x86-64/OFS_PFT_PACK/OFS_PFT/logs/OFS_PFT_patch_installation.log not found, Sandbox upgrade will be skipped
Starting OFS_PFT - Patch
****** Please specify valid values in params.conf Aborting Installation ******
Problem while applying patch for OFS_PFT APP.
Patch Installation terminated.

The issue can be reproduced at will with the following steps:

1) Bring down both DB and application
2) Upgrade DB from 12c to 19c
3) Install 19c client on Application servers.
4) Update the 19c configuration on DB server for Loader scripts.
5) Apply the patch p31284429 on application server
6) Apply the patch p31562914 on application server
7) Manually copy all files from the patch files: p31562914_80000_Linux-x86-64/OFS_PFT_PACK/OFS_PFT/bin/ficdb/linux7/oracle19.3/bin/pft.




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

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