SQL query to get Budgetary control Transactions in oracle fusion financials

Question

RVohra · Answer

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!

Bipul · Answer

Hi @

Riyaz Ali-Oracle

XCC_BUDGET_TRANSACTIONS  not exists in fusion, is there any other table available to get po details

Riyaz Ali-Oracle · Answer

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