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

Last updated on JUNE 26, 2017

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

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