8 Replies Latest reply on Nov 19, 2015 1:47 AM by User223410

    API to create a Requisition Line

    1567114

      Hello All,

       

      I need some urgent help on one of the Business Requirement.

       

      I have Requisition Number example REQ1234 in po_requisition_headers_all and also corresponding records in po_requisition_lines_all .

       

      The business requirement is for a given Requisition Number REQ1234 when selected a new line will be inserted in the po_requisition_lines_all(based on some business validation).

       

      How to approach for this?I could not find any API which tells a new line to be created for LINE level if HEADER record exists and subsequently calling the REQUISITION IMPORT Concurrent Program for inserting the lines in base tables

       

      Please help me on this.

       

      Thanks

        • 1. Re: API to create a Requisition Line
          Sanjay Desai EBS

          I think the functionality to add the new line to existing PR is not possible thru requisition import process.

          sanjay

          • 2. Re: API to create a Requisition Line
            1567114

            Hello,

             

            Thanks for your reply.

             

            If i insert into po_requisitions_interface (through Custom Code) and then call the REQIMPORT though FND_REQUEST will the requisition lines be inserted for the already existing requisition numbers?

             

            I dont want to populate the PO_REQUSITION_HEADERS_ALL only PO_REQUISITION_LINES_ALL

             

            Can i use the 'Group By'  parameter in REQIMPORT to insert lines for existing Requsition Number.

             

            Please help

             

            Thanks

            • 3. Re: API to create a Requisition Line
              1567114

              Hello All,

               

              Please help me if anyone has some background in it.It will be helpful.

               

              Thanks

              • 4. Re: API to create a Requisition Line
                Vanha.L-Oracle

                Hello,

                 

                Unfortunately, current functionality does not allow for update of existing requisition using requisition import process in Oracle Purchasing.

                This is an enhancement request, documented in Bug 4163586.

                This ER is listed in Enhancement Request - Purchasing Import/Concurrent programs - PROCESSES (Doc ID 1305832.1)

                ER are now manage by Community. You can consider entering an ER and gather votes.

                Details are in Oracle E-Business Suite Product Enhancement Request to My Oracle Support Community FAQ (Doc ID 1584210.1)


                Regards,

                Vanha

                 

                • 5. Re: API to create a Requisition Line
                  1567114

                  Hello,

                   

                  Can i used po_requisition_update_pub.update_requisition to create new line,distribution for an existing Requisition Number?

                   

                  Thanks

                  • 6. Re: API to create a Requisition Line
                    1567114

                    Hello,

                     

                    Can i used po_requisition_update_pub.update_requisition to create new line,distribution for an existing Requisition Number?

                     

                    Thanks

                    • 7. Re: API to create a Requisition Line
                      1567114

                      Hello,

                       

                      In 12.2.4 there is an API po_requisition_update_pub.update_requisition.Can i use for the NEW Line and Distribution Line creation for an existing Requisition Number?

                       

                      I am facing problems while calling the API :

                       

                      po_requisition_update_pub.update_requisition

                            (

                            'False',

                           'Y'   ,

                            v_ret_stat,            

                            v_msg_cnt,  

                            v_msg_data,          

                            'N',                 

                            v_source_tab1,

                            v_source_tab,

                            v_source_tab2);

                       

                      Its throwing

                      PLS-00306: wrong number or types of arguments in call to 'UPDATE_REQUISITION'

                      ORA-06550: line 252, column 7:

                       

                      v_source_tab,v_source_tab1,v_source_tab2 are Record Type variables.

                      • 8. Re: API to create a Requisition Line
                        User223410

                        Hi,

                         

                        I am facing the same issue as well. I am calling the API with following parameters -

                           PO_REQUISITION_UPDATE_PUB.update_requisition (

                              p_init_msg_list     => 'T',

                              p_commit            => 'Y',

                              x_return_status    => l_return_status,

                              x_msg_count       => l_msg_count,

                              x_msg_data         => l_msg_data,

                              p_submit_approval   => 'N',

                              p_req_hdr           => l_req_hdr,

                              p_req_line_tbl     => l_req_line_tbl,

                              p_req_dist_tbl     => l_req_line_tbl);

                         

                        l_req_hdr, l_req_line_tbl and l_req_line_tbl are Record Type variables

                        Please let me know the correct way to use this API.

                         

                        Thanks.