ORA-7445 [_MEMCPY()+2369] When Doing a Specific SELECT Statement From Cost Management Application (CMCMCW Module)

(Doc ID 1315939.1)

Last updated on MARCH 26, 2012

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 to 11.2.0.2 - Release: 11.2 to 11.2
Information in this document applies to any platform.

Symptoms

When using "CMCMCW module: Material cost transaction worker" application from "Cost Management/Bills of Material" application getting:

ORA-07445: exception encountered: core dump [_memcpy()+2369] [SIGSEGV][ADDR:...] [PC:...] [Invalid Permissions for object] []
errors.

As per incident file the error is always occurring when doing:
SELECT MAX ( ROWID ) FROM MTL_TRANSACTION_ACCOUNTS WHERE TRANSACTION_ID = :B3 AND ORGANIZATION_ID = :B2 AND ACCOUNTING_LINE_TYPE NOT IN ( 9 , 10 , 15 ) AND SIGN ( BASE_TRANSACTION_VALUE ) * SIGN ( NVL ( DECODE ( TRANSACTION_VALUE , NULL , DECODE ( :B1 , 0 , NULL , -1 * :B1 ) , TRANSACTION_VALUE -:B1 ) , 0 ) ) >= 0
statement.

Stack trace:
memcpy evadcd evadcd evaopn2 evaopn2 evaopn2 evamul evareo expepr evaiand expeal qertbFetchByRowID
qergsFetch opifch2 opiefn0 opipls opiodr rpidrus skgmstack rpidru rpiswu2 rpidrv psddr0 psdnal
pevm_EXECC pfrinstr_EXECC pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr ttcpip
opitsk opiino opiodr opidrv sou2o opimai_real ssthrdmain main main_opd_entry

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