My Oracle Support Banner

PFT Allocation Fails With "ORA-00903: invalid table name" "(1016) Table type not supported" "(1042) Invalid Page." and "(1018) Allocation ID is empty" Errors (Doc ID 2996398.1)

Last updated on JANUARY 12, 2024

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI / AAI)
Oracle Financial Services Profitability Management (PFT)

Symptoms

On PFT 8.0.2, one allocation output to Ledger Stat is failed. The following error is thrown in the $FIC_DB_HOME/bin/nohup.out log

ERROR

Sucssefully Connected to Atomic Schema.
Connection to database atomic successful
Running allocations with: 209582, 0, atomic, 20231130, 0.
Error: (1016) Table type not supported.
See table FSI_MESSAGE_LOG for more details. Job Number: OFSDOM_Task165_PFT_RUN_V2_20231130_2
Error: (1042) Invalid Page.


OCI Function: [4] - oexec(), oexn()
SQL Function: [0] - SQL function not found!
Oracle Error: ORA-00903: invalid table name

Driver Function: drv_oci::Execute()

SQL Statement: TRUNCATE TABLE
Error: (20006) Internal Error Continued.
See table FSI_MESSAGE_LOG for more details. Job Number: OFSDOM_Task165_PFT_RUN_V2_20231130_2
Error: (20006) Internal Error Continued.

Error: (20006) Internal Error Continued.
See table FSI_MESSAGE_LOG for more details. Job Number: OFSDOM_Task165_PFT_RUN_V2_20231130_2
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:

OCI Function: [4] - oexec(), oexn()
SQL Function: [0] - SQL function not found!
Oracle Error: ORA-00903: invalid table name

Driver Function: drv_oci::Execute()

SQL Statement: DROP TABLE
Error: (1018) Allocation ID is empty.
See table FSI_MESSAGE_LOG for more details. Job Number: OFSDOM_Task165_PFT_RUN_V2_20231130_2
#
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x000000010009fcc0, pid=11550, tid=1
#
# JRE version: Java(TM) SE Runtime Environment (8.0_65-b17) (build 1.8.0_65-b17)
# Java VM: Java HotSpot(TM) 64-Bit Server VM (25.65-b01 mixed mode solaris-sparc compressed oops)
# Problematic frame:
# C [ofspa+0x9fcc0] bool RWTPtrSlistIterator<FCAllocPage,std::allocator<FCAllocPage*> >::operator++()+0x28
#
# Core dump written. Default location: /export/home/ofsaa/app/ofsa8/ficdb/bin/core or core.11550
#
# An error report file with more information is saved as:
# /export/home/ofsaa/app/ofsa8/ficdb/bin/hs_err_pid11550.log
#
# If you would like to submit a bug report, please visit:
# http://bugreport.java.com/bugreport/crash.jsp
# The crash happened outside the Java Virtual Machine in native code.
# See problematic frame for where to report the bug.
#
Warning: iso88951 does not exist.


Other batches are working without issue. This ran successfully in a previous period.  In addition, when opening the allocation in the UI, the drop down for the Output table is empty.

Changes

 

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
References


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