Receipts Workbench: Error Encountered When Click Apply Button in Receipt Form - The Query Must Return One Row and One Column
Last updated on SEPTEMBER 03, 2013
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
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