My Oracle Support Banner

Credit Check Hold at Pick Release Is Automatically Applied (Doc ID 2213819.1)

Last updated on FEBRUARY 12, 2019

Applies to:

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

Symptoms

When doing pick release on some orders, the released order is automatically placed on hold even if the hold was previously removed by the user.

The pick release re-apply the hold over and over so cannot allocate the material.  
The following error is seen in the pick release log:

ERROR

"Credit Checking package API error".
(in French)  PL/SQL : erreur numérique ou erreur sur une valeur: tampon de chaîne de caractères trop petit"


STEPS TO REPRODUCE

1. Using FRC 'Order Management Responsibility'
2. Pick Release an order where the credit check hold was removed
3. Order goes back on Credit Check hold and results in error above.

Changes

 The issue reappears when upgrading from 12.1 to 12.2 as well.  The 12.1 instance had the patch applied, but had to reapply the patch for 12.2 version.

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.