My Oracle Support Banner

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 FEBRUARY 14, 2019

Applies to:

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


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:

Inv_Transfer_Order_PVT.Trolins: exc error in validate_attributes.


  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.


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.