Procurement - EBS (MOSC)

MOSC Banner

Mismatch SLM UDA and Assessment question response length

edited Dec 19, 2016 12:26PM in Procurement - EBS (MOSC) 3 commentsAnswered

Hi !

We are on 12.1.3 and implemented Supplier Life Cycle Management ( SLM ).

There are UDA's defined as part of supplier registrations. Also we have Pre-Qualification assessment ( previously RFI ).

There is mapping between assessment questionsto UDAs.

The problem is Assessment question length is varchar 4000 but UDA has only Char 150.

Whenever supplier enters more than 150 char value, Supplier registarion fails while copy from assessment to UDA.

1. One way to restrict assessment is to have acceptable assessment values but how can you restrict field like Review ( or comments )

Table for assessment ( PON_BID_ATTRIBUTE_VALUES.value )

Table for SLM UDA ( POS_SUPP_PROF_EXT_B.C_EXT_ATTR4 )

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center