Error Code 20793 Failed to Reserve Table Running OFSA 4.5 Ledger Stat Transformation ID
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.
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 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:  - oexec(), oexn()
SQL Function:  - 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:
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