My Oracle Support Banner

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

Last updated on FEBRUARY 05, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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