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

Last updated on OCTOBER 28, 2016

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 :

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.



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