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
Hi @
Riyaz Ali-Oracle
XCC_BUDGET_TRANSACTIONS not exists in fusion, is there any other table available to get po details
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!
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?
