Oracle® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle's Supply Chain Analytics family of products > Process of Configuring Supply Chain Analytics for a Universal Source >

Configuring Expense Payment Types


This task is a step in the Process of Configuring Supply Chain Analytics for a Universal Source.

The Oracle Business Analytics Warehouse supports analysis on three types of payment—Reimbursable Expense (type E), expenses prepaid by your company (type P), and cash advance (type C). All of your organization's payment types must be mapped to one of these types described earlier; do this by modifying MPLT_SAF_EXPENSES.

To configure additional payment types

  1. In PowerCenter Designer, open the SDE_Universal_ExpenseFact mapping.
  2. Open the MPLT_SAF_EXPENSES Source Adapter mapplet.
  3. Select the Expression transformation to open the Edit Transformations box, and select the Port tab to display the EXPENSE_PAY_TYPE_ID port.
  4. Copy and paste this port, rename it EXPENSE_PAY_TYPE_ID.
  5. Select O to make your new port an output port.
  6. Add a decode logic in the expression to decode source-supplied values to the Oracle Business Analytics Warehouse payment type of your choice.
  7. Validate your mapping, and save your changes to the repository.
Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.