Allocation in Batch Completes Successfully But Outputs Incomplete Result with 'Semget failed'

(Doc ID 2330934.1)

Last updated on NOVEMBER 27, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 6.1.1.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT) 6.1.1.1, one specific Allocation in a Batch completes successfully but fails to post one of its records.  The Allocation posts a Debit and Credit row but only posts one side.  The Allocation finishes with a status of "Completed".

The following series of errors exist in the ofspa.xxxxxxxxxx.log in $FIC_DB_HOME/log/FusionApps:

Module Logging OFS errors: semget failed, errno = 17, file ipcmutex.cpp, line 197

Module Logging OFS errors: semget failed, errno = 17, file ipcmutex.cpp, line 197

Module Logging OFS errors: semget failed, errno = 17, file ipcmutex.cpp, line 197

Module Logging OFS errors: semget failed, errno = 17, file ipcmutex.cpp, line 197

Module Logging OFS errors: semget failed, errno = 17, file ipcmutex.cpp, line 197

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [60] - odescr() SQL

Function: [4] -
SELECT Oracle Error: ORA- 00942: table
or view does not exist Driver Function:
drv_oci::SetColInfoFromResults() SQL Statement:
SELECT distinct TABLE_SYS_ID
FROM fsi_m_alloc_table_id_values
WHERE TABLE_SYS_ID = (
SELECT TABLE_SYS_ID
FROM FSI_M_ALLOC_DETAILS
WHERE ALLOC_ELEMENT_SYS_ID = (
SELECT DRIVER_SYS_ID
FROM FSI_M_ALLOCATION_RULE
WHERE ALLOCATION_SYS_ID = 298314.000000 ) )

Module Logging OFS errors: (203055) Error CreateDynamicView() : DBDrv-
>CreateColFromResults() SQL statement.

Module Logging OFS errors: (203055) Error DynLoadStart() : CreateDynamicView() SQL
statement.

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [60] - odescr() SQL
Function: [0] - SQL function not found! Oracle Error: ORA- 00936:
missing expression Driver Function:
drv_oci::SetColInfoFromResults() SQL Statement:
SELECT count(1)
FROM fsi_m_alloc_table_id
where category= 'F'
AND table_sys_id=

You do not understand what causes the Allocation to post one less record in this case.

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