Procurement - EBS (MOSC)

MOSC Banner

Auto-Populate a DFF in Requisition Line from Requisition Header DFF

For a Requisition, Header DFF is selected from a ValueSet defined, assume (Yes/No), the same selected value in the Header should be reflected in 'All the Line level DFFs'. And also, there should be a convenience to edit the individual Line's DFF using the same ValueSet.

  1. I tried creating a new ValueSet using Table - SQL like Query. Multiple values are populated. Help me tweak the Valueset here.

2. I tried implementing an Initial Default value with SQL in the Requisition Line Level DFF and retaining the same Old Valueset (Yes/No) under the Validation.
Query Used: SELECT POR_REQUISITION_HEADERS_ALL.Attribute1 FROM POR_REQUISITION_HEADERS_ALL, por_requisition_lines_all WHERE POR_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID = por_requisition_lines_all.REQUISITION_HEADER_ID.

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