Home > database >  Oracle report missing field name
Oracle report missing field name

Time:02-20

The UPDATE fr_report_task
The SET task_name=
CASE

The WHEN task_id='05691 e5afa1e405d97eded85ef5ef3e8'
AND fiscal=2021
AND task_code='2020'
='101' AND agy_code THEN
Final accounts statements task_name='2020 departments'
The WHEN task_id='6 bf2655f0a5e49bd9abe9bd18bf14f7e'
AND fiscal=2021
AND task_code='2019'
='101' AND agy_code THEN
Final accounts statements task_name='2019 departments - third edition (standard)'
The WHEN task_id='9 b834976585a49cdb107626c6f7c6303'
AND fiscal=2021
AND task_code='2020'
='101' AND agy_code THEN
Final accounts statements task_name='2020 departments'
The WHEN task_id='b83b5b673dee40dea417c7cf07b6b535'
AND fiscal=2021
AND task_code='2020'
='101' AND agy_code THEN
Final accounts statements task_name='2020 departments'
The WHEN task_id='d4eb1a0236da488ea3524a19c80dc5b3'
AND fiscal=2021
AND task_code='2020'
='101' AND agy_code THEN
Final accounts statements task_name='2020 departments'
The WHEN task_id='e1a4d5ec0c59474a80473aed9a8785b5'
AND fiscal=2021
AND task_code='2020'
='101' AND agy_code THEN
Final accounts statements task_name='2020 departments'
The WHEN task_id='f159f243868347cda48df543f14f3a1d'
AND fiscal=2021
AND task_code='0001'
='101' AND agy_code THEN
Task_name='fixed statements'
END
ORA - 00905: missing keyword what reason
  • Related