Error Code 20793 Failed to Reserve Table Running OFSA 4.5 Ledger Stat Transformation ID (Doc ID 276498.1)

Last updated on DECEMBER 06, 2012

Applies to:

Oracle Financial Data Manager - Version 4.5 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version: 4.5

Checked for relevance on 06-Dec-2012.

Symptoms

You are attempting to run a Transformation ID and it fails with 'Internal Error'.

After querying OFSA_PROCESS_ERRORS, you find the following error for your process:

ERROR
Error Description: Transformation: Failed to reserve table
Error Code: 20793

You have already run Grant_All and you are still receiving the error.

From the ofste.XXXXX log file on the server, the following errors also appear:

OCI Function: [4] - oexec(), oexn()
SQL Function: [34] - PL/SQL EXECUTE
Oracle Error: ORA-20000: OFSA-43002: ERROR: Table is being processed by: Table: OFS_RPT_LS_2 User: OFSA ID: OFS_LED_STAT.
ORA-06512: at "FDMOFSA.OFSA_DBA", line 3294
ORA-06512: at "FDMOFSA.OFSA_DBA", line 3310
ORA-06512: at "FDMOFSA.OFSA_SQL", line 587
ORA-06512: at line 1

Driver Function: drv_oci::Execute()

SQL Statement: BEGIN OFSA_SQL.RESERVE_TABLE('OFSA_EULOWNER',101931,'OFS_RPT_LS_2'); END;
Error(Oracle Financial Services Application error) (910001) Unable to process
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:

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