FBDI: Getting Error While Trying To Reserve On Hand Against A Sales Order.

(Doc ID 2408281.1)

Last updated on JUNE 09, 2018

Applies to:

Oracle Fusion Inventory Management Cloud Service - Version 11.13.17.11.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to create reservations using FBDI template the following error occurs.

ERROR
FND_AS_UNEXPECTED_ERROR
{PKG_NAME}=INV_RESERVATION_PVT
{PROCEDURE_NAME}=Convert_Quantity
{ERROR_TEXT}=ORA-01403: no data found

FND_AS_UNEXPECTED_ERROR
{PKG_NAME}=INV_RESERVATION_PVT
{PROCEDURE_NAME}=CREATE_RESERVATION
{ERROR_TEXT}=Error while creating reservation :: 1 : User-Defined Exception


The issue can be reproduced at will with the following steps:
1. Create reservations using FBDI template


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