2 Replies Latest reply: Aug 22, 2013 10:44 AM by PAMPANA RSS

    Projects functional for a non functional person

    user7640966

      Hello everyone,

      I wanted to get into a functional role (Projects), currently playing a DBA role.  I have started with Oracle Projects Fundamentals document (please let me know if I have started right).  I could see some terminologies which I am not familiar with for example "Burden Cost Processing".

       

      Question to the forum members

      1. Do I have to refer to some other pre-req documents before starting this to get these terminologies familiar

      2. How do I get myself familiar with some of the business processes like "Order to Cash", are there standard documents available for this?

       

      Thanks

        • 1. Re: Projects functional for a non functional person
          Dina Rotem

          Hi

           

          Go on with reading the Project Costing User Guide. I assume you might be able to understand there, the terms that you have not understood earlier.

          I'm not sure there is a single book that will teach you all.

          For non Oracle generic knowledge about Projects you could find tons of books. One of the most comprehensive might be the Projects Manahement Body Of Knowledge (PMBOK).

           

          Dina

          • 2. Re: Projects functional for a non functional person
            PAMPANA

            Hi Dina,

            Good Morning.. I am currently in the process of doing Project Contracts conversion from R12 (source) to R12 (target) using database links.. I am in the process of testing the api's with static data first .. When i map the data to the contract header api, i could able to create a contract but for the Contract lines, it is errors out.. In Project contracts i think we need to create contract lines and sub lines..  could you please give me some idea on how the sub lines can be derived from contract lines...

             

            do you have a program which you worked in the past.. Could you please share it.. my email id is rpampana@gmail.com

             

            I am using   1) oke_import_contract_pub.create_contract_header

                              2) oke_import_contract_pub.create_contract_line

                              3) oke_import_contract_pub.define_billing_methods

                              4) oke_terms_pub.create_term

             

             

            I derived the inventory_item_id in the target instance based on the  item number from source.. but still it says invalid inventory_item_id

             

             

            =====================================================================================

            The original contract number:4100401462_9886546

             

            Contract header id:875449

             

            Contract header number:4100401462_9886546

             

            Return Status S

             

            l_msg_count 0

             

            l_msg_data

             

            Return Status S

             

            l_msg_count 0

             

            l_msg_data

             

            Inventory_item_id for 5498563-79 is -->1285587

             

            1. Value for INVENTORY_ITEM_ID is invalid.

             

            2. OKE_NO_PARENT_RECORD (COL_NAME=billing_method_code) (CHILD_TABLE=OKE_K_LINES_V) (PARENT_TABLE=OKE_K_BILLING_METHODS)

             

            Return Status E

             

            l_msg_count 2

             

            l_msg_data

             

            Inventory_item_id for 5498563-9 is -->1285589

             

            1. Value for INVENTORY_ITEM_ID is invalid.

             

            2. OKE_NO_PARENT_RECORD (COL_NAME=billing_method_code) (CHILD_TABLE=OKE_K_LINES_V) (PARENT_TABLE=OKE_K_BILLING_METHODS)

             

            Return Status E

             

            l_msg_count 2

             

            l_msg_data

             

            Inventory_item_id for 7104853-1 is -->1306099

             

            1. Value for INVENTORY_ITEM_ID is invalid.

             

            2. OKE_NO_PARENT_RECORD (COL_NAME=billing_method_code) (CHILD_TABLE=OKE_K_LINES_V) (PARENT_TABLE=OKE_K_BILLING_METHODS)

             

            Return Status E

             

            l_msg_count 2

             

            l_msg_data

             

            PL/SQL procedure successfully completed.

            ====================================================================================================

             

            Thanks

            Ravikumar.