Error Creating Custom LOV on Specification Template: FRM-41072: Cannot Create Group CUST_SPECIFICATION_CATEGORY_MODE

(Doc ID 1575810.1)

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Utilities Work and Asset Management - Version 1.9.0 and later
Information in this document applies to any platform.

Symptoms



The following error message is received when creating a Custom LOV for the SPECIFICATION_CATEGORY field on the Specification Template Selection Screen:

ERROR
-----------------------
FRM-41072: Can not create group CUST_SPECIFICATION_CATEGORY_MODE


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create the following Special LOV for the SPECIFICATION_CATEGORY field on the Specification Template (SPECTMPL) Selection Screen in Modules Administration->Forms:

LOV: SPECIFICATION_CATEGORY
GROUP: SPECIFICATION_CATEGORY_MODE
RECORD GROUP: SPECIFICATION_CATEGORY_MODE

2. Use the baseline query for the field:

select code, code_desc description
from sa_authority
where table_no in ( select link_val from sa_authority where table_no = 37 and code like nvl(:selection.specification_type,'%') and plant = :global.plant)
and plant = :global.plant
order by code


3. Open the Specification Template module - error is displayed


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