BR AP: Voucher Online Is Taking Long Time In An Specific SQL
Last updated on JANUARY 12, 2018
Applies to:PeopleSoft Enterprise FIN Payables - Version 9.1 and later
Information in this document applies to any platform.
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;
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.
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