My Oracle Support Banner

Move Order Fails With Error "The Material Sourcing Process Failed To Create Picking Suggestions" When Transacting (ORA-01422 Seen In Log File) (Doc ID 2933288.1)

Last updated on MARCH 07, 2023

Applies to:

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

Symptoms

In a Project Manufacturing environment, when trying to allocate a move order, the following errors are occurring:

Error: The material sourcing process failed to create picking suggestions for line &LINE_NUM of move order number &MO_NUMBER.

Error: The requested quantity could not be fulfilled by the location detailing process.z
Action: Make sure there is onhand quantity for item before attempting to detailed these items."

 
Steps

  1. Navigate: Inventory > Move Orders > Transact Move Orders.
  2. Query for a move order.
  3. Check the checkbox next to a line you want to transact and click the Transact button.

In addition, following message is seen in the debug log file:

APP-FND-01564: ORACLE error 1422 in FDFGCD
Cause FDFGCD faile due to ORA-01422 exact fetch returns more than requested number of rows.

The SQL statement being executed at the time of the error was:
SELECT ENABLED_FLAG, SUMMARY_FLAG,
NVL(TO_CHAR(START_DATE_ACTIVE,'J'),
NVL(TO_CHAR(END_DATE_ACTIVE, 'J'),0),SEGMENT1,SEGMENT2,
SEGMENT19,INVENTORY_LOCATION_ID FROM MTL_ITEM_LOCATIONS
WHERE ORGANIZATION_ID = :num AND SEGMENT1 = :SEGMENT1
AND SEGMENT2 = :SEGMENT2 AND SEGMENT19 = SEGMENT19
and was executed from the file 7ERRFILE.

 

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