Allocation Error 1042 And 1018 After Creating Additional Key Leaves (Doc ID 786078.1)

Last updated on MARCH 16, 2009

Applies to:

Oracle Financial Services Applications (OFSA) 4.5
Oracle Financial Data Manager - Version: 4.5 to 4.5.39
This problem can occur on any platform.

Symptoms

In Oracle Performance Analyzer (PA) 4.5.39, when you try to run an instrument table Allocation ID, the Allocation fails with the following error:

Error running Allocation ID

1016 Table type is not supported.
Check table assignment code in the database
1042 Invalid Page.
Page: 1
1018 Allocation ID is empty.
Edit the Debit/Credit definitions.

The DBA recently created three user defined Key Leaves to use in the Allocations.

Steps To Reproduce:
  1. Log into Performance Analyzer
  2. Go to File > Open > Allocation ID
  3. Run an Allocation that uses an instrument table

Cause

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