BR AP: Voucher Online Is Taking Long Time In An Specific SQL (Doc ID 2120574.1)

Last updated on APRIL 17, 2016

Applies to:

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

Symptoms

Voucher Online is taking long time in an specific SQL.

In Voucher Online page the following Select SQL is taking a long time to complete:

SELECT BUSINESS_UNIT, BOL_SEQ_NUM_BRL, REMIT_SETID, REMIT_VENDOR, TO_CHAR(SCHEDULED_PAY_DT,'YYYY-MM-DD'), GROSS_AMT, DISCOUNT_AMT, INTEREST_PAYMENT FROM PS_BOLETO_BRL_VW A WHERE BUSINESS_UNIT='BRA01' ORDER BY BUSINESS_UNIT, BOL_SEQ_NUM_BRL;


STEPS
-----------------------
1. Navigate to Main Menu > Accounts Payable > Vouchers > Add/Update > Regular Entry.
2. Select Add New Value.
3. Go to Payments page.
4. Select Payment Method as EFT, Payment Modality as Title.  The field Bol. Num. will then be available for Edit.
5. Click on the Bol. Num. prompt.  The prompt takes time to show the data.



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