My Oracle Support Banner

Fusion INV : Error In Inventory Lot Reservation Against A Sales Order Using FBDI (Doc ID 2450619.1)

Last updated on SEPTEMBER 24, 2018

Applies to:

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

Symptoms

Error received while trying to create reservations for Sales Orders against On Hand via FBDI. The same reservation creation works successfully via UI.

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

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Tools -->
2. Scheduled Processes -->
3. Run the process "Load Interface File for Import"
4. Use the attached zip file InvReservationsInterface.zip for data file and the Import program : Manage Reservation Interface
5. Then, from the same navigation, run the program "Manage Reservation Interface".
6. This program will end with error and you can view the log file.


Changes

 

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.