My Oracle Support Banner

Unable To Update An Existing Order In The Entered Status With Process Order API Due To Errors: L_MSG_DATA=Cannot get valid ID for - order_type_id and L_MSG_DATA=Cannot get valid ID for - line_type_id (Doc ID 2987105.1)

Last updated on JANUARY 17, 2024

Applies to:

Oracle Order Management - Version 12.2 and later
Information in this document applies to any platform.


When attempting to process a 1000+ order lines via 3rd Party Salesforce the users
are running the Process Order API in batch mode. While using UPDATE operation
to add additional line item but it fails with the following.

Observation: When trying to UPDATE using the header id we are seeing that it fails
with the following (below)  When mapping for Inventory_Id to Operating_Id the
Ship From Org Id is always 81 and when the Org Id is 81 and Ship From Org Id is 81
then the update works.  However, when the ShipFromOrgId is 81 and the
OperatingUnitOrg_Id is not 81 update fails but create works.

L_MSG_DATA=Cannot get valid ID for - order_type_id
L_MSG_DATA=Cannot get valid ID for - line_type_id

The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User
2. Import Data from 3rd Party Salesforce into OM Process Order API
3. Observe: This is a large order with 1000+ order lines.
4. Issue is occurring with UPDATE Operation adding line item and additional lines items.

Users are not calling the process order PL/SQL in a wrapper call. They are calling it directly as a REST API.



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.