My Oracle Support Banner

Receipts Workbench: Error Encountered When Click Apply Button in Receipt Form - The Query Must Return One Row and One Column (Doc ID 1572937.1)

Last updated on AUGUST 07, 2020

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.


Attempting to click on the Apply button in the Receipts Workbench and receive the following error:

The query must return one row and one column
(STRING==select to_char(zlv.tax_amt) from ZX_LINES_V zlv
where zlv.trx_number = : APP_FOLDER. TRX_NUMBER
and zlv. application_id = 222
and zlv. entuty_code = 'TRANSACTIONS'
and zlv. event_class_code = 'INVOICE'
and zlv. internal_orgnization_id = fnd_global. org_id


To view full details, 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 a vibrant support community of peers and Oracle experts.