My Oracle Support Banner

Error When Viewing Attribute Values Based On MFG_ORGANIZATION_ID (Doc ID 1587090.1)

Last updated on FEBRUARY 07, 2021

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

Error received on Asset Attributes Page while viewing Attribute Values based on :$PROFILES$.MFG_ORGANIZATION_ID :

NOTE: In the <images or examples> <above or below> and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

 

ERROR

”ID PCP1 VLV 01 for the flexfield segment LOOP COMPONENT 1 does not exist in the value set CST_SRS_ASSET_NUMBER.”

(PCP1 VLV 01 is the attribute value)

EXPECTED BEHAVIOR

Expect that the :$PROFILES$.MFG_ORGANIZATION_ID is supported.


STEPS

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

1. Navigation : Define Asset Attributes DFF using a value set with table validation :

The SQL in the table validation includes check for $PROFILES$.MFG_ORGANIZATION_ID

2. When trying to view the asset attributes from the Asset Number form ,get the error above.



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.