My Oracle Support Banner

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

Last updated on MARCH 30, 2019

Applies to:

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


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


{ERROR_TEXT}=ORA-01403: no data found

{ERROR_TEXT}=Error while creating reservation :: 1 : User-Defined Exception

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 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.


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

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