MRCNSW Module: Memory-based Snapshot Worker Errors affopen :: File too large APP-MRP-22075 mrsngs_snp_gross_rqmts (Doc ID 1680583.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Materials Requirement Planning - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 version, Materials Requirements Plan In PROD:

When attempting to run DRP plan in regular MRP, it has failed for the last two days in MRCNSW module: Memory-based Snapshot Worker with the following

SELECT mrp_gross_requirements_s.nextval,
  dates.inventory_item_id,
  dates.organization_id,
  dates.inventory_item_id,
  TO_CHAR(DECODE(:include_mds_days, -23453,
  schedule_workdate
,
  greatest(schedule_workdate
,
  TO_DATE(:offset_workday,'J'))), 'J'),
  DECODE(dates.rate_end_date, NULL,
  dates.schedule_quantity,
  dates.repetitive_daily_rate),
  NVL(TO_CHAR(dates.rate_end_date, 'J'), -23453),
  DECODE(dates.rate_end_date, NULL, 1,
  2),
  NVL(dates.repetitive_daily_rate, -23453),
  DECODE(dates.schedule_origination_type,
  1, 8,
  3, 6,
  2, 7,
  8, 7,
  4, 15,
  11, 24,
  7, 8,
  -23453),
  DECODE(dates.schedule_origination_type,
  11,
  source_organization_id, -23453),
  NVL(dates.mps_transaction_id, -1),
  NVL(dates.reservation_id, -23453),
  sched.input_designator_name,
  NVL(dates.project_id, -23453),
  NVL(dates.task_id, -23453),
  NVL(pa.planning_group, '-23453'),
  -23453,
  -23453,
  NVL(dates.end_item_unit_number, '-23453')
FROM pjm_project_parameters pa,
  mrp_system_items sys,
  mrp_schedule_dates dates,
  mrp_plan_schedules_v sched
WHERE sys.inventory_item_id = dates.inventory_item_id
AND sys.organization_id = dates.organization_id
AND sys.compile_designator = sched.compile_designator
AND pa.project_id (+) = dates.project_id
AND pa.organization_id (+) = dates.organization_id
AND dates.supply_demand_type = 1
AND dates.schedule_level = 2
AND DECODE(:include_mds_days, -23453,
  TO_DATE(:offset_workday,'J'),
 NVL(dates.rate_end_date,dates.schedule_date))
  >= TO_DATE(:offset_workday,'J')
AND dates.schedule_date AND dates.organization_id = sched.input_organization_id
AND dates.schedule_designator = sched.input_designator_name
AND sched.input_designator_type = 1
AND sched.organization_id = :org_id
AND sched.compile_designator = :compile_desig

mrldflush : affputs wrote -1 string#45 should be 181
affopen :: File too large
mrldwrt : unable to flush to file 151
APP-MRP-22132: Cannot get profile option MRP_FILES_PATH_ENV_VAR

Cause: The current routine cannot retrieve a value for the specified profile option.

Action: Contact your customer support representative.

APP-MRP-22075: An internal error has occurred (mrsngs_snp_gross_rqmts, 6, , )
@ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
APP-MRP-22075: An internal error has occurred (mrsndi_snp_demand_info, 2, , )
@ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
APP-MRP-22075: An internal error has occurred (mrnspxt, 20, 10008, )
@ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
APP-MRP-22075: An internal error has occurred (mrnspgpt, 14, 202 , 10008, )
@ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
APP-MRP-22075: An internal error has occurred (main, 13, , )
@ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
gthsk1=1
gthsk2=1
gthsk3=1
gthsk4=1
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run MRP plan
2. Fails as noted

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