My Oracle Support Banner

R12: OIE: OIE Expense Location Field LOV Showing All Locations Not Just Those Enabled for VAT Tax After Applying RPC4 (Doc ID 2197025.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.
Expense Location Field LOV
All Locations
RPC4 patchset
Merchant Field


After applying RPC4 patches the functionality of the LOV changed for Location when entering Tax Merchant fields for VAT tax related expenses.

Prior to patching the LOV for Location showed just those locations enabled for merchant tax fields.
After patching the Expense locations now show all locations instead of just those enabled for merchant tax fields.

NOTE: To be confirmed which were applied:

, '14098047','R12.1.3 OIE-RPC Aug 2012'
, '13563489','R12.1.3 PCARD-RPC Jan 2012'
, '16234880','R12.1.3 OIE-RPC Mar 2013'
, '16213660','R12.1.3 PCARD-RPC Mar 2013'
, '17176060','R12.1.3 PCARD-RPC Sep 2013'
, '19163626','R12.1.3 OIE-RPC Aug 2014'
, '19018819','R12.1.3 PCARD-RPC Aug 2014'
, '20315551','R12.1.3 OIE-RPC Feb 2015'
, '20178726','R12.1.3 PCARD-RPC Feb 2015'
, '22526147','R12.1.3 OIE-RPC Feb 2016'

This contradicts the intended behavior of the LOV, which is (per both the Implementation Guide and unpublished through Bug 10329388 : THE LOCATIONS ARE NOT SHOWING UP IF TAX LOCATIOIN IS NOT DEFINED FOR THE COUNTRY) as follows:

Generally a location is assigned to a policy schedule and the user can select
the location in the details page when the user selects the expense type that
has the policy schedule attached.

Text from implementation guide:
Details pages
If there is no schedule assigned, or if the assigned schedule is not
location-based, then these pages display location fields for text entry only.
If the assigned schedule is location-based, or if you have merchant fields
enabled, then Internet Expenses displays location fields with a list of values."

Expect the LOV for Location to behave in the same manner that it did before patching.

The issue can be reproduced at will with the following steps:
1. Have locations enabled but *NO* schedule defined for Policy
2. Have an expense type defined that has VAT merchant tax fields enabled including Location, again with no Policy/schedule defined
3. Enter an expense report and see that the LOV for Location only displayed VAT enabled locations.
4. Apply patch(es) XX
5. Retest the issue and see that the LOV now contains all locations not just VAT enabled locations.
6. Review the file versions and code, see the following changes were made:

Before RPC4 Patch: 120.9.12010000.10 120.1

After RPC4 Patch: 120.9.12010000.11 120.1

The following SQL in the view has changed:
  FROM ap_web_vat_setup vat_setup
  WHERE vat_setup.enabled_code = 'Y'
  ) ) )

The prior view had this sql where it also joined the territory code:

 SELECT locations.location location,
  locations.location_id location_id,
  locations.description description,
  territories.territory_short_name country
  FROM fnd_territories_vl territories,
  ap_pol_locations_vl locations,
  ap_web_vat_setup vat_setup
  WHERE 'Y' = :6
  AND vat_setup.territory_code = locations.territory_code
  AND vat_setup.enabled_code = 'Y'
  AND locations.territory_code = territories.territory_code
  AND locations.status = 'ACTIVE'
  AND TRUNC(sysdate) <= TRUNC(NVL(locations.end_date + :7, sysdate))
  AND locations.location_type




To view full details, 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 a vibrant support community of peers and Oracle experts.