Error "An invalid bind variable number was specified Stored Stmt : INPGREPL_S_VNDRPR" when Running the Par Location Replenishment (INPGCDMD) Process for Non-Stock Items (Doc ID 2942626.1)

Last updated on APRIL 20, 2023

Applies to:

Symptoms

Getting an error when trying to Create Replenishment Requests for Non-Stock Items.

The issue can be reproduced at will with the following steps:
       1. Navigate : Inventory > Replenish Par Locations > Define Par Location
               Add PO Business Unit, Ship To Location and Requester
               Enter Item Id 10005 and select Par Replenishment Option as “Non Stock”
               Enter Optimal Qty
               Save
      2. Navigate : Inventory > Replenish Par Locations > Count Par Location Levels
               Search Par Location ID
               Save
      3. Navigate : Inventory > Replenish Par Locations > Create Par Replen Requests
               Enter Par Location Unit
               Run INPGCDMD Process
               Issue : Process failed with an error

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.