Project Management

Get Involved. Join the Conversation.

Topic

    Paul Fernandez
    How to get Contract value column in the ADFDI spreadsheet...Answered
    Topic posted February 27, 2019 by Paul FernandezBronze Medal: 1,250+ Points 
    119 Views, 7 Comments
    Title:
    How to get Contract value column in the ADFDI spreadsheet for Misc Costs/Labor Costs
    Summary:
    How to get Contract value column in the ADFDI spreadsheet for Misc Costs/Labor Costs
    Content:

    Hi All,

    Trying to create a Misc Transactions Batch through the ADFDI spreadsheets.
    Navigation: Capture Costs-->Create NonLabor Costs

    In the spreadsheet, there is no column for the Contract Number.

    If we have multiple awards/contracts funding the projects, how do we enter the respective Contract/Award number?
    I am testing this in a Vision Demo database with the following application version:
    *********
    Oracle Cloud Application
    Revision 13.18.10 (11.13.18.10.0) which I believe is 18C
    ***********
    I also saw somewhere that multi funding  by different awards was not supported till Rel 13.
    But this is, Rel 13. 18C.

    I can see the contract# with a LOV for multiple contracts in the UI (to enter 'Manage Unprocessed Costs)
    where I can choose/enter different award value per transaction.

    Can anyone please advise how to enter the different contract numbers through the ADFDI spreadsheet?
    Is it configurable to add fields for Contracts?

    Your replies are greatly appreciated.

    Thanks

    --Paul Fernandez

    Best Comment

    Prithi Bandla

    Yes, FBDI works for the scenario. Please refer to documentation at https://www.oracle.com/pls/topic/lookup?ctx=en/cloud/saas/project-portfolio-management/19a&id=OEFPP. There are 5 xlsm templates for cost import depending on the type of cost being imported (labor, nonlabor, etc) - all support the contract and funding source attributes.

    Comment