5 Replies Latest reply on Dec 2, 2015 6:04 AM by 2679576

    REP-3000: Erreur interne au démarrage de Oracle Toolkit

    2679576

      Hi,

      i worked a custom report. When i launched it on a short period, it finished correctly but when i launched it on a long period it stays one hour and a half and finished in yellow with this error:

      Spawned Process 20351

      REP-3000: Erreur interne au démarrage de Oracle Toolkit.

      I exectuded this request in oracle sql developer, it works. Please how could i identify the problem?

        • 1. Re: REP-3000: Erreur interne au démarrage de Oracle Toolkit
          Srini Chavali-Oracle

          Pl post OS, database and EBS versions. There could be many reasons for this error.

           

          MOS Doc 200474.1

          • 2. Re: REP-3000: Erreur interne au démarrage de Oracle Toolkit
            Hussein Sawwan-Oracle

            Do you hit the same error with seeded reports or just with this custom one?

             

            11i-12 How To Perform Quick Checks for REP-3000: Internal Error Starting Oracle Toolkit (Doc ID 364838.1)

            Troubleshooting Tips for REP-3000 Error when Running E-Business Suite PDF/POSTSCRIPT/HTML Reports (Doc ID 207532.1)

             

            Please also see old threads for similar discussion -- https://community.oracle.com/search.jspa?q=REP-3000+AND+Custom

             

            Thanks,

            Hussein

            • 3. Re: REP-3000: Erreur interne au démarrage de Oracle Toolkit
              2679576

              this error appears only when i lauched this custom report for a long period in the parameter, when i choose a short period in the parameter it finished correctly

              • 4. Re: REP-3000: Erreur interne au démarrage de Oracle Toolkit
                Hussein Sawwan-Oracle

                You will need to go through the links/docs referenced above to troubleshoot the issue.

                 

                Thanks,

                Hussein

                • 5. Re: REP-3000: Erreur interne au démarrage de Oracle Toolkit
                  2679576

                  Hi,

                  I think it 's a problem of optimatization. Could this problem causes the end of the report in yellow?i work on EBS version 11i. Please can you help me to optimize the request because when i launched the report in a long period it stays one hour and a half

                  select distinct CT.customer_trx_id ID_CLIENT,

                  RAC_BILL_PARTY.PARTY_NAME nom_client,

                  RAC_BILL.ACCOUNT_NUMBER code_client,

                  RAA_BILL_LOC.ADDRESS1|| ' '|| RAA_BILL_LOC.ADDRESS3 adresse_client,

                  RAC_BILL_PARTY.jgzz_fiscal_code matricule_fiscale,

                  CT.BILL_TO_SITE_USE_ID LIEU,

                  CT.TERM_DUE_DATE date_echeance,

                  CT.TRX_NUMBER NUMERO_FACTURE,

                  CT.INVOICE_CURRENCY_CODE DEVICE,

                  CT.exchange_rate COURS,

                  CT.TRX_DATE DATE_FACTURE,

                  GD.GL_DATE DATE_GL,

                  decode(CTT.TYPE,'INV','Facture','DM','Note de débit','CM','Avoir','GUAR','Accord-client','DEP','Acompte','CB','Reliquat') classe_facture,

                  CTT.NAME type_facture,

                  CT.ATTRIBUTE1 OBJECT_CONTRAT,

                  CT.ATTRIBUTE2 REF_PO,

                  CT.ATTRIBUTE3 REF_RECEPTION,

                  CT.ATTRIBUTE4 || ' ' ||CT.ATTRIBUTE5 DOMAINE_BANCAIRE,   

                  CT.ATTRIBUTE6 REF_ATTESTATION_TVA,

                  CT.ATTRIBUTE8 CODE_PROJET,

                  CT.ATTRIBUTE9 Montant_TVA_suspension,

                  RAT.NAME conditions_reg

                  --,

                  --nvl(line.quantity_invoiced,nvl(line.quantity_credited, line.quantity_ordered))*line.unit_selling_price montant

                  --line.EXTENDED_AMOUNT,

                   

                   

                  from RA_CUSTOMER_TRX_ALL CT,

                  RA_CUST_TRX_LINE_GL_DIST_ALL GD,

                  ra_cust_trx_types_all CTT,

                  HZ_LOCATIONS RAA_BILL_LOC,

                  HZ_PARTY_SITES RAA_BILL_PS,

                  hz_cust_acct_sites_all RAA_BILL,

                  hz_cust_site_uses_all SU_BILL,

                  HZ_PARTIES RAC_BILL_PARTY,

                  HZ_CUST_ACCOUNTS RAC_BILL,

                  RA_TERMS RAT--,

                  --ra_customer_trx_lines_all line

                  where CT.CUSTOMER_TRX_ID                = GD.CUSTOMER_TRX_ID

                  AND CT.CUST_TRX_TYPE_ID                 = CTT.CUST_TRX_TYPE_ID

                  /*AND 'REC'                               = GD.ACCOUNT_CLASS

                  AND 'Y'                                 = GD.LATEST_REC_FLAG

                  AND CTT.TYPE                           <> 'BR'

                  */

                  AND RAA_BILL_LOC.LOCATION_ID            = RAA_BILL_PS.LOCATION_ID

                  AND RAA_BILL.PARTY_SITE_ID              = RAA_BILL_PS.PARTY_SITE_ID

                  AND SU_BILL.CUST_ACCT_SITE_ID           = RAA_BILL.CUST_ACCT_SITE_ID

                  AND CT.BILL_TO_SITE_USE_ID              = SU_BILL.SITE_USE_ID

                  AND CT.BILL_TO_CUSTOMER_ID              = RAC_BILL.CUST_ACCOUNT_ID

                  AND RAC_BILL.PARTY_ID                   = RAC_BILL_PARTY.PARTY_ID

                  --and CT.TRX_NUMBER = nvl(:p_invoice_num,CT.TRX_NUMBER)

                  /*and (CT.TRX_DATE between :p_fact_inf and :p_fact_sup

                  or GD.GL_DATE between :p_gl_inf and :p_gl_sup)*/

                  --and GD.GL_DATE <= :p_gl_sup

                  and GD.GL_DATE between :p_gl_inf and :p_gl_sup

                  and CT.TERM_ID                          = RAT.TERM_ID(+)

                  --and CT.CUSTOMER_TRX_ID =line.CUSTOMER_TRX_ID

                  --AND line.line_type NOT LIKE 'TAX'

                  --and GD.CUSTOMER_TRX_LINE_ID   = line.CUSTOMER_TRX_LINE_ID(+)

                  --and line.ATTRIBUTE1 is null

                  --and line.ATTRIBUTE2 is null

                  --and lower(line.DESCRIPTION)  NOT like '%timbre%'

                  AND GD.cust_trx_line_gl_dist_id IN

                    (SELECT to_number(NVL(gje.reference_3,0))

                    FROM gl_je_lines gje

                    WHERE reference_10  ='RA_CUST_TRX_LINE_GL_DIST'

                    AND gje.reference_4 = CT.trx_number

                    )