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!