Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    MShrini
    Actual Cost is showing 0 in Project OTBI reports after R12...Answered
    Topic posted August 31, 2017 by MShriniBronze Crown: 15,000+ Points, tagged Fusion Project reporting, OBIEE Answers, OTBI, Reports, Sample Reports 
    292 Views, 9 Comments
    Title:
    Actual Cost is showing 0 in Project OTBI reports after R12 upgrade
    Summary:
    Actual Cost is showing 0 in Project OTBI reports after R12 upgrade
    Content:

    Hi,

    We are facing an issue like Actual costs are showing '0' for Project Analytics (OTBI) reports.  Please let me know if any one faced similar issue after upgrade/P2T earlier and got the solution.

    Thanks,

    Srini.

     

     

    Best Comment

    MShrini

    Hi Dustin,

    Oracle is provided the solution and resolved the issue. Fix is all the user's roles needs to be replaced with below roles instead of old roles where the old roles are having prefix as PJF..

    Project Accountant ORA_PJF_PROJECT_ACCOUNTANT_JOB
    Project Administrator ORA_PJF_PROJECT_ADMINISTRATOR_JOB

     

    Comment

     

    • MShrini

      Hello Experts,

      Kindly share any ideas to resolve this issue.

      Thanks,

      M Srinivasu.

       

    • Dustin Grabowski

      This is a known issue.  We are preparing a solution document that we will share here when it is ready.  For now I would request that you log an SR and Support can provide the steps to resolve the issue.

      • MShrini

        Hi Dustin,

        Many Many Thanks for making the below attached document regarding this issue. Its really useful for every on who are going to be upgraded in to R12.

         

    • MShrini

      Thanks Dustin,

      As suggested we have raised the SR and will see updates from them.  Meantime if the document is finalized, kindly share us.

      Thanks,

      MSrinivasu.

    • MShrini

      Hi Dustin,

      Oracle is provided the solution and resolved the issue. Fix is all the user's roles needs to be replaced with below roles instead of old roles where the old roles are having prefix as PJF..

      Project Accountant ORA_PJF_PROJECT_ACCOUNTANT_JOB
      Project Administrator ORA_PJF_PROJECT_ADMINISTRATOR_JOB

       

    • Amrit Mishra

      Hi Srinivasu,

      Please find the document attached here.

      Thanks and regards,

      Amrit

    • MShrini

      Hi Amrit, I am not able understand about your comments.  Please confirm  whether it is related to this topic or not.

      • Amrit Mishra

        Hi Srinivasu,

        Dustin had earlier said that we are preparing a document and will share with you on this. This is the same document. It lists the steps that you must take to replace the older roles with the new roles etc. After performing these steps you can view data in your OTBI reports.

        Thanks and regards,

        Amrit

    • MShrini

      Hoo OK.   Thanks for sharing that document.