ORA-00942 Error on Ledger Allocation Temporary Table ALLOC_123456_1234 (Doc ID 1312155.1)

Last updated on APRIL 17, 2011

Applies to:

Oracle Financial Services Profitability Management - Version: 5.2 and later   [Release: 5 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (OFSPM) 5.2, you are trying to run a Ledger Stat to Ledger Stat Static Driver Allocation.  The Allocation fails with the following error in the View Log:

(203105) Oracle drv_oci error:
OCI Function: [4] - oexec(), oexn()
SQL Function: [0] - SQL function not found!
Oracle Error: ORA-00942: table or view does not exist
Driver Function: drv_oci::Execute()

SQL Statement:
insert into ALLOC_123456_1234(FINANCIAL_ELEM_ID, ORG_UNIT_ID,
GL_ACCOUNT_ID, COMMON_COA_ID, PRODUCT_ID, identity_code,
year_s, accum_type_cd,  consolidation_cd, balance_type_cd, iso_currency_cd,
month_01, ytd_01, month_02, ytd_02, month_03, ytd_03, month_04, ytd_04,
month_05, ytd_05, month_06, ytd_06, month_07, ytd_07, month_08,
ytd_08, month_09, ytd_09, month_10, ytd_10, month_11, ytd_11,
month_12, ytd_12)
values (:FINANCIAL_ELEM_ID, :ORG_UNIT_ID, :GL_ACCOUNT_ID,
:COMMON_COA_ID, :PRODUCT_ID, :identity_code, :year_s,
:accum_type_cd, :consolidation_cd, :balance_type_cd,
:iso_currency_cd, :month_01, :ytd_01, :month_02, :ytd_02,
:month_03, :ytd_03, :month_04, :ytd_04, :month_05, :ytd_05,
:month_06, :ytd_06, :month_07, :ytd_07, :month_08, :ytd_08,
:month_09, :ytd_09, :month_10, :ytd_10, :month_11, :ytd_11,
:month_12, :ytd_12 )

As a result of the error, the allocation does not output any records to LEDGER_STAT.

Steps to Reproduce:
  1. Go to Profitability Management
  2. Go to Rule Specification > Allocation Specification
  3. Run a Ledger Stat to Ledger Stat Static Driver allocation

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