Last updated on SEPTEMBER 20, 2017
Applies to:Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
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 we cannot allocate the material.It seem to be because of a Credit Check hold problem.
You found the following error in the pick release log:
"Credit Checking package API error".
In the pick release log, we found the following 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.
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./
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms