EBS Customizations (MOSC)

MOSC Banner

How to set initial default value from SQL query in a context segment

Hello, Im triying to set a default value inside a descriptive flexfield inside a context sentitive segment.

The flexfield is inside the shipment line module, as we are triying to access the attribute_char1 of the transferOrderLine that precede the shipment line.


We did set the value-set for the field, succesfully, as a simple select from PJF_PROJECTS_ALL_B project that are active at the moment of the shipment.


The problem comes with the default value, the default value we are trying to set is the ATTRIBUTE_CHAR1 of the transfer order lines that precede the shipment, our first attempt was to do a SQL Query as follows:

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