Hi I'm new in ERP - Oracle Application
i appriciate if any one help me in this issue

i need SQL to get
badeget balance
Acutal Balance
Encumbrance Balance
fund Avalable

thanx
ahmed



Hi I'm new in ERP - Oracle Application i appriciate if any one help me in this issue i ne..

Answer / Umesh Pandit

To get the budget information you mentioned (Budget Balance, Actual Balance, Encumbrance Balance, and Fund Available), you can use Oracle's FND_PROJECT_ACTIVITIES view. Here is an example SQL query:nn```sqlnSELECT budget_id, budget_name, budget_amount, actual_amount, encumbrance_amount, fund_available nFROM fnd_project_activities nWHERE budget_id = '<your budget id>' nORDER BY activity_id;n```nReplace '<your budget id>' with your specific budget ID. This query retrieves the budget details for a given budget ID and sorts them by activity ID.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Apps Financial Interview Questions

Can any one tell me Client Interaction?

1 Answers  


What is Intercompany Invoicing?

5 Answers  


what is invoice variance in ap

2 Answers   Accenture,


On what basis you will define accounting structure

3 Answers   Meru Cabs,


why should we create prorate calender and what is the difference between depreciation calender and prorate calender in fixed assets module?

4 Answers   Wipro,


What is a Value set and types of value set?

9 Answers   Oracle,


What is the basic setup of payable?

1 Answers   Deloitte,


At what level FA is implemented?

13 Answers   DELL,


what is internal retairment?

1 Answers   Accenture,


Is FA Supports Multi _org?

1 Answers  


Is it possible to import invoices of a specific Sales Order?

1 Answers  


What kind of budgets have you worked on?

1 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)