0 Replies Latest reply: Mar 27, 2013 6:17 PM by User578264 RSS

    JPublisher error when using OracleAppsAdapter to coonect a SP in EBS12

    User578264
      Hi

      I am trying to connect to a SP in EBS 12 from one BPEL process. JDeveloper I am using is 11.1.1.6.0 with SOA extension.
      I often get some JPublisher error in the step 5 in Adapter Configuration Wizard. The error popup says:

      "JPublisher error occured. An error occured when running JPublisher. An error occured when JPublisher was invoked: ERROR: missing method. Analyze the error and correct if possible. Contact oracle support if error is not fixable".

      My SP is quite simple one and it looks like the below:
      create or replace
      Package BPEL_INVOICE_SCANNING_EBS Is

           TYPE r_invoiceid IS RECORD (
                INVOICE_ID NUMBER
           );
           TYPE t_invoice_table is TABLE of r_invoiceid index by BINARY_INTEGER;
           
           -- Get a list of invoices ids --
           FUNCTION getInvoiceIds(
                countOfInvoices IN NUMBER,
                countOfInvoiceLines IN NUMBER,
                p_holds out t_invoice_table
           ) RETURN NUMBER;

      End BPEL_INVOICE_SCANNING_EBS;


      create or replace
      Package Body BPEL_INVOICE_SCANNING_EBS As

      -- Get a list of invoices ids --
      FUNCTION getInvoiceIds(countOfInvoices IN NUMBER,countOfInvoiceLines IN NUMBER, p_holds OUT t_invoice_table)
      RETURN NUMBER
      IS
      BEGIN
      RETURN 4;
      END getInvoiceIds;


      End BPEL_INVOICE_SCANNING_EBS;


      Is there anyone who has encountered the same issue? Can any guru show some tips or solution?

      Many thanks!


      Regards,

      Mark