Please provide the output of HTMOMSE Sales Order Diagnostic Script of the problematic order.
You could refer to Note 133464.1--HTMOMSE Sales Order Diagnostic Script.
1). Download the sql file containing the script.
There are two versions of this script:
HTMomse11i.sql for Release 11i.
HTMomse12.sql for Release 12.
2). Run the script from SQL*Plus connected as APPS user as follows:
If your environment is R11i:
sqlplus apps/apps @HTMomse11i.sql
If your environment is R12:
sqlplus apps/apps @HTMomse12.sql
3). The output file will be located on the DB Server in the 'utl_file_dir' directory.
Please do not rename this output file when uploading to My Oracle Support.
Hi bishnul and coco,
Thanks for your reply. Bishnul's question was right. The line workflow I used when I encountered the error was Line Flow Generic, Bill Only with Inventory Interface. When I changed the line flow to Line Flow - Return for Credit with Receipt, it all worked well. The first workflow is trying to consume the inventory, that is why it is asking for its reservation.