Unable to Export Addresses from the Resource Addresses And Subinventories Setup Page (Doc ID 2846287.1)

Last updated on FEBRUARY 08, 2022

Applies to:

Symptoms

On : 12.2.6 - 12.2.10 Versions

On the the Resource Addresses and Subinventories HTML page,users are able to successfully export Subinventories but the Addresses export fails with the error:

Error
JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM
( SELECT DISTINCT
    resaddresseo.address_line_1,
    resaddresseo.address_line_2,
    resaddresseo.address_l    ine_3,
    resaddresseo.country,
    resaddresseo.country_name,
    resaddresseo.default_trip _flag,
    resaddresseo.default_trip_modified,
    resaddresseo.hr_loc_id,
    resaddresseo.h            z_loc_id,
    resaddresseo.inactive_flag,
    resaddresseo.inactive_modified,
    resaddresseo.POSTAL_CODE,ResAddressEO.PRIMARY_FLAG,ResAddressEO.PRIMARY_FLAG_MODIFIED,
    ResAddressEO.REGION_1,ResAddressEO.RESOURCE_ID,ResAddressEO.RESOURCE_TYPE,
    ResAddressEO.TIMEZONE_MODIFIED,ResAddressEO.TIME_ZONE,ResAddressEO.TIME_ZONE_NAME,
    ResAddressEO.TOWN_OR_CITY,ResAddressEO.INACTIVE_FLAG AS INACTIVEFLAGPREVIOUSVALUE,
    DECODE(ResAddressEO.INACTIVE_FLAG , 'N' ,'NormalTimezone','ReadOnlyTimezone')
    AS TIMEZONESWITCHER,DECODE(ResAddressEO.INACTIVE_FLAG , 'N' ,'EnablePrimaryFlag','DisablePrimaryFlag')
    AS PRIMARYADDRESSFLAGSWITCHER,DECODE(ResAddressEO.INACTIVE_FLAG , 'N' ,'EnableAddressUpdate','DisableAddressUpdate')
    AS ADDRESSUPDATESWITCHER,DECODE(ResAddressEO.INACTIVE_FLAG , 'N' ,'EnableOperationUnit','DisableOperationUnit')
    AS OPERATINGUNITSWITCHER,DECODE(ResAddressEO.INACTIVE_FLAG , 'N' ,'EnableTripStart','DisableTripStart')
    AS TRIPSTARTSWITCHER FROM CSP_RS_ADDRESS_UI_V ResAddressEO) QRSLT
WHERE
    ( resource_type = :1
      AND resource_id = :2 )

The issue can be reproduced at will with the following steps:
(R) Field Service Dispatcher
(N) Spares Management > Setup > Addresses and Subinventories HTML > Query Technician >Click on Export icon

Error occurs

Changes

Cause

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