7 Replies Latest reply: Jul 25, 2013 2:46 AM by 997077 RSS

    Is there any API to create incomplete AR Invoice?

    553796
      We have a requirement where we need to create on Acct Credit Memo in incomplete state. This will go into aproval proces. Once approved we need to complete the invoice. If rejected, then we need to delete the incomplete invoice. I checked with AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE, it always creates in complete state. But we need to create in incomplete state.
      Any pointers on this would be helpfull.

      Thanks & Regards,
      Sowmya
        • 1. Re: Is there any API to create incomplete AR Invoice?
          Hussein Sawwan-Oracle
          Hi,

          Please see if (Note: 413627.1 - AR_INVOICE_API_PUB.CREATE_INVOICE Creates Incomplete Invoices) is applicable.

          Regards,
          Hussein
          • 2. Re: Is there any API to create incomplete AR Invoice?
            553796
            Thanks Hussein.
            The note tells that it was issue with a parameter passed. Resolved in later releases by aplication of patch.
            But it will not serve our purpose of creation of incomplete on Account CM.
            Let me know if you have any reference for it.
            • 3. Re: Is there any API to create incomplete AR Invoice?
              361710
              Hi,
              We did have the same kind of problem with creating transactions in incomplete state using the open interface. The only solution that we found was to create a custom trigger on RA_CUSTOMER_TRX_ALL to incomplete invoices (:new.COMPLETE_FLAG := 'N').
              Hope this help,
              J.
              • 4. Re: Is there any API to create incomplete AR Invoice?
                James Kim
                I had a similar requirement once...but with invoice creation through Autoinvoice interface tables.

                What we ended up doing was to create a wrapper program around AutoInvoice program that will set all successfully imported invoices to incomplete status and kick off a workflow approval process.

                Once the invoice got approved through workflow approval, the approved invoice would then be set to complete status.

                'Complete' button on the transaction workbench had to be greyed out..to prevent users from completing/incompleting invoices.

                You may try this approach..

                James.

                Edited by: James Kim on Mar 17, 2010 2:28 PM
                • 5. Re: Is there any API to create incomplete AR Invoice?
                  pkpatel
                  Hi James,

                  We have exactly similar requirement, where invoices would be created through AutoInvoice and then sent for approval.
                  We need to make the Invoices Incomplete before sending for approval and sent them complete once we get the approval.

                  Can you please elaborate what you did to Complete and Incomplete the Invoices? Is it direct table update of RA_CUSTOMER_TRX_ALL? I didn't find any API to achieve the same.

                  Appreciate your response.
                  Thanks.
                  Prabhat
                  • 6. Re: Is there any API to create incomplete AR Invoice?
                    user4714181
                    Has any successfully done this? That is, imported data via autoinvoice and then have the transaction incompleted either via sql updates or an API?
                    • 7. Re: Is there any API to create incomplete AR Invoice?
                      997077

                      Hi all,

                      We had a similar problem.
                      As the solutions were used AR functions:

                       

                      arp_process_header_updte_cover.update_header_cover (p_form_name       => 'ARXTWMAI',
                                                                          p_form_version    => 1,
                                                                          p_customer_trx_id => l_trx.customer_trx_id,
                                                                          p_complete_flag   => 'N',
                                                                          ...
                                                                          );

                       

                      arp_process_header.post_commit ('ARXTWMAI',
                                                      70.1,
                                                      l_trx.customer_trx_id,
                                                      'N',
                                                      ...
                                                      );

                       

                      The data was taken from RA_CUSTOMER_TRX_PARTIAL_V.