After Execution, Batch Task With "Batch_table_class_req" Shows Failed in OFSAA

(Doc ID 1085703.1)

Last updated on NOVEMBER 20, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.1 and later
Information 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: 10.XX.XX.62
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

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