Oracle Forms (MOSC)

MOSC Banner

Using version 11.5.10.2 - the OEXOEORD form is not requerying defaults on descriptive flexfield.

edited Aug 22, 2014 5:00AM in Oracle Forms (MOSC) 1 commentAnswered

We are using a flexfield for Additional Header Information - synchronized to the :SYSTEM.CURRENT_FORM. The values are defaulted from attributes pulled in from a SQL Statement querying the customer - matching the :ORDER.SHIP_TO_LOCATION.

Example: SELECT distinct ra.attribute2 FROM hz_cust_acct_sites_all ra, hz_cust_site_uses_all sua WHERE ra.cust_acct_site_id = sua.cust_acct_site_id and sua.site_use_code = 'SHIP_TO' and sua.location = :ORDER.SHIP_TO_LOCATION

When an order is first entered and the descriptive flexfield is initiated, the query works correctly to populate the attributes in oe_order_headers_all.

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