PO 9.1 Brazilian Localization: Delivered SQLExec at PeopleCode CUST_ADDR_SEQ.ADDRESS_SEQ_NUM.SavePreChange Taking Long Time To Execute

(Doc ID 2328304.1)

Last updated on NOVEMBER 14, 2017

Applies to:

PeopleSoft Enterprise FIN Purchasing Brazil - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Delivered SQLExec command in Brazil localization taking long time to execute.
CUST_ADDR_SEQ.ADDRESS_SEQ_NUM.SavePreChange (Pecord People Code)

The following SQL in this peoplecode is causing some performance issue due to the cartesian output.

  /* Procurando títulos com o endereço que está sendo alterado. */
  SQLExec("select Count(*) from PS_ITEM A, PS_CUSTOMER B where B.SETID = :1 and B.SETID = (select C.SETID from PS_SET_CNTRL_GROUP C where C.SETCNTRLVALUE = A.BUSINESS_UNIT and C.REC_GROUP_ID = (select D.REC_GROUP_ID from PS_REC_GROUP_REC D where D.RECNAME = 'CUSTOMER')) and A.CUST_ID = :2 and A.ADDRESS_SEQ_NUM = :3", CUST_ADDR_SEQ.SETID, CUST_ADDR_SEQ.CUST_ID, CUST_ADDR_SEQ.ADDRESS_SEQ_NUM, &ITEM_COUNT);
 

Replication Steps:
1. Navigate to Main Menu > Customers > Customer > Information > General Information
2. Add a new customer.
3. Save the component




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