Invalid Package Body MSD_DEM_UPLOAD_FORECAST After VCP 12.1.3.7 PATCH With 10g Database (Doc ID 1478866.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 to 7.3.1 [Release 7.3.0]
Information in this document applies to any platform.

Symptoms

On : 7.3.0 version, DM-Gen

When attempting to Package body MSD_DEM_UPLOAD_FORECAST is invalid after application of patch 13833266:R12.SCP_PF.B (VCP 12.1.3.7) ,
the following error occurs.

ERROR
-----------------------
3005/25 PL/SQL: Statement ignored
3005/25 PLS-00435: DML statement without BULK In-BIND cannot be used
  inside FORALL

3006/31 PLS-00436: implementation restriction: cannot reference fields
  of BULK In-BIND table of records

3010/25 PL/SQL: Statement ignored
3010/25 PLS-00435: DML statement without BULK In-BIND cannot be used
  inside FORALL



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Apply patch 13833266:R12.SCP_PF.B (VCP 12.1.3.7)

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