1. Create a new lookup in Oracle Payables
a. Navigate: Setup -> Lookups -> Payables
b. For the new lookup, enter all the possible values which are provided by the credit card company in the data feed for a particular Transaction Code, such as MIC (Major Industry Codes) or SIC (Sub Industry Codes).
select * from AP_LOOKUP_CODES where lookup_type like '%VISA TRANSACTION CODES%'
2. Create additional Card Expense Types (optional)
a. Navigate: Setup -> Lookups -> Payables
b. Query up the CARD_EXPENSE_TYPE lookup.
c. If additional card expense types are needed, then they can be added on this form.
select * from AP_LOOKUP_CODES where lookup_type like 'CARD_EXPENSE_TYPE'
3. Define a mapping rule
a. Navigate: Internet Expenses Setup and Administration -> Expenses Setup -> Credit Cards -> Card Programs
b. Choose 'Create Mapping Rules' button.
c. Enter any name for your Mapping Rule and provide a meaning and description. In the Lookup Type field, select the new lookup type created in step #1. Choose Continue.
c. Choose the Default Card Expense Type for the mapping rule. Any lookup codes that are not defined or do not assign to an expense type will be mapped to this card expense type. Define the mappings for this mapping rule by choosing which source lookup code to associate with which card expense type.
d. Choose the Finish button when complete.
SELECT
B.MAP_TYPE_CODE "Mapping Rule",
C.FROM_LOOKUP_CODE "Source Lookup Code",
D.DISPLAYED_FIELD "Source Meaning",
C.TO_LOOKUP_CODE "Card Expense Type",
E.DISPLAYED_FIELD "Card Expense Type Meaning"
FROM AP_MAP_TYPES_TL T,
AP_MAP_TYPES_B B,
AP_MAP_CODES C,
AP_LOOKUP_CODES D,
AP_LOOKUP_CODES E
WHERE B.MAP_TYPE_CODE = T.MAP_TYPE_CODE
AND T.LANGUAGE = userenv('LANG')
AND B.MAP_TYPE_CODE=<<Mapping CCode>>
AND B.MAP_TYPE_CODE = C.MAP_TYPE_CODE
AND D.LOOKUP_TYPE = B.FROM_LOOKUP_TYPE
AND E.LOOKUP_TYPE= B.TO_LOOKUP_TYPE
AND D.LOOKUP_CODE= C.FROM_LOOKUP_CODE
AND E.LOOKUP_CODE= C.TO_LOOKUP_CODE
4. Assign Card Expense Types to Expense Items.
a. Navigate: Setup -> Invoice -> Expense Report Templates
b. Query the Expense Report Template which employees use to enter their credit card transactions.
c. Choose the ‘Assign Card Expense Types’ button.
d. Assign the appropriate Expense Items to the exisiting Card Expense Types.
Also enter a Default Expense Item for unassigned card expense types. Internet Expenses assigns all card expense types not specifically assigned to an expense item to this expense item. During expenses entry, the Expense Items are displayed to the end user as the default expense types.
e. Choose Ok when done.
5. Select the Source Column and Mapping Rule for the Card Program
a. Navigate: Setup -> Credit Cards -> Card Programs
b. Query or enter the Card Program which will be used during the load and validation process.
c. The Source Column list of values contains all the columns from the AP_CREDIT_CARD_TRXNS_ALL table. Select the column which contains the lookup values defined in step #1.
d. Select the mapping rule you defined in step #3.
6. Use one of the following concurrent requests to load and validate the credit card transactions:
American Express Transaction Loader and Validation Program
Diner's Club Transaction Loader and Validation Program
MasterCard CDF Transaction Loader and Validation Program
MasterCard CDF3 Transaction Loader and Validation Program
US Bank Visa Transaction Loader and Validation Program
SELECT * FROM ap_credit_card_trxns_all A,
AP_CC_TRX_DETAILS b
WHERE a.card_program_id =<<card program id>>
AND a.trx_id =b.trx_id
7. Enter an expense report
a. Navigate: Internet Expenses -> Expenses Home -> Create Expense Report
b. On the General Information page, select the same Expense Report Template from step #4 above.
c. Choose Next
d. Select the credit card transactions which were imported from step #6 above and choose Next.
e. On the Verify and Complete Credit Card Expenses page, the expense type automatically defaults into the expense report. Choose Next.
f. Enter any Cash and Other Business Expenses.
g. Submit the expense report.
No comments:
Post a Comment