SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DATA MODEL

Jayson_LRMCJul 25 2025

Hi,

can anyone help im creating addition/retirement FA report and for some reason i can't get the retirement proceeds even im using the SQL. can anyone tell me whats missing or error.

SELECT
fat.asset_number,
fat.asset_description,
fat.asset_type,
fat.asset_category,
fat.book_type_code,
fat.transaction_date,
fat.transaction_type,
fat.transaction_amount,
NULL AS retirement_proceeds
FROM
fusion.fa_transaction_headers fat
WHERE
fat.transaction_type = 'ADDITION'
AND fat.transaction_date BETWEEN TO_DATE('2022-01-01', 'YYYY-MM-DD') AND TO_DATE('2024-12-31', 'YYYY-MM-DD')

UNION ALL

SELECT
fat.asset_number,
fat.asset_description,
fat.asset_type,
fat.asset_category,
fat.book_type_code,
fat.transaction_date,
fat.transaction_type,
fat.transaction_amount,
fat.retirement_proceeds
FROM
fusion.fa_transaction_headers fat
WHERE
fat.transaction_type = 'RETIREMENT'
AND fat.transaction_date BETWEEN TO_DATE('2022-01-01', 'YYYY-MM-DD') AND TO_DATE('2024-12-31', 'YYYY-MM-DD')

but still is error.

im using Cloud fusion.

thanks

Added on Jul 25 2025

#answers, #data-modeler

2 comments

128 views