🔹 Join the OracleApps88 Telegram Group - Stay up to date with the latest on Oracle EBS R12 and Oracle Cloud/Fusion Applications. 📌 Telegram Group : https://t.me/OracleApps88

💡 Facing issues copying code/scripts or viewing posts? We're here to help!
📬 Contact on Telegram : https://t.me/apps88
📱 Telegram/WhatsApp: +91 905 957 4321
📧 Email Support: OracleApp88@Yahoo.com
Showing posts with label PA. Show all posts
Showing posts with label PA. Show all posts

Saturday, November 22, 2025

PA - Project Accounting

 1. Which of the following is NOT a valid Project Type Class?

a. Indirect

b. Direct

c. Capital

d. Contract

e. None of the Above


2. Which of the following is Mandatory for Capital Projects?

a. Generate Asset Lines

b. Create Draft Invoice for a Project

c. Create Draft Revenue for a Project

d. Capitalize Interest

e. None of the Above


3. Which of the following is NOT part of Oracle Projects Suite?

a. Oracle Project Accounting

b. Oracle Project Contracts

c. Oracle Order Management

d. Oracle Project Resource Management

e. Oracle Project Management


4. Identify the correct sequence for Expenditure Batch Status?

a. Working, Submitted, Released

b. Working, Submitted, Working

c. Submitted, Released, Working

d. Working, Released, Baselined

e. A and B


5. Identify the Correct Sequence for Project Budget Status?

a. Working, Submitted, Baselined

b. Working, Submitted, Released

c. Working, Submitted, Reversed

d. Submitted, Working, Submitted

e. A and D


6. At what level Oracle Projects is configured?

a) Set of Books

b) Business Group

c) Inventory Organization

d) Project/ Task Owning Organization

e) Not Applicable


7. Identify the Correct Sequence to create the Projects?

a) Project Type, Project Template, Project

b) Project Template, Project Type, Project

c) Project, Project Type, Project Template

d) Not Applicable

8. Which of the following is NOT required to Create Project Cost Budget?

a) Budget Type

b) Resource List

c) Budget Change Reason

d) Budget Entry Method

e) Not Applicable


9. Which of the following is NOT part of Pre Approved Expenditure Batch?

a) Supplier Invoices

b) Expense Reports

c) Burden Transactions

d) Time Cards

e) Usage


10. Which of the following application/s is/are integrated with Projects for Project Commitments?

a. Receivables

b. General Ledger

c. Cash Management

d. Purchasing

e. All of the Above


11. Which of the following CAN NOT be used for entering Employee Expense Reports?

a) Payables

b) iExpenses

c) Projects

d) Purchasing

e) All of the above


12. One Company is constructing Office Building for their own use. Which of the following Project Types

will you recommend for creating Project in Oracle?

a. Direct

b. Indirect

c. Capital

d. Contract

e. Any of the above


13. Which of the following is/ are mandatory to create project in Oracle?

a) Project Start and End Dates

b) Project Description

c) Key Members

d) Project Number

e) All of the above


14. Where do you Finally Decide whether Cross Charges are used or Not?

a. Template

b. Project Type

c. Project

d. Task

e. None of the above


15. What is the following can not be changed once Transactions are charged to the project?

a) Project Name

b) Project Description

c) Project Number

d) Project Status

e) All of the above


16. Which of the following can not be entered for Cost Budget?

a. Quantity

b. Revenue Amount

c. Raw Cost

d. Burdened Cost

e. None of the above


17. Which of the following level do NOT permit budget entry for a project?

a) Project

b) Top Task

c) Sub Task

d) Lowest Task

e) None of the Above


18. Which of the following is NOT a valid Allocation Rule Source?

a. Fixed Source Amount

b. Project Sources

c. GL Sources

d. Spread Evenly Source

e. None of the above


19. Which of the following is Correct Sequence for Allocations?

a) Define Allocation, Generate, Release

b) Generate, Define Allocations, Release

c) Define Allocation, Release, Generate

d) Define Allocation, Generate, Complete

e) Not applicable


20. Which of the following allocation Runs will you recommend to delete?

a. Draft Success

b. Release Success

c. Draft Failure

d. In Process

e. None


21. Which of the following can be optional while entering Supplier Invoices for Projects?

a) Project Number

b) Expenditure Type

c) Quantity

d) Expenditure Organization

e) Task Number


22. Where do we enter Project Information while entering Purchase Order?

a. Header

b. Lines

c. Shipment

d. Distribution Line

e. None


23. Which of the following is Correct?

a) Total Burdened Cost = Raw Cost + Burden Cost

b) Total Burdened Cost = Raw Cost * Burden Cost

c) Total Burdened Cost = Raw Cost - Burden Cost

d) Total Burdened Cost = Raw Cost / Burden Cost

e) None of the above


24. Which of the following is Correct?

a) Total Burdened Cost = Raw Cost × (1 * Burden multiplier(s))

b) Total Burdened Cost = Raw Cost × (1 / Burden multiplier(s))

c) Total Burdened Cost = Raw Cost + (1 + Burden multiplier(s))

d) Total Burdened Cost = Raw Cost - (1 + Burden multiplier(s))

e) None of the above


25. Which of the following can not be interfaced from Projects to General Ledger?

a. Usage Cost

b. Miscellaneous Transaction

c. Burden Transaction

d. Labor Cost

e. Expense Report Cost


26. Which of the following is correct sequence for Project Costing?

a) Distribute, Tieback, Interface

b) Interface, Distribute, Tieback

c) Tieback, Distribute, Interface

d) Distribute, Interface, Tieback

e) All of the above


27. Which of the following information is optional for Contract Project?

a. Billing Method

b. Revenue Accrual Method

c. Billing Cycle

d. Retention Information

e. All of the above


28. Which of the following is NOT supported Revenue Accrual and Invoicing Method?

a) Work

b) Event

c) Cost

d) Burden

e) None of the above


29. Which of the following is NOT a valid Rate Schedule?

a) Employee

b) Job

c) Non-Labor

d) Expenditure Category

e) None of the above


30. At what level can we control Revenue Accrual and Invoicing in Contract Project?

a) Top Task

b) Lowest Task

c) Sub Task

d) Top Task and Lowest Task

e) None of the above


31. Which are eligible to become Credit Receivers in Projects?

a) Suppliers

b) Customers

c) Employees

d) Company Agents

e) None of the above


32. For Budget Baseline to succeed, what is required?

a) Funding = Revenue Budget

b) Funding # Revenue Budget

c) Funding > Revenue Budget

d) Funding < Revenue Budget

e) None of the above


33. Which are eligible to become Credit Receivers in Projects?

a) Suppliers

b) Customers

c) Employees

d) Company Agents

e) None of the above


34. Which event will you use to reduce customer receivables in Projects?

a) Write Off

b) Write On

c) Scheduled Payment

d) Deferred Revenue

e) None of the above


35. Which Event Type will you use to enforce same amount for both Revenue and Invoice in Projects?

a) Write Off

b) Write on

c) Scheduled Payment

d) Deferred Revenue

e) Manual


36. Identify Correct Sequence for Invoice Processing in Projects?

a) Generate Draft Invoice, Approve Invoice, Release Invoice, Interface Invoice

b) Approve Invoice, Release Invoice, Generate Draft Invoice, Interface Invoice

c) Release Invoice, Interface Invoice, Generate Draft Invoice, Approve Invoice

d) Generate Draft Invoice, Approve Invoice, Interface Invoice, Release Invoice

e) None of the above


37. Which of the following is NOT a valid Invoice Status in Projects?

a) Unapproved

b) Approved

c) Released

d) Generated

e) Accepted


38. Which of the following is a critical setup step in Projects?

a) Budget Change Reason

b) Service Type

c) Probability List

d) Expenditure Type

e) Project Priority


39. Identify the correct formula for Cost to Cost Revenue calculation?

a) Actual Cost / Total Budgeted Cost * Total Budgeted Revenue

b) Actual Cost * Total Budgeted Cost / Total Budgeted Revenue

c) Actual Cost * Total Budgeted Cost + Total Budgeted Revenue

d) Actual Cost / (Total Budgeted Cost * Total Budgeted Revenue)

e) None of the above


40. Which of the following statements are true?

a) Revenue and Billing are interface with GL

b) Revenue is interfaced with GL and Billing with AR

c) Revenue is interfaced with AR and Billing with GL

d) Revenue and Billing are interface with AR

e) None of the above


41. What is Unbilled Receivables?

a) Revenue accrued in excess of Billing

b) Billing in excess of Revenue accrued

c) Revenue accrued = Billing

d) Revenue Amount + Billing Amount

e) None of the above


42. What is Unearned Revenue?

a) Revenue accrued in excess of Billing

b) Billing in excess of Revenue accrued

c) Revenue accrued = Billing

d) Revenue Amount + Billing Amount

e) None of the above


43. Which of the following statements are true?

a) Revenue and Billing are interface with GL

b) Revenue is interfaced with GL and Billing with AR

c) Revenue is interfaced with AR and Billing with GL

d) Revenue and Billing are interface with AR

e) None of the above


44. Which of the following is a last process step in Revenue Accrual Process?

a) Generate Draft Revenue

b) Interface Revenue

c) Tieback Revenue

d) Journal Import

e) None of the above


45. What is the purpose of Revenue / Invoice Hard Limit of Customer Agreement?

a) Generation Error (Stop)

b) Warning

c) Advice

d) Message to User


46. At the end of the project, what is expected?

a) Revenue Amount = Invoice Amount

b) Revenue Amount # Invoice Amount

c) Revenue Amount > Invoice Amount

d) Revenue Amount < Invoice Amount


47. Which if the following is NOT a valid Cross Charge Transaction?

a) Intra Operating Unit

b) Inter Operating Unit

c) Inter Company

d) Intra Business Group


48. What Cross Charge Processing Methods will you use for charges across Legal Entities?

a) No Cross Charge Process

b) Inter Company Billing

c) Borrowed and Lent

d) Message to User


49. Borrowed and Lent Processing is meant for?

a) Accounting Entries Only

b) Legal Documents

c) Warning Messages

d) Sending Mails to Users


50. What is the first configuration step in Projects?

a) Project Type

b) Expenditure Type

c) Implementation Options

d) Budget Entry Methods

e) Project Priorities


Frequently Asked Questions

1. How many Project Type Classes are there in Oracle Projects?

2. What is an Expenditure Type Class? Is it possible to add Expenditure Type Class in Projects?

3. What is the difference between Expenditure Type Class and Expenditure Type?

4. Is it possible to copy Project Templates from one operating unit to another?

5. Under what circumstances can we enter expenditures for a project belonging to another operating unit?

6. What is a Cross Charge? How many cross charges processing methods are available in Projects?

7. What is Allocation in Projects? What is the purpose of Mass Allocation in Projects?

8. What is Burden in Projects? How many ways can we allocate burden in Projects?

9. Can we enter expenditures for multiple projects in one batch? If yes, how can we do that?

10. What is the difference between Project Owning Organization and Expenditure Owning Organization?

11. What is the difference between Project Owning Organization and Task Owning Organization?

12. What is labor costing? Explain the process of labor costing?

13. What is the difference between Expenditure Category and Expenditure Type?

14. What is the role of subledger in Projects? Can we check the accounting entries in subledger?

15. How many sources are there for allocation in Projects? What is the process for allocation in Projects?

16. What is the difference between additive and precedence burden logic?

17. What is the difference between Indirect Project and Capital Project Types?

Monday, September 2, 2019

Fusion PPM – Oracle Fusion Project Portfolio Management Training Manual

Part of Oracle Fusion Applications, Oracle Fusion Project Portfolio Management is a 100 percent open, standards-based set of integrated modules that improves the way project-driven organizations and project professionals work, from the project executive and business stakeholder to the project manager to the team member. Traditional project portfolio management (PPM) applications focus only on a narrow slice of the project lifecycle—with collaboration, analysis and reporting, and exception management as an afterthought. Oracle Fusion Project Portfolio Management, in contrast, relies on providing access to information and collaboration between users to enable efficient and effective PPM and smarter business decisions. It is designed from the ground up with user experience in mind, to help project-driven organizations keep pace, keep score, and deliver extraordinary business insight.


Oracle Fusion Project Portfolio Management is part of Oracle Fusion Applications, which are completely open, standards-based enterprise applications that can be easily integrated into a service oriented architecture. Designed as a complete suite of modular applications, Oracle Fusion Applications help you improve performance, lower IT costs, and get better results. Whether you choose one module, a product family, or the entire suite, Oracle enables you to gain the benefits of Oracle Fusion Applications at a pace that matches your business needs.


1: Define Common Project Execution Options
  1-1: Creating an Implementation Administrator
  1-2: Creating and Adding Project Roles
  1-3: Creating Calendars for Projects and Resources
  1-4: Managing Project Enterprise Labor Resources
  1-5: Managing Project Enterprise Expense Resources

2: Define Project Management Configuration
  2-1: Setting Default Calendars and Progress Exception Thresholds
  2-2: Creating Enterprise Project Codes and Task Codes
  2-3: Creating an Issue Type d
  2-4: Creating a Deliverable Type
  2-5: Creating a Deliverable Using the Deliverable Type
  2-6: Managing Oracle Social Network Objects for Project Execution
  2-7: Setting Up the Enterprise Project Structure

3: Manage Requirements for Agile Software Development
  3-1: Creating a Sprint
  3-2: Creating a Product Family
  3-3: Creating a Product
  3-4: Creating a Release
  3-5: Creating a Release Milestone
  3-6: Creating Project Requirement Statuses

4: Define Project Resource Management Configuration
  4-1: Defining Attributes for Employees and Contingent Workers in Human Capital Management
  4-2: Defining Talent Profile Content
  4-3: Managing Employees and Contingent Workers for Project Resource Management 89
  4-4: Creating Project Enterprise Resources
  4-5: Managing Project Enterprise Labor Resource Maintenance Conditions
  4-6: Managing Resource Pools
  4-7: Updating Skills and Qualifications for Project Enterprise Labor Resources
  4-8: Submitting the Process to Maintain Project Resource Search Index
  4-9: Managing Target Utilization Percentages
  4-10: Managing Project Resource Management Messages

5: Project Execution Management Lifecycle Practices
  5-1: Creating a Project
  5-2: Managing the Project Calendar
  5-3: Creating a Project Resource Request
  5-4: Enabling a Project for Financial Management
  5-5: Monitoring Resource Utilization
  5-6: Searching, Evaluating, and Assigning Resources
  5-7: Assigning Resources Directly to a Project
  5-8: Managing Work
  5-9: Creating a Project Issue
  5-10: Creating a Project Change Order
  5-11: Updating Project Plan and Progress
  5-12: Monitoring Project Performance 





































Please click on the below link for more details:

Fusion PPM – Oracle Fusion Project Portfolio Management Training Manual


Please Like and Share our FaceBook page to get more details on Oracle Applications


Monday, November 26, 2018

Query to Get Oracle Projects Revenue and Billing Details

-->Summary
SELECT
    haou.name Organization,
    (select class_code
      from(select project_id,class_code, dense_rank() over(order by class_code desc)r
           from pa_project_classes
           where class_category = XXAA Account Number'
            and project_id = ppa.project_id
          ) where r=1
    ) Acc_num,
    ppa.project_type Project_Type,
    papf.full_Name Project_Manager,
    ppa.project_id,
    ppa.segment1 Project_Number,
    ppa.long_name Project_Name,
    paa.agreement_num Agrement_Number,
    TO_CHAR (ppa.start_date, 'DD-MON-YY') Project_Start_Date,
    TO_CHAR (ppa.completion_date, 'DD-MON-YY') Project_End_Date,
    pps.project_status_name Status,
    NVL ((SELECT SUM (NVL (allocated_amount, 0))
          FROM pa_project_fundings
         WHERE project_id = ppa.project_id
          AND agreement_id = paa.agreement_id),0
    ) Funding,
    SUM (NVL (projfunc_revenue_amount, 0)) Revenue_Recorded_To_Date,
    SUM (NVL (projfunc_bill_amount, 0)) Amount_Invoiced_To_Date,
    NVL (((SELECT SUM (NVL (allocated_amount, 0))
            FROM pa_project_fundings
           WHERE project_id = ppa.project_id
            AND agreement_id = paa.agreement_id)
        - SUM (NVL (projfunc_revenue_amount, 0))),0
    ) Balance_Rev_To_Record,
    NVL (((SELECT SUM (NVL (allocated_amount, 0))
            FROM pa_project_fundings
           WHERE project_id = ppa.project_id
                 AND agreement_id = paa.agreement_id)
        - SUM (NVL (projfunc_bill_amount, 0))),0
    ) Amount_Rem_To_Invoice
FROM
    pa_project_types_all ppta,
    hr_all_organization_units haou,
    pa_projects_all ppa,
    per_all_people_f papf,
    PA_PROJECT_CUSTOMERS pc,
    pa_agreements_all paa,
    pa_project_statuses pps,
    (SELECT DISTINCT project_id, person_id
       FROM pa_project_players
      WHERE project_role_type = UPPER ('PROJECT MANAGER')) ppp,
    (SELECT DISTINCT agreement_id, project_id FROM PA_PROJECT_FUNDINGS) pdia,
    pa_events pe
WHERE 1=1
    AND ppa.project_type = ppta.project_type
    AND ppta.org_id = ppa.org_id
    AND UPPER (ppta.project_type_class_code) = 'CONTRACT'
    AND pps.project_status_code = ppa.project_status_code
    AND ppa.CARRYING_OUT_ORGANIZATION_ID = haou.organization_id
    AND papf.person_id = ppp.person_id
    AND ppp.project_id = ppa.project_id
    AND ppa.project_id = pdia.project_id(+)
    AND pdia.agreement_id = paa.agreement_id(+)
    AND pc.project_id = ppa.project_id
    AND ppa.project_id = pe.project_id(+)
    -- AND ppa.project_id BETWEEN NVL (:p_from_project_id, ppa.project_id) AND NVL (:p_to_project_id, ppa.project_id)
    -- AND UPPER (haou.name) = UPPER (NVL (:p_organization, haou.name))
    -- AND UPPER (ppa.project_type) = UPPER (NVL (:p_project_type, ppa.project_type))
    -- AND UPPER (papf.full_name) = UPPER (NVL (:p_project_manager, papf.full_name))
    -- AND UPPER (pps.project_status_name) = UPPER (NVL (:p_status, pps.project_status_name))
GROUP BY
    haou.name,
    ppa.project_type,
    papf.full_Name,
    ppa.segment1,
    ppa.long_name,
    paa.agreement_num,
    ppa.start_date,
    ppa.completion_date,
    pps.project_status_name,
    ppa.project_id,
    paa.agreement_id
ORDER BY
    haou.name,
    ppa.project_type,
    ppa.segment1



-->Detail   
SELECT
    haou.name Organization
    ,(select class_code
      from(select project_id,class_code, dense_rank() over(order by class_code desc)r
           from pa_project_classes
           where class_category = XXAA Account Number'
            and project_id = ppa.project_id
          ) where r=1
    ) Acc_num
    ,ppa.project_type Project_Type
    ,papf.full_Name Project_Manager
    ,ppa.project_id
    ,ppa.segment1 Project_Number
    ,ppa.long_name Project_Name
    ,paa.agreement_num Agrement_Number
    ,to_char(ppa.start_date,'DD-MON-YY') Project_Start_Date
    ,to_char(ppa.completion_date,'DD-MON-YY') Project_End_Date
    ,pps.project_status_name Status
    ,nvl((select sum(nvl(allocated_amount,0)) from pa_project_fundings
     where project_id =ppa.project_id and agreement_id = paa.agreement_id),0) Funding
    ,pe.event_type Event_Type
    ,pe.event_num Event_Number
    ,pt.task_name Task_Name
    ,to_char(pe.completion_date,'DD-MON-YY') Event_Date
    ,pe.description Description
    --,pe.revenue_amount Revenue_Amount
    ,pe.BILL_TRANS_REV_AMOUNT Revenue_Amount
    ,pe.revenue_distributed_flag Revenue_Distributed
    --,pe.bill_amount Bill_Amt
    ,pe.BILL_TRANS_BILL_AMOUNT Bill_Amt
    ,pe.billed_flag Billed
    ,nvl(pe.projfunc_revenue_amount,0) Revenue_Recorded_To_Date
    ,nvl(pe.projfunc_bill_amount,0) Amount_Invoiced_To_Date
    ,(nvl((select sum(nvl(allocated_amount,0)) from pa_project_fundings where project_id =ppa.project_id and agreement_id = paa.agreement_id),0) - (select nvl(sum(projfunc_revenue_amount),0) from pa_events where project_id = ppa.project_id)) Balance_of_revenue_to_record
    ,(nvl((select sum(nvl(allocated_amount,0)) from pa_project_fundings where project_id =ppa.project_id and agreement_id = paa.agreement_id),0) -(select nvl(sum(projfunc_bill_amount),0) from pa_events where project_id = ppa.project_id)) sum_amount_invoiced_to_date
    ,(nvl((select sum(nvl(allocated_amount,0)) from pa_project_fundings where project_id =ppa.project_id and agreement_id = paa.agreement_id),0) - (select nvl(sum(BILL_TRANS_REV_AMOUNT),0) from pa_events where project_id =  ppa.project_id))unscheduled_rev_amt
    ,(nvl((select sum(nvl(allocated_amount,0)) from pa_project_fundings where project_id =ppa.project_id and agreement_id = paa.agreement_id),0) - (select nvl(sum(BILL_TRANS_BILL_AMOUNT),0) from pa_events where project_id = ppa.project_id))unscheduled_bill_event
FROM
    pa_project_types_all ppta
    ,hr_all_organization_units haou
    ,pa_projects_all ppa
    ,per_all_people_f  papf
    ,PA_PROJECT_CUSTOMERS pc
    ,pa_agreements_all paa
    ,pa_project_statuses pps
    ,(SELECT DISTINCT project_id, person_id FROM pa_project_players WHERE project_role_type = UPPER('PROJECT MANAGER')) ppp
    ,(SELECT DISTINCT agreement_id,project_id FROM PA_PROJECT_FUNDINGS)  pdia
    ,pa_events pe
    ,pa_tasks pt
WHERE 1=1   
    AND ppa.project_type = ppta.project_type
    AND ppta.org_id = ppa.org_id
    AND upper(ppta.project_type_class_code) = 'CONTRACT'
    AND pps.project_status_code = ppa.project_status_code
    AND ppa.CARRYING_OUT_ORGANIZATION_ID=haou.organization_id
    AND papf.person_id = ppp.person_id
    AND ppp.project_id = ppa.project_id
    AND ppa.project_id = pdia.project_id(+)
    AND pdia.agreement_id  = paa.agreement_id(+)
    AND pc.project_id = ppa.project_id
    AND ppa.project_id = pe.project_id(+)
    AND pe.task_id = pt.task_id(+)
    --AND UPPER(ppc.class_code) = UPPER(NVL(:p_company,ppc.class_code))
    --AND UPPER(haou.name) = UPPER(NVL(:p_organization,haou.name))
    --AND UPPER(ppa.project_type) = UPPER(NVL(:p_project_type,ppa.project_type))
    --AND UPPER(papf.full_name) = UPPER(NVL(:p_project_manager,papf.full_name))
    --AND UPPER(pps.project_status_name) = UPPER(NVL(:p_status,pps.project_status_name))
GROUP BY
    haou.name
    ,ppa.project_type
    ,papf.full_Name
    ,ppa.segment1
    ,ppa.long_name
    ,paa.agreement_num
    ,ppa.start_date
    ,ppa.completion_date
    ,pps.project_status_name
    ,pe.event_type
    ,pe.event_num
    ,pt.task_name
    ,pe.completion_date
    ,pe.description
    --,pe.revenue_amount
    ,pe.BILL_TRANS_REV_AMOUNT
    ,pe.revenue_distributed_flag
    --,pe.bill_amount
    ,pe.BILL_TRANS_BILL_AMOUNT
    ,pe.billed_flag
    ,pe.projfunc_revenue_amount
    ,pe.projfunc_bill_amount
    ,ppa.project_id
    ,paa.agreement_id
ORDER BY
    haou.name
    ,ppa.project_type
    ,ppa.project_id
    ,pe.event_num


If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect