The API GME_API_PUB.INSERT_MATERIAL_LINE Is Failing With "Inv_Transfer_Order_PVT.Trolins: exc error in validate_attributes."
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.
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.
- Run GME_API_PUB.insert_material_line
- You are just trying to add the material lines like the front end form does.
- 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.
- 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms