3 Replies Latest reply: Oct 25, 2013 5:44 AM by Raghavan G-Oracle RSS

    Error on running API Pa_Budget_Pub.add_budget_line

    deearora - oracle

      Hi,

       

      I am trying to run the Pa_Budget_Pub.add_budget_line API with the below code:

       

      Pa_Budget_Pub.add_budget_line(

              p_api_version_number=> l_api_version_number,

              p_commit             => l_commit,

              p_init_msg_list     => l_init_msg_list,

              p_msg_count         => l_msg_count,

              p_msg_data             => l_msg_data,

              p_return_status     => l_return_status,

              p_pm_product_code     => l_pm_product_code,

              p_pa_project_id     => l_project_id,

              p_budget_type_code     => 'FR',

              p_pa_task_id         => 21003,

              p_period_name         => 'OCT-W1-13',

              p_revenue            => 1000

      );

       

      but on running this, it errors out with the error:

       

      Project: '';Task:;Budget Type: 'FR';

      Resource:'';Start Date:'01-JAN-12';

      The Resource is not valid for the specified Resource List.

       

       

      I am unable to figure out the issue, I tried providing the resource_member_id and resource_alias parameter as well but to no avail. Kindly help in resolving this issue.

       

      regards,

      Deepak

        • 1. Re: Error on running API Pa_Budget_Pub.add_budget_line
          vinod2303

          Hi Deepak,

           

                   the resource_member_id and resource_alias which you provided were attached to the project at planning resources ?

           

           

          Regards,

          VInod

          • 2. Re: Error on running API Pa_Budget_Pub.add_budget_line
            deearora - oracle

            Hi Vinod,

             

            yes i checked the resource member id, that was fine but the issue was with the financial plan type.. i was on trying to use the budget type code in R12, which now, i think, is not supported. Please correct me if I am wrong in understanding this. When i provided the fin plan type id, it worked.

             

            regards,

            Deepak

            • 3. Re: Error on running API Pa_Budget_Pub.add_budget_line
              Raghavan G-Oracle

              Hi ,

               

              Looks like your budget type might have been upgraded to financial plans. Oracle Projects has two models when it comes to budgets. One is the traditional form based budgets, identified by budget types. The other is the Financial Plans, which is used in Project Management Module. The older model ones are referred to as budget and the newer model ones are referred to as Financial Plans which provides several more additional functionality as compared with the traditional budget types.

               

              Both are supported by oracle, however, once a budget type / budget version is upgraded to financial plan types/versions you will not be able to maintain them using the forms interface, you will have to use the self service pages only for those.

               

              It appears that your budget type / budget version might have been upgraded to financial plan types, which is why you had to pass the fin_plan_type_id (Financial Plan type id) for the API to work.

               

              Regards,

              Raghavan Gopalakrishnan