Define Mapping Sets

Mapping set is used to deliver an output value to be used in SLA based on an input value passed to it. Mapping sets are referenced in the Account Derivation Rules (ADR) for specific accounting events in Oracle eBS, for example: Invoice Entered, Invoice Reversed, Invoice Paid, Invoice Cancelled etc. A mapping set outputs a value, a segment value or even a complete accounting code combination.

In order to prevent data entry errors, define value sets and lookup types when entering input values before setting up mapping sets. If neither a value set nor a lookup type is selected, users can enter any value in the Input Value field.

Defining a New Mapping Set

Navigation 

SLA Super User > Subledger Accounting Setups > Accounting Methods Builder > Journal Entry Setups > Mapping Sets

Window Fields

• 
  
• Enabled: If selected, makes the mapping set available for use

• Type Region 

Based on this selection, the mapping set is defined for the setup of the entire Accounting Flexfield, an individual segment in the flexfield, or a value set. 

• The Flexfield and Segment options are disabled if the accounting chart of accounts is not specified. The Value Set option is disabled if the accounting chart of accounts is specified.

• Segment: If selected, enter the segment to be used to assign a value the mapping set.

• Value Set: If selected, select the value set.

• Value Type: If the Value Type is Input, then enter an input value. If Input is selected and a value set or lookup type is defined, then the list of values includes all the allowable values defined for the lookup type or value set. Use the value type Default in cases where the source value from the transaction is not equal to any of the input values in the mapping set. If a mapping set is used and the Subledger Accounting program encounters accounting definitions with undefined input values, journal entries cannot be successfully generated unless there is a default. Using the example introduced earlier in this section, if there is a source value equal to Northwest, it would not map to any of the input values. Specify a default value of 04 for any regions not included as input values. This prevents entries from failing validation when the Subledger Accounting program is submitted.

• Input Value: If the value type Input is selected, enter an input value to be mapped to a corresponding output value.

• Output Value: For a given input value, enter the corresponding output value. The account derivation rule uses this value to populate either the accounting flexfield or accounting flexfield segment.

• If the Value Set option in the Type region is selected, the output value is an individual value from the value set entered in the Value Set field of the Type region, and the list of values includes all values from this value set.

• In the case where a mapping set is defined to populate an individual segment value, the output value is an individual segment value and the list of values includes all values for the segment entered in the Segment field.

• If the Accounting Flexfield option in the Type region of the Mapping Sets window is selected, then the output value is the entire Accounting Flexfield and the list of values includes all enabled combinations for the accounting chart of accounts.

• Start Date and End Date: Effective range dates for the mapping set

• Enabled: If selected, makes the mapping set values available for use.