My Oracle Support Banner

Getting "Invalid arguments to procedure AHL_RM_MATERIAL_AS_PVT.PROCESS_MATERIAL_REQ" Error when Attempting to Add Route Effectivity Using AHL_RM_ROUTE_PUB API (Doc ID 1273040.1)

Last updated on MARCH 26, 2019

Applies to:

Oracle Complex Maintenance, Repair, & Overhaul - Version 12.1.2 and later
Information in this document applies to any platform.


When attempting to use AHL_RM_ROUTE_PUB API to add a Route Effectivity, the following error occurs:

Invalid arguments to procedure AHL_RM_MATERIAL_AS_PVT.PROCESS_MATERIAL_REQ.

The issue can be reproduced at will with the following steps:
1. Create a script to add a route effectivity to a Route in Draft Status.
2. Pass one record to AHL_RM_MATERIAL_AS_PVT.route_efct_rec_type and no records to AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type.
3. The script fails with the following error:
Invalid arguments to procedure AHL_RM_MATERIAL_AS_PVT.PROCESS_MATERIAL_REQ.
4. The AHL Debug Log is telling that "Private API raised expected error...".


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.