Memory Error Occurs After Setting Alternate Routing (Doc ID 2271398.1)

Last updated on JUNE 05, 2017

Applies to:

Oracle Work in Process - Version 11.5.10.0 and later
Information in this document applies to any platform.

Symptoms

Problem Statement
On discrete job form (WIPDJMDF), Routing tab, when alternate value is set , the following error occurs and system can not be saved.

Error
Unable to allocate memory in wigetwk
FRM-41072: Cannot create Group APP_DEBUG

Steps to Reproduce

  1. Enter value to Alternate filed in Routing tab in Discrete Job form.
  2. Save

Trace files shows that the following query is executed many times.

SELECT /*+ INDEX(BOM_SHIFT_DATES BOM_SHIFT_DATES_U1) */
SHIFT_NUM,
TO_NUMBER(TO_CHAR(SHIFT_DATE, 'J')),
DECODE(:ignore_wkdys, 1, 0, SEQ_NUM)
FROM BOM_SHIFT_DATES
WHERE CALENDAR_CODE = :cal_code1
AND EXCEPTION_SET_ID = :excp_set1
AND SHIFT_DATE >= TO_DATE(TO_CHAR(:start_date1), 'J')
AND SHIFT_DATE <=
TO_DATE(TO_CHAR(:start_date2 + 50), 'J')
UNION
SELECT -1,
TO_NUMBER(TO_CHAR(CALENDAR_DATE, 'J')),
DECODE(:ignore_wkdys, 1, 0, SEQ_NUM)
FROM BOM_CALENDAR_DATES
WHERE CALENDAR_CODE = :cal_code1
AND EXCEPTION_SET_ID = :excp_set1
AND CALENDAR_DATE >= TO_DATE(TO_CHAR(:start_date1), 'J')
AND CALENDAR_DATE <=
TO_DATE(TO_CHAR(:start_date2 + 50), 'J')
ORDER BY 2, 1

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 356497 3.51 3.00 6 108 0 0
Execute 356497 89.82 86.44 0 0 0 0
Fetch 356739 22.81 23.73 792 2139782 0 1449784
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1069733 116.14 113.18 798 2139890 0 1449784

 

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