Order Management - EBS (MOSC)

MOSC Banner

Default DFF line segment depending order header value

edited Jul 15, 2015 10:01AM in Order Management - EBS (MOSC) 2 commentsAnswered

How can I create a SQL for Default order line DFF segment depending on order header value?

I use the SQL below but got error message

select xx.sales_department

  from oe_order_headers_all     oh,

       oe_order_lines_all       ol,

      xx_so_departments sd

where sd.header_id = oh.header_id and

          ol.header_id = oh.header_id and

          ol.line_id = :$FLEX$.line_id

Error message:

APP-FND-00784: Invalid reference line_id in default value defined for segment sales_department

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