My Oracle Support Banner

R11i/R12: OIE: Transaction Location Does Not Default As Expense Location (Doc ID 1365090.1)

Last updated on JUNE 22, 2018

Applies to:

Oracle Internet Expenses - Version 11.5.10.2 and later
Information in this document applies to any platform.

Goal

With regards to the defaulting of the Location field in both expense and transactions for credit card expenses, what information in the AP_CREDIT_CARD_TRXNS_ALL is matched with the data in the AP_POL_LOCATIONS_VL to default an expense location?

While the CITY_LOCALITY is repeated, the Location Type City is unique. Further, in the credit cards table, the state is 2 character (e.g. GA) but in the AP_POL_LOCATIONS_VL , the state is full blown "Georgia".  Running the statement  SELECT * FROM AP_POL_LOCATIONS_VL WHERE LOCATION = 'Atlanta', the output shows there are 24 records where the location has 'Atlanta'. 

In some cases no Location value defaults at all, as with the above example.  Why?


Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.