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.

  • 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. 
  • John May
    Solutions to inter-company/project not involving...
    Topic posted June 13, 2019 by John MayRed Ribbon: 250+ Points, tagged Capital Projects, Project Billing & Revenue in Project Management public
    Title:
    Solutions to inter-company/project not involving intercompany AR
    Summary:
    Does anyone have a solution in PPM (Cloud) to "Business Unit/Ledger" cross-charge solution not involving the standard intercompany/inter-project billing solution?
    Content:

    Client has multiple Business Unit/Ledgers (based on country) and does not have Oracle AR implemented.  Project timecards from various ledgers need to charge against another Business Unit/Ledger.  Additionally, these costs must be capitalized in the Project Ledger Fixed Assets.

    Classic solution is to use Inter-project billing (because of the capitalization restriction) by setting up matching projects in the provider ledger/BU and link to a receiver project in the receiver ledger/BU.  However, this involves setting up AR which the client does not need nor wants.

    Any successful solutions out there?

    Version:
    Oracle Fusion Projects Cloud Service 19B (11.13.19.04.0)
  • Aastha Ahuja
    Capture Group Assets from FA in Oracle PPM
    Topic posted May 17, 2019 by Aastha Ahuja, tagged Capital Projects, Project Costing, Project Management in Project Management public
    Title:
    Capture Group Assets from FA in Oracle PPM
    Content:

    Hi,

    Scenario: While creating an asset in Oracle PPM, I am not able to capture a Group Asset created in FA in the "Parent Assets" field in the Edit Asset Details page. A group asset doesn't come up in the LOV for parent assets. 

    Even after transferring a PPM asset to FA, The Asset type cannot be changed to group asset.

    I am looking for a confirmation on the following :

    1. Is the product designed such that a group asset should not appear in the list of values for parent asset in PPM

    2. Is there any other way, by which a group asset information can be captures on a PPM Asset.

     

    Looking forward to your comments

     

    Thanks,

    Aastha

     

    Version:
    Release 13 19A
  • Kim Puls
    Manage Burden Schedules & Fringe rates
    Topic posted April 15, 2019 by Kim PulsSilver Medal: 2,000+ Points, tagged Capital Projects, Grants Management, Project Management in Project Management public
    Title:
    Manage Burden Schedules & Fringe rates
    Content:

    Our institution is getting ready to go live with HCM and the discussion of how to assess different fringe rates, based on the position type. On the Burden Schedule, at the bottom are the multipliers...which include the F&A rate and then 3 different fringe rates for Faculty Fringe/Staff Fringe/Student Fringe.

    I'd like to know how we activate these rates to assess the applicable fringe based on the individual's position.

    Thanks - Kim