Temporary Objects From Allocation Not Deleted From OFSA_TEMP_OBJECTS in PA 4.5

(Doc ID 141313.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Profitability Manager - Version 4.5 to 4.5.39 [Release 4.5]
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5
Oracle Performance Analyzer - Version: 4.5 to 4.5.39
Allocation ID
Note: All OFSA 4.5 products have reached sustaining support.

Symptoms

In Oracle Performance Analyzer (PA) 4.5, when you run an Allocation ID on the client-side in "Preview" mode, you get the following error:

1041 Pct returns no records
1042 Invalid Page.
Page: 1

You see that temporary objects have not been deleted from table OFSA_TEMP_OBJECTS.  There are many OFSPA_CRDT_XXXXXXXXXXXXXX and OFSPA_DBT_XXXXXXXXXXXXXX tables and temp objects in the OFSA database.

Note: You receive the error because the Pct Distribution portion does not pick up any records in your debit/credit 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