My Oracle Support Banner

R12: AP: After Applying Patch Oracle 1099 Reports Are Failing With Errors ORA-7445[kkqsFindOpn()+37], ORA-24324, REP-0069, REP-57054 And REP-300 (Doc ID 2739540.1)

Last updated on MAY 05, 2023

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

After DB upgrade by RDBMS <Patch 12834800>, All 1099 reports were failing with ORA-24324: service handle not initialized

Then, Application Patch 30273541:R12.AP.B was applied and ALL the 1099 reports started working except for "1099 Forms - Comma Delimited Format" report - APXT7C99.rdf. 
The Report log file shows the following errors:

  MSG-00001: After SRWINIT
  ORA-24324: service handle not initialized
  ==> nvl(decode(length(replace(replace(nvl(pvw.national_identifier,
  REP-0069: Internal error
  REP-57054: In-process job terminated:Terminated with error:
  REP-300: service handle not initialized
  ==> nvl(decode(length(replace(replace(nvl(pvw.national_identifier,


The report executable, file APXT7C99.rdf was not upgraded by the application of Patch 30273541:R12.AP.B

A SQL*Trace file of the execution of the 1099 Comma Delimited Report - APXT7C99.rdf shows Error ORA-7445 occurring.  Trace file shows the following:

*** MODULE NAME:(e:SQLAP:cp:sqlap/APXT7C99) 2020-10-27 07:48:15.125
*** CLIENT DRIVER:() 2020-10-27 07:48:15.125
*** ACTION NAME:(SQLAP/WYN_WWC_AP_MANAGER) 2020-10-27 07:48:15.125
 
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x7A] [PC:0xAA00C45, kkqsFindOpn()+37] [flags: 0x0, count: 1]
Incident 1882341 created, dump file: /ntst1/app/oracle/admin/NTRN_dvsrhlebsd01/diag/rdbms/ntrn/NTRN/incident/incdir_1882341/NTRN_ora_1392_i1882341.trc
ORA-07445: exception encountered: core dump [kkqsFindOpn()+37] [SIGSEGV] [ADDR:0x7A] [PC:0xAA00C45] [Address not mapped to object] []

ssexhd: crashing the process...
Shadow_Core_Dump = PARTIAL
ksdbgcra: writing core file to directory '/ntst1/app/oracle/admin/NTRN_dv***********diag/rdbms/ntrn/NTRN/cdump'

 

Changes

Applied RDBMS <Patch 12834800>

Applied Oracle Applications <Patch 30273541:R12.AP.B>

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.