adspace
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
Answer Posted / 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 View All Answers
what r issues faced in gl
I am traying to access oracle functiona/ technical interview questions asked by the consultancy "infosys", but i cant find anything when i go the to the links, i need the oracle erp techno functiona questions pls, Thanks, in advance Tovia
1.what is the name of program to create invoice automatic from po.? 2.How to auto upload the bank statement? 3.PO tax has not flown to invoice . why? Debit memo not generated for return of goods.??