OFSAA 6.0 Allocation Batch Displays Hanging Ongoing Status When Allocation Fails With ORA- Error
Last updated on JULY 11, 2017
Applies to:
Oracle Financial Services Profitability Management - Version 6.0.3 to 6.1.0.1 [Release 6]Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.3
Oracle Financial Services Analytical Applications (OFSAA) - Version 6.x
Symptoms
On Oracle Financial Services Profitability Management (PFT) 6.0.3, the PFT engine fails to send proper failure messages for ORA- errors to the ICC batch engine. The batch remains hanging in Ongoing status.
ERROR
Batch continues in 'Ongoing' status even though it has failed with ORA- errors:
PRTCPT_ACCT_COST.BOOK_CODE_ID
Invalid Debit.
Page: 1
(203105) Oracle drv_oci error:
"OCI Function: [4] - oexec(), oexn()"
"SQL Function: [0] - SQL function not found!"
"Oracle Error: ORA-00903: invalid table name"
"Driver Function: drv_oci::Execute()"
"SQL Statement: TRUNCATE TABLE "
(203105) Oracle drv_oci error:
"OCI Function: [4] - oexec(), oexn()"
The issue can be reproduced at will with the following steps:
1. Create allocation which will fail with ORA- errors.
2. Run allocation and check batch status in batch monitor and check FSI_MESSAGE_LOG and debug log file for errors.
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