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

Last updated on MARCH 08, 2017

Applies to:

Oracle Complex Maintenance, Repair & Overhaul - Version 12.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 05-Sep-2012***
***Checked for relevance on 15-Sep-2014***

Symptoms

'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'.


Error:
"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.

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