EeS: Performance issue when searching for an existing Buyer from Review Buyer Details page (Doc ID 1151643.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN eSettlements - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

When we select "buyer" (existing buyers) on EM_BUYER_INQRY page, it takes 10 to 15 minutes to load EM_BUY_REG page. Our location table has over 47K rows. The default location is the only one selected. It takes more time to execute the below SQL stmt.
SELECT SETID, LOCATION, EFFDT, TO_CHAR(EFFDT,'YYYY-MM-DD'), EFF_STATUS, DESCR, DESCR_AC, DESCRSHORT, BUILDING, FLOOR, SECTOR, JURISDICTION, ATTN_TO, COUNTRY, ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY, NUM1, NUM2, HOUSE_TYPE, ADDR_FIELD1, ADDR_FIELD2, ADDR_FIELD3, COUNTY, STATE, POSTAL, GEO_CODE, IN_CITY_LIMIT, COUNTRY_CODE, PHONE, EXTENSION, FAX, SETID_SALARY, SAL_ADMIN_PLAN, LANG_CD, HOLIDAY_SCHEDULE, ESTABID, LOCALITY, CAN_CMA, CAN_OEE_AREACD, GEOLOC_CODE, OFFICE_TYPE, NCR_SW_CAN, TBS_OFFICE_CD_CAN, WRKS_CNCL_ID_LCL, SPK_COMM_ID_GER, TARIFF_AREA_GER, TARIFF_GER, INDUST_INSP_ID_GER, NI_REPORT_SW_UK, GVT_GEOLOC_CD, GVT_DESIG_AGENT, SOC_SEC_WRK_CTR, MATRICULA_NBR, LABEL_FORMAT_ID2, LABEL_FORMAT_ID3, USG_LBL_FORMAT_ID, COMMENTS_2000, REG_REGION FROM PS_LOCATION_TBL WHERE SETID=:1 ORDER BY SETID, LOCATION, EFFDT DESC

Cause

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