My Oracle Support Banner

Error When Creating Batch - 'ORA-04063: package body "APPS.INV_MATERIAL_STATUS_GRP" Has Errors' (Doc ID 1461900.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 01-Nov-2013***

Symptoms

On : 12.1.3 version, Batches

After applying patches - Patch 13796455:R12.INV.B and Patch 13539797:R12.INV.B - when attempting to create a Batch, the following error occurs.
There were no errors during patch applications and the correct file versions have been attained after applying these patches -

- Patch 13796455:R12.INV.B > INVMTXFH.pld 120.51.12010000.95
- Patch 13539797:R12.INV.B > INVTXGGB.pls 120.72.12010000.58


ERROR
-----------------------

 ORA-04063: package body "APPS.INV_MATERIAL_STATUS_GRP" has errors.
 ORA-01403: no data found in Package GME_COMMON_PVT.Procedure  get_batch_shortages.


STEPS
-----------------------

The issue can be reproduced at will with the following steps:

1. Production Supervisor > Batches

Attempt to Create a Batch

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.