Sources
Sources of Values ‘Sources’ are places where values can be
defaulted from. Defaulting Rules provide a variety of sources that you can use
in building your defaults. Most of them will be familiar to users of Oracle
Order Entry.
• Constant Value - is simply a text string that will be
used
.
.
• Profile Option - is the value of a profile option. This
can be a system provided profile option, or a new profile option that you’ve
defined just to provide a defaulting value.
• Same Record - is
the value of another attribute on the same entity (or record) as the attribute
you are defining the rule for. For example, you might set up the Promise Date
to default from the Request Date on the same line.
• Related Record - is the value of another attribute on a related entity (or record). For example, you might set up the Ship Method on the line to default from the Ship Method on the header. Or some attribute on the order header might default from an attribute on the related customer record.
• Related Record - is the value of another attribute on a related entity (or record). For example, you might set up the Ship Method on the line to default from the Ship Method on the header. Or some attribute on the order header might default from an attribute on the related customer record.
• System Variable - is the value of a system (server)
variable, such as System Date. For this type of source (and this type only),
you can use an expression containing a formula, for example, sysdate + 7. •
PL/SQL API - is where you provide your own routine to
provide the default. There are a few seeded defaulting rules that use this -
for example, defaulting of the currency on the order header from the set of
books (SOB) is seeded this way. . You can look at this attribute for an example
of how to specify a PL/SQL API or you can look in the ‘Rule Based Defaulting
Framework’ HLD for technical details. • others - there are several esoteric
source types relating to the Web App Dictionary definitions for this attribute.
Most people won’t want to use these. They are documented in the ‘Rule Based
Defaulting Framework’ HLD, if you really want to know
