Hi @User_MHPVE,

XCC_BALANCES Stores budget balances including consumption and available funds.
XCC_BUDGET_DIST_ACCTS Contains distribution account details for budget entries.
XCC_CONTROL_BUDGETS Holds control budget definitions.
XCC_BUDGET_TRANSACTIONS Captures individual budgetary control transactions.

SELECT
bt.TRANSACTION_NUMBER,
bt.TRANSACTION_DATE,
bt.TRANSACTION_AMOUNT,
bt.TRANSACTION_CURRENCY,
bt.FUNDS_ACTION,
bt.LINE_STATUS,
bt.LINE_RESULT,
bt.CONTROL_BUDGET,
bt.BUDGET_ACCOUNT,
bt.RESERVED_BUDGET_AMOUNT,
bt.TOTAL_CONSUMPTION_BALANCE,
bt.FUNDS_AVAILABLE_BALANCE
FROM
XCC_BUDGET_TRANSACTIONS bt
WHERE
bt.TRANSACTION_DATE >= TRUNC(SYSDATE) - 30
ORDER BY
bt.TRANSACTION_DATE DESC;

Check this for more details:

Using Financials for the Public Sector

REST API for Oracle Fusion Cloud Financials - Get a budget entry transaction budgetary control result

Thanks,
Riyaz Ali

Have you looked at following tables

Budget transactions header → XLA_AE_HEADERS

Budget transactions lines → XLA_AE_LINES

Control budgets → XLA_CONTROL_BUDGETS

Hope it helps!