My Oracle Support Banner

Create Internal Sales Order nulls out Project Information for Expense Destination (Doc ID 402943.1)

Last updated on MARCH 02, 2023

Applies to:

Oracle Purchasing - Version 11.0.3 to 12.2.3 [Release 11 to 12.2]
Information in this document applies to any platform.


Find the Import Orders Program is not Importing the Sales Order when the destination type is expense.

Users expect to be able to the Import the Internal Requisition successfully.

Steps to Reproduce

The issue can be reproduced at will with the following steps:

1. PO Responsibility-> Requisition->Requisitions
2. Enter requisition number, Type = Internal Requisition, enter item number, quantity, need by date ;Change Destination
3. Type to Expense; Enter Org; Enter Location: Enter Sub inventory
4. Press Distribution button and change to Project; enter project information; Save and check that the account number was generated; Approve requisition. Verify requisition was approved by going into Requisition Summary.
5. Reports->Run->Create Internal Orders->Submit
6. OM Responsibility->Orders,Returns->Import Orders
7. Enter Order Source of Internal Requisition->Submit

The Import orders fails with the following error messages

Debug Level: 0
Request Id: 3560556
Org Id: 101

No orders to process
Not spawning any child processes
End of Order Import Concurrent Program

The create internal sales order shows the following error

Start of log messages from FND_FILE
Begin create internal sales order
Updating Req Headers
1 Reqs selected for processing
Top of Fetch Loop
Source Operating Unit: 101
Selecting Currency Code
Currency Code : USD
Selecting Order Type
Order Type ID:1001
Selecting Price List from Order Type
Header not Inserted : 394235
Destination type is not Inventory - nulling out the project and task.
Top of Fetch Loop
Updating TRANSFERRED_TO_OE_FLAG of 1 Requisitions
End Create Internal Sales Order


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.