PO 9.1 Brazilian Localization: Delivered SQLExec at PeopleCode CUST_ADDR_SEQ.ADDRESS_SEQ_NUM.SavePreChange Taking Long Time To Execute
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.
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);
1. Navigate to Main Menu > Customers > Customer > Information > General Information
2. Add a new customer.
3. Save the component
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