Posts

Posts

  • Mayur
    Generate Borrow and Lent for fix amount
    Topic posted August 12, 2019 by Mayur, tagged Capital Projects, Project Costing in Project Management public
    Title:
    Generate Borrow and Lent for fix amount
    Content:

    Hi, 

    Currently we are using Borrow and lent functionality. 
    We are using Cost to Cost and cost plus amount to generate borrow and lent. For both method working as per expectation. 

    We have one more requirement. 

    We want to generate Borrow and lent every month for Fixed amount. 
    i.e. We want to generate borrow and lent transaction for GBP 5000 every month. 
    The actual project cost will be from OTL, Misc. transaction, purchasing, payable and Inventory modules. this amount may be GBP 4000 or GBP 7000. 
    But we want to generate Borrow and lent every month for GBP 5000.

    Example

    We have project "***" in highway department, project "***" require some labor work, so department "NNN" is a service department, will provide service to highway project"***".

     

    Employee of "YYY" department will submit time sheet to project "***"

    Now at the month end following entry for OTL 
    Debit: --.***.101.---.-- (GBP 3000/7000) 
    Credit: --.YYY.---.---.-- (GBP 3000/7000) 

    After that we want to generate Borrow and lent transaction with GBP 5000 (fix amount) every month end. 
    (transferring of amount from one cost centre and analysis code to another cost centre and analysis code - with the help of Borrow and lent) 

    Debit: --.ZZZ..MMM.-- (MMM will change based on each project) 
    Credit: --.***.101.---.-- 

    So at project level month end we can know the cost of project and GL level also.

     

    Please help me to map this requirement.

     

    Thanks in Advance.

     

  • Mayur
    Received funding for project, want to capture the same and...
    Topic posted August 12, 2019 by Mayur, tagged Capital Projects, Project Costing in Project Management public
    Title:
    Received funding for project, want to capture the same and track the consumption
    Content:

    Hi 

    We are receiving funding for the project and we want to capture the same at project level. 
    We want to capture consumption of funding and remaining balance. 


    i.e. 
    We are receiving following types of funding. 
    Borrowing, capital receipts and reserve. 

    Project 1001 received "Capital receipts" GBP 10,000. 

    Now we will book cost from various module i.e. OTL, purchasing, Payables, Inventory. 
    We submit time sheet of employees to project 1001. (150 GBP/Hour * 10 Hours = 1,500 GBP) 

    Now at project level remaining funding of capital receipts GBP 8500 (10,000 - 1,500) 

    Provide you accounting detail. 
    Funding received should book at following combination - "E-9125-101-5001" - 10,000 

    Actual cost 
    Dr. E-14090-101-6506 - 1,500 (14090 - project task owning organization) 
    Cr. E- *** -100-6506 - 1,500 (***- map to employee organization) 

    At project level business want to capture 10,000 as advance as well actual cost. So project level project manager they can view remaining balance 8,500, funding received 10,000 and actual cost 1,500). 
    By accounting we want to achieve the remaining balance of 8,500, so at GL level also business can have an idea that 8,500 is remaining from funding. 

    Please help me to map this requirement.

    We PURCHASED license of Project Costing, Project control and Project Billing. Licence of Grants Management is NOT Purchased.

    Thanks in advance.

  • Traci Kawaguchi
    Reconcile Budgetary Control and Award Balances
    Topic posted August 1, 2019 by Traci KawaguchiGreen Ribbon: 100+ Points, tagged Capital Projects, Grants Management, Project Management, Public Sector in Project Management public
    Title:
    Reconcile Budgetary Control and Award Balances
    Summary:
    Looking for a way to reconcile budgets to award balances
    Content:

    I am looking for a way to reconcile the balances in my budgetary control to the balances in my awards.

    We went live in Oracle Fusion in October 2018 and all the project related budget was dumped into a temporary account we've called Project Extravaganza, which allowed us to continue to process payments without hitting our absolute control limit, but because we potentially converted more in budget than was awarded, i need to be able to reconcile the budget with the award to know that no other project is "stealing" from another.

    If anyone has any tips, tricks, reports, analyses or advice, I'd really appreciate the help!

  • Sabarish Ganda
    While importing costs from an AP Invoice associated to a PO...Answered4
    Topic posted July 28, 2019 by Sabarish GandaGold Medal: 3,500+ Points, tagged Capital Projects, Payables, Project Costing in Project Management public
    Title:
    While importing costs from an AP Invoice associated to a PO we do not see any successful transactions when we run the Import Costs process. Screenshots of invoice creation and import costs transactions process attached.
    Content:

    While importing costs from an AP Invoice associated to a PO we do not see any successful transactions when we run the Import Costs process. Screenshots of invoice creation and import costs transactions process attached. 

     

    Please check the attached Screenshots for more Information

    Version:
    R13 (19B)
    Image:
  • Satya Sundararajan
    Automatic Invoice/Revenue Generation4
    Topic posted July 23, 2019 by Satya Sundararajan, tagged Capital Projects, Grants Management, Other, Project Billing & Revenue, Project Contracts, Project Costing, Project Management, Project Management Mobile, Project Performance Reporting, Project Planning & Scheduling, Project Planning, Budgeting, & Forecasting, Project Resource Management, Public Sector, Security, Task Management, Tip, Upgrade, UX in Project Management public
    Title:
    Automatic Invoice/Revenue Generation
    Summary:
    Automatic Monthly Invoicing - fixed dollar
    Content:

    Hi, we have a requirement where the customer wants to generate fixed dollar invoice each month. The project duration could be 5 years and it will be a difficult step to create manual event each period across projects. is there a better way to handle this situation based on an amount based bill plan?

     

    Version:
    19C
  • Kim Puls
    Funds Check fail on a requisition1
    Topic posted July 5, 2019 by Kim PulsSilver Medal: 2,000+ Points, tagged Capital Projects, Project Management in Project Management public
    Title:
    Funds Check fail on a requisition
    Content:

    We have a project that expired 12/31/19 and the end-user is trying to use it on a requisition. The check funds is failing saying the budget date of 7/5/19 is not between the project dates of 8/1/16 and 6/30/19...why is it showing a June 19 end-date when the project page is 12/19?

    XCC-675370

    Version:
    R13-19B
  • Rajdeep Sandhu
    Resource classes1
    Topic posted July 1, 2019 by Rajdeep Sandhu, tagged Capital Projects, Project Billing & Revenue, Project Contracts, Project Costing, Project Management Mobile, Project Performance Reporting, Project Planning & Scheduling, Project Planning, Budgeting, & Forecasting in Project Management public
    Title:
    Resource classes
    Summary:
    'Financial resource' is not available under Resource classes
    Content:

    Hi,

    4 seeded resource classes available in Oracle Fusion Applications.

    Labor, Equipment, Material items, Financial resource.

    We do not have the option 'Financial resource'. where can I check for this. while defining RBS Structure can cannot categories any Expenditure as Financial resource.

  • Rajdeep Sandhu
    Project Hierarchy2
    Topic posted July 1, 2019 by Rajdeep Sandhu, tagged Capital Projects, Project Billing & Revenue, Project Contracts, Project Costing, Project Management in Project Management public
    Title:
    Project Hierarchy
    Summary:
    Enterprise Project structure
    Content:

    Hi All,

    Requirement is to setup a Project parent child hierarchy. As we do not have 'Project as program ' EBS functionality in Fusion. How can Enterprise Project Structure(EPS) be used to report the cost.

    Secondly, any example on how to use DFF for the same.

    Thanks.

  • Maarten van Zoest
    Add Plain cost amount of Labor to Project Plan
    Topic posted June 18, 2019 by Maarten van ZoestGreen Ribbon: 100+ Points, tagged Capital Projects, Project Planning, Budgeting, & Forecasting in Project Management public
    Title:
    Add Plain cost amount of Labor to Project Plan
    Content:

    Hi all,

    Within the Project Costing section in PPM, we would like to add Labor Resource to the Project Planning in a 'plain' raw cost amount, instead of specifying the quantity of hours (for which a rate schedule should be setup again). Please see also the screenshot attached. Reason for this requirement is that we are going to incur labor hours directly in the PA module, and when not adding to the project planning (which will lead to the first version of the budget), the labor hours that will be written are being incurred as unplanned costs (which has its consequences again on the Estimate at Completion amount). We'd like to have it being written on the project as planned cost.

    Also, we'd like to add this Labor amount to the project level, instead of adding it to the task level.

    Does anyone has an idea on this?

    Many thanks in advance!

    Kind regards,
    Maarten

    Image:
  • Nadine Stephens
    PPM - Restrict transactions from bypassing PPM.
    Topic posted June 18, 2019 by Nadine Stephens, tagged Capital Projects, Project Costing, Project Management, Project Performance Reporting, Public Sector in Project Management public
    Title:
    PPM - Restrict transactions from bypassing PPM.
    Summary:
    How to prevent bypassing PPM to avoid variances with General Ledger amounts?
    Content:

    We would like to:

    1. Restrict end users from entering requisitions without populating project number, task number and contract number in requisition preferences. Currently users are able to apply a favorite charge account which bypasses PPM while updating the general ledger.
    2. Restrict end users from creating an AP invoice (non-purchase order) without populating project number, task number and contract number, expenditure type and organization.