The API GME_API_PUB.INSERT_MATERIAL_LINE Is Failing With "Inv_Transfer_Order_PVT.Trolins: exc error in validate_attributes." (Doc ID 1534459.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

When attempting to use the API GME_API_PUB.INSERT_MATERIAL_LINE, there is an intermittent error which causes the API to fail randomly as can be seen in the logfile as follows:

Error
Inv_Transfer_Order_PVT.Trolins: exc error in validate_attributes.

Steps

  1. Run GME_API_PUB.insert_material_line
  2. You are just trying to add the material lines like the front end form does.
  3. You are not dealing with Move Orders. Move Order API is being called internally when you call GME_API_PUB.INSERT_MATERIAL_LINE. So, you do not have control over what is being passed to the Move order API. If this INV_Transfer_Order_PVT.Unique_Order(p_organization_id,p_request_number) call has to be done, then it has to be incorporated in GME APIs where this call is being made.
  4. You only use these for 2 organizations at the moment. You have found that ABC (organization code) passes successfully and CDE (organization_code) consistently fails.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms