SQL query to get Budgetary control Transactions in oracle fusion financials

User_MHPVE

Riyaz Ali-Oracle

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