After Execution, Batch Task With "Batch_table_class_req" Shows Failed in OFSAA
(Doc ID 1085703.1)
Last updated on JANUARY 08, 2025
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 7.1 and laterInformation in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.x
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.x
Symptoms
In OFSAAI 7.1, when attempting to run the last post application installation step:
"Batch with "Batch_Table_Class_Req" task needs to be created and executed [for any mis-date].This step will ensure the object-registrations are validated and made available to the individual applications."
the following error occurs:
ERROR
The batch monitor shows that the batch task status is "[9917] Failed".
Additionally, there are no log files are generated in the $FIC_DB_HOME/log/date directory. Note: If Batch_Table_Class_Req is being run for the first time, the "date" directory will not exist.
The issue can be reproduced at will with the following steps:
1. Create a new Batch:
Created new Batch: Operations -> Batch Scheduling
Batch ID: OFSAAID1_OBJREG : ObjectRegistration
Batch Definition:
Component ID: TRANSFORM DATA
Task ID: Task1
Description: null
Metadata Value: Batch_Table_Class_Req
Batch Parameters
Parameters for Task: Task1
Property:
Datastore Type: EDW
Datastore Name: OFSAAID1
IP Address: <IP ADDRESS>
Rule Name: Batch_Table_Class_Req
Parameter List: NULL
2. Run the new batch in Batch Scheduling with the following:
Control Centre
Information Domain: OFAAID1
Batch Run Identification: OFSAAID1_OBJREG
Information Date: 30 Mapt 2010
3. Check the Batch Monitor and see the error.
The issue can be reproduced at will with the following steps:
1. Create a new Batch:
Created new Batch: Operations -> Batch Scheduling
Batch ID: OFSAAID1_OBJREG : ObjectRegistration
Batch Definition:
Component ID: TRANSFORM DATA
Task ID: Task1
Description: null
Metadata Value: Batch_Table_Class_Req
Batch Parameters
Parameters for Task: Task1
Property:
Datastore Type: EDW
Datastore Name: OFSAAID1
IP Address: <IP ADDRESS>
Rule Name: Batch_Table_Class_Req
Parameter List: NULL
2. Run the new batch in Batch Scheduling with the following:
Control Centre
Information Domain: OFAAID1
Batch Run Identification: OFSAAID1_OBJREG
Information Date: 30 Mapt 2010
3. Check the Batch Monitor and see the error.
Changes
New OFSAAI Installation.
New Oracle Financial Services Profitability Management (OFSPM) 5.1 Installation.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |