No Values in Rule Name LOV When Using Natural Account Segment for ADR

(Doc ID 1290784.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Goal

When trying to add an Account Derivation Rule to a Journal Line Type using Natural Account Segment as the Segment, the Rule Name LOV does not contain any values.

Oracle has seeded values using this setup, but those do not show up in the LOV either.

### Steps to Reproduce ###

Setup > Subledger Accounting Setup > Accounting Methods Builder > Methods and Definitions > Journal Line Definitions > Create Journal Line Definition > Assign Account Derivation Rule using Natural Account Segment as the Segment > Rule Name field LOV contains no entries


Sample duplication steps:

1. Login to Purchasing,Vision University responsibility
2. Navigate to Set up > Financials > Subledger Accounting setups > Accounting Methods Builder > Journal Entry setups > Account Derivation Rules
3. Create an user defined ADR MVR_FEDERAL for which the output type is "Value set" and choose some constant value.
4. Create an user defined JLD copied from seeded Federal Requsition related JLD and try to attach this user defined ADR for the JLT

But the LOC does not show the ADR defined with the output type as Value set.

If the ADR is defined with the output type as segment, it is available in the LOV in JLD form.


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms