My Oracle Support Banner

Error: 'Document Sub Type is invalid.' When Calling Procedure AHL_DI_DOC_INDEX_PUB.CREATE_DOCUMENT() (Doc ID 1078017.1)

Last updated on MARCH 27, 2019

Applies to:

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


'Document Sub Type is invalid' error is raised when calling AHL_DI_DOC_INDEX_PUB.CREATE_DOCUMENT() procedure to create a document in Document Index module.

There is call of procedure Check_lookup_name_Or_Id with parameter p_lookup_type => 'AHL_DOC_SUB_TYPE_CODE' meanwhile there is no lookup type, correct type is 'AHL_DOC_SUB_TYPE'.

"Document Sub Type is invalid."


Steps To Reproduce:
1) Create PL/SQL procedure with a call to AHL_DI_DOC_INDEX_PUB.CREATE_DOCUMENT.
2) Execute it with correct document sub type in v_doc_tbl.Doc_sub_type_desc parameter.
3) Will get error 'Document Sub Type is invalid'.

'Document Sub Type is invalid' error is got when calling AHL_DI_DOC_INDEX_PUB.CREATE_DOCUMENT procedure to create document in DI.




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.