7 Replies Latest reply: Sep 30, 2013 9:25 AM by Asif Muhammad RSS

    R12 report errors out  - Different Invoice Type

    Ragul Halan

      Hi,


      I customized a seeded oracle report(Invoice Print Selected Invoices) in R12 per our requirement. The issue i have is - concurrent program works only for certain INVOICE TYPES ,when i submit is the prorgam for INVOICE TYPE as "Pro forma"  it errors out. I tried running the seeded oracle conc program and it works fine for all operating units.


      Has anyone seen this issue?


      Below are the details

      RDBMS : 11.2.0.3.0

      Oracle Applications : 12.1.3


      Report that i customized - Invoice Print Selected Invoices.


      Log Error--


      Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing

       

      APPLLCSP Environment Variable set to :

       

      Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

      American_America.UTF8

       

      '.,'

       

      Enter Password:

      MSG-00100: DEBUG: AfterPForm_Trigger +

      MSG-00100: DEBUG: Multi Org established.

      MSG-00100: DEBUG: AfterParam_Procs.Get_Country_Details

      MSG-00100: DEBUG: AfterParam_Procs.Switch_On_Debug

      MSG-00100: DEBUG: AfterParam_Procs.Get_Trx_Number_Low

      MSG-00100: DEBUG: AfterParam_Procs.Get_Trx_Number_High

      MSG-00100: DEBUG: AfterParam_Procs.Get_Tax_Option

      MSG-00103: lp_trx_date_clause = and a.trx_date = a.trx_date

      MSG-00100: DEBUG: BeforeReport_Trigger.Build_Where_Clause

      MSG-00100: DEBUG: P_Choice: SEL

      MSG-00100: DEBUG: Choice is other than ADJ, setting ORDER BY.

      MSG-00100: DEBUG: AfterPForm_Trigger -

      MSG-00100: DEBUG: BeforeReport_Trigger +

      MSG-00100: DEBUG: BeforeReport_Procs.Populate_Printing_Option

      MSG-00100: DEBUG: BeforeReport_Procs.Populate_Tax_Printing_Option

      MSG-00100: DEBUG: BeforeReport_Trigger.Get_Message_Details

      MSG-00100: DEBUG: BeforeReport_Trigger.Get_Org_Profile.

      MSG-00100: DEBUG: Organization Id: 87

      MSG-01000: CP_INSERT:N

      MSG-00100: DEBUG: BeforeReport_Trigger -

      MSG-05000: DEBUG: Trx No... 900021

      REP-1401: '': Fatal PL/SQL error occurred.

      REP-0069: Internal error

      REP-57054: In-process job terminated:Terminated with error:

      REP-1401: MSG-00100: DEBUG: BeforeReport_Trigger +

      MSG-00100: DEBUG: BeforeReport_Procs.Populate_Printing_Option

      MSG-00100: DEBUG: BeforeReport_Procs.Populate_Tax_Printing_Option

      MSG-00100: DEBUG: BeforeReport_Trigger.Get_Message_Details

      MSG-00100: DEBUG: BeforeReport_Trigger.Get_Org_Profile.

      MSG-00100: DEBUG: Organization Id: 87

      MSG-01000: CP_INSERT:N

      MSG-00100: DEBUG: BeforeReport_Trigger -

      MSG-05000: DEBUG: Tr

       

      Report Builder: Release 10.1.2.3.0 - Production on Sun Sep 29 23:11:02 2013

       

      Copyright (c) 1982, 2005, Oracle. All rights reserved.

       

       

      +---------------------------------------------------------------------------+

      Start of log messages from FND_FILE

      +---------------------------------------------------------------------------+

      +---------------------------------------------------------------------------+

      End of log messages from FND_FILE

      +---------------------------------------------------------------------------+

      Program exited with status 1

      Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 574386.

       

      Review your concurrent request log and/or report output file for more detailed information.

       

       

      +---------------------------------------------------------------------------+

      Executing request completion options...

       

      Output file size:

      0

       

      +------------- 1) PUBLISH -------------+

      Disabling requested Output Post Processing. Nothing to process. The output of the request is zero byte.

      +--------------------------------------+

       

       

      Finished executing request completion options.

       

      +---------------------------------------------------------------------------+

      Concurrent request completed

      Current system time is 29-SEP-2013 23:11:07

       

      +---------------------------------------------------------------------------+



      Thanks In Advance

      -Ragul


        • 1. Re: R12 report errors out  - Different Invoice Type
          Asif Muhammad

          Hi Ragul,

           

          Please check the OPP log file for more information, plus also try to run the report in reports builder and confirm you can run the report without an issue. This will ease us to narrow the troubleshooting process.

           

          Thanks &

          Best Regards,

          • 2. Re: R12 report errors out  - Different Invoice Type
            Ragul Halan

            Hi Asif,

             

            I tried Viewing the OPP log, but there is nothing in it and the log file size is 0KB.

             

            What might be the issue? I am confused.

             

            Found one thing, when you see the above log file you can find the line

             

            'MSG-05000: DEBUG: Trx No... 900021'


            This is the first Formula column within the Data model, after this the reports is ending in error. How do i find the Root Cause of this error.

             

            Thanks

            • 3. Re: R12 report errors out  - Different Invoice Type
              Asif Muhammad

              Hi,

               

              REP-1401: '': Fatal PL/SQL error occurred.

              REP-0069: Internal error

              REP-57054: In-process job terminated:Terminated with error:

              I suggest you run the report using report builder and check for any errors as this will give you a better idea in troubleshooting the issue (as this is customized report)

               

              Thanks &

              Best Regards,

              • 4. Re: R12 report errors out  - Different Invoice Type
                Ragul Halan

                Hi,

                 

                Instead Running it from the Report builder, I enables the Debug flag and ran the report, I got the below log.. do u have any idea what might be the issue is?

                 

                I have also attached the seeded programs log file.

                 

                ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                Custom Program log ---->

                 

                +---------------------------------------------------------------------------+

                Receivables: Version : 12.0.0

                 

                 

                Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

                 

                 

                XXRAXINV_SELE module: Travelzoo Invoice Print Selected Invoices-Child

                +---------------------------------------------------------------------------+

                 

                 

                Current system time is 30-SEP-2013 05:57:05

                 

                 

                +---------------------------------------------------------------------------+

                 

                 

                 

                 

                +-----------------------------

                | Starting concurrent program execution...

                +-----------------------------

                 

                 

                Arguments

                ------------

                p_order_by='TRX_NUMBER'

                p_trx_number_low='900001'

                p_trx_number_high='900001'

                p_open_invoice='N'

                p_check_for_taxyn='N'

                p_choice='SEL'

                p_header_pages='1'

                p_debug_flag='Y'

                p_message_level='10'

                P_RESEND='N'

                ------------

                 

                 

                Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing

                 

                 

                APPLLCSP Environment Variable set to :

                 

                 

                Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

                American_America.UTF8

                 

                 

                '.,'

                 

                 

                Enter Password:

                MSG-00100: DEBUG:  AfterPForm_Trigger +

                MSG-00100: DEBUG:  Multi Org established.

                MSG-00100: DEBUG:  AfterParam_Procs.Get_Country_Details

                MSG-00100: DEBUG:  Get_Country_Description.

                MSG-00100: DEBUG:  AfterParam_Procs.Switch_On_Debug

                MSG-00100: Running in debug mode

                MSG-00100: DEBUG:  AfterParam_Procs.Get_Trx_Number_Low

                MSG-00100: DEBUG:  AfterParam_Procs.Get_Trx_Number_High

                MSG-00100: DEBUG:  AfterParam_Procs.Get_Tax_Option

                MSG-00103: lp_trx_date_clause =  and a.trx_date = a.trx_date

                MSG-00100: DEBUG:  BeforeReport_Trigger.Build_Where_Clause

                MSG-00100: DEBUG:  P_Choice:  SEL

                MSG-00500: DEBUG:  About to build WHERE clause.

                MSG-00500: DEBUG:  WHERE clause built.

                MSG-00100: DEBUG:  Choice is other than ADJ, setting ORDER BY.

                MSG-00500: DEBUG:  Table 1:          AR_ADJUSTMENTS                         COM_ADJ,

                        AR_PAYMENT_SCHEDULES                   P,

                        RA_CUST_TRX_LINE_GL_DIST               REC,

                        RA_CUSTOMER_TRX                        A,

                        HZ_CUST_ACCOUNTS                       B,

                        RA_TERMS                               T,

                        RA_TERMS_LINES                         TL,  

                        RA_CUST_TRX_TYPES                      TYPES,

                        AR_LOOKUPS                             L_TYPES,

                        HZ_PARTIES                     PARTY,

                        HZ_CUST_ACCT_SITES                     A_BILL,

                        HZ_PARTY_SITES                         PARTY_SITE,

                        HZ_LOCATIONS                           LOC,

                        HZ_CUST_SITE_USES                      U_BILL

                 

                 

                MSG-00500: DEBUG:  Table 2:          RA_TERMS_LINES                         TL,  

                        RA_CUST_TRX_TYPES                      TYPES,

                        AR_LOOKUPS                             L_TYPES,

                  HZ_CUST_ACCOUNTS                       B,

                        HZ_PARTIES                     PARTY,

                        HZ_CUST_SITE_USES                      U_BILL,

                        HZ_CUST_ACCT_SITES                     A_BILL,

                        HZ_PARTY_SITES                         PARTY_SITE,

                        HZ_LOCATIONS                           LOC,

                        AR_ADJUSTMENTS                         COM_ADJ,

                        RA_CUSTOMER_TRX                        A,

                        AR_PAYMENT_SCHEDULES                   P,

                        RA_TERMS                               T

                 

                 

                MSG-00500: DEBUG:  Where 1:  A.BILL_TO_CUSTOMER_ID = B.CUST_ACCOUNT_ID

                AND REC.CUSTOMER_TRX_ID = A.CUSTOMER_TRX_ID

                AND REC.LATEST_REC_FLAG = 'Y'

                AND REC.ACCOUNT_CLASS   = 'REC'

                AND P.PAYMENT_SCHEDULE_ID + DECODE(P.CLASS,

                                                   'INV', 0,

                                                        '')

                             = COM_ADJ.PAYMENT_SCHEDULE_ID(+)

                AND COM_ADJ.SUBSEQUENT_TRX_ID IS NULL

                AND 'C'    = COM_ADJ.ADJUSTMENT_TYPE(+)

                AND A.COMPLETE_FLAG = 'Y'

                AND A.CUST_TRX_TYPE_ID = TYPES.CUST_TRX_TYPE_ID

                AND L_TYPES.LOOKUP_TYPE = 'INV/CM/ADJ'

                AND A.PRINTING_OPTION IN ('PRI', 'REP')

                AND L_TYPES.LOOKUP_CODE =

                DECODE( TYPES.TYPE,'DEP','INV', TYPES.TYPE)

                AND NVL(P.TERMS_SEQUENCE_NUMBER,nvl(TL.SEQUENCE_NUM,0))=nvl(TL.SEQUENCE_NUM,nvl(p.terms_sequence_number,0))

                AND DECODE(P.PAYMENT_SCHEDULE_ID,'',0, NVL(T.PRINTING_LEAD_DAYS,0))=0

                AND A.BILL_TO_SITE_USE_ID = U_BILL.SITE_USE_ID

                AND U_BILL.CUST_ACCT_SITE_ID = A_BILL.CUST_ACCT_SITE_ID

                AND A_BILL.party_site_id = party_site.party_site_id

                AND B.PARTY_ID = PARTY.PARTY_ID

                AND loc.location_id = party_site.location_id

                AND NVL(LOC.LANGUAGE,'US') = 'US'

                AND A.TERM_ID = TL.TERM_ID(+)

                AND A.TERM_ID = T.TERM_ID(+)

                AND A.CUSTOMER_TRX_ID = P.CUSTOMER_TRX_ID(+)

                MSG-00500: DEBUG:  Where 2:  A.BILL_TO_CUSTOMER_ID = B.CUST_ACCOUNT_ID

                AND P.PAYMENT_SCHEDULE_ID + DECODE(P.CLASS,

                                                   'INV', 0,

                                                        '')

                             = COM_ADJ.PAYMENT_SCHEDULE_ID(+)

                AND COM_ADJ.SUBSEQUENT_TRX_ID IS NULL

                AND 'C'    = COM_ADJ.ADJUSTMENT_TYPE(+)

                AND A.COMPLETE_FLAG = 'Y'

                AND A.CUSTOMER_TRX_ID = P.CUSTOMER_TRX_ID

                AND A.CUST_TRX_TYPE_ID = TYPES.CUST_TRX_TYPE_ID

                AND L_TYPES.LOOKUP_TYPE = 'INV/CM/ADJ'

                AND A.PRINTING_OPTION IN ('PRI', 'REP')

                AND L_TYPES.LOOKUP_CODE =

                DECODE( TYPES.TYPE,'DEP','INV', TYPES.TYPE)

                AND NVL(T.PRINTING_LEAD_DAYS,0) > 0

                AND A.BILL_TO_SITE_USE_ID = U_BILL.SITE_USE_ID

                AND U_BILL.CUST_ACCT_SITE_ID = A_BILL.CUST_ACCT_SITE_ID

                AND A_BILL.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID

                AND B.PARTY_ID = PARTY.PARTY_ID

                AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

                AND NVL(LOC.LANGUAGE,'US') = 'US'

                AND NVL(P.TERMS_SEQUENCE_NUMBER,TL.SEQUENCE_NUM)=TL.SEQUENCE_NUM

                AND T.TERM_ID = P.TERM_ID

                AND TL.TERM_ID(+) = T.TERM_ID

                MSG-00100: DEBUG:  AfterPForm_Trigger -

                MSG-00100: DEBUG:  BeforeReport_Trigger +

                MSG-00100: DEBUG:  BeforeReport_Procs.Populate_Printing_Option

                MSG-00100: DEBUG:  BeforeReport_Procs.Populate_Tax_Printing_Option

                MSG-00100: DEBUG:  BeforeReport_Trigger.Get_Message_Details

                MSG-00100: DEBUG:  BeforeReport_Trigger.Get_Org_Profile.

                MSG-00100: DEBUG:  Organization Id:  87

                MSG-01000: CP_INSERT:N

                MSG-00100: DEBUG:  BeforeReport_Trigger -

                MSG-05000: DEBUG:  Trx No... 900001

                MSG-00100: DEBUG:  Get_Country_Description.

                MSG-00100: DEBUG:  Get_Country_Description.

                MSG-05000: DEBUG:  Remit To Address....

                MSG-05000: DEBUG:  Address Style:   

                MSG-05000: DEBUG:  Address 1:        Avenida Diagonal 640

                MSG-05000: DEBUG:  Address 2:        Planta 6

                MSG-05000: DEBUG:  Address 3:       

                MSG-05000: DEBUG:  Address 4:       

                MSG-05000: DEBUG:  City:             Barcelona

                MSG-05000: DEBUG:  County:          

                MSG-05000: DEBUG:  State:           

                MSG-05000: DEBUG:  Province:        

                MSG-05000: DEBUG:  Postal Code:      08017

                MSG-05000: DEBUG:  Territory:       

                MSG-05000: DEBUG:  Country_Code:     ES

                MSG-05000: DEBUG:  Customer Name:   

                MSG-05000: DEBUG:  Bill To:         

                MSG-05000: DEBUG:  First Name:      

                MSG-05000: DEBUG:  Last Name:       

                MSG-05000: DEBUG:  Mail Stop:       

                MSG-05000: DEBUG:  Country Code:     ES

                MSG-05000: DEBUG:  Country Desc:     Spain

                MSG-05000: DEBUG:  Print Home Flag:  Y

                MSG-05000: DEBUG:  Width:            40

                MSG-05000: DEBUG:  Height Min:       6

                MSG-05000: DEBUG:  Height Max:       6

                MSG-05000: DEBUG:  Remit To Formatted...   Avenida Diagonal 640

                Planta 6

                08017 Barcelona

                Spain

                REP-1401: '': Fatal PL/SQL error occurred.

                REP-0069: Internal error

                REP-57054: In-process job terminated:Terminated with error:

                REP-1401: MSG-00100: DEBUG:  BeforeReport_Trigger +

                MSG-00100: DEBUG:  BeforeReport_Procs.Populate_Printing_Option

                MSG-00100: DEBUG:  BeforeReport_Procs.Populate_Tax_Printing_Option

                MSG-00100: DEBUG:  BeforeReport_Trigger.Get_Message_Details

                MSG-00100: DEBUG:  BeforeReport_Trigger.Get_Org_Profile.

                MSG-00100: DEBUG:  Organization Id:  87

                MSG-01000: CP_INSERT:N

                MSG-00100: DEBUG:  BeforeReport_Trigger -

                MSG-05000: DEBUG:  Tr

                 

                 

                Report Builder: Release 10.1.2.3.0 - Production on Mon Sep 30 05:57:06 2013

                 

                 

                Copyright (c) 1982, 2005, Oracle.  All rights reserved.

                 

                 

                 

                 

                +---------------------------------------------------------------------------+

                Start of log messages from FND_FILE

                +---------------------------------------------------------------------------+

                +---------------------------------------------------------------------------+

                End of log messages from FND_FILE

                +---------------------------------------------------------------------------+

                Program exited with status 1

                Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 574430.

                 

                 

                Review your concurrent request log and/or report output file for more detailed information.

                 

                 

                 

                 

                +---------------------------------------------------------------------------+

                Executing request completion options...

                 

                 

                Output file size:

                0

                 

                 

                +------------- 1) PUBLISH -------------+

                Disabling requested Output Post Processing.  Nothing to process.  The output of the request is zero byte.

                +--------------------------------------+

                 

                 

                 

                 

                Finished executing request completion options.

                 

                 

                +---------------------------------------------------------------------------+

                Concurrent request completed

                Current system time is 30-SEP-2013 05:57:11

                 

                 

                +---------------------------------------------------------------------------+

                 

                ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                Seeded Program log ---->

                 

                +---------------------------------------------------------------------------+

                Receivables: Version : 12.0.0

                 

                 

                Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

                 

                 

                RAXINV_SEL module: Invoice Print Selected Invoices

                +---------------------------------------------------------------------------+

                 

                 

                Current system time is 30-SEP-2013 06:12:05

                 

                 

                +---------------------------------------------------------------------------+

                 

                 

                 

                 

                +-----------------------------

                | Starting concurrent program execution...

                +-----------------------------

                 

                 

                Arguments

                ------------

                p_order_by='TRX_NUMBER'

                p_trx_number_low='900001'

                p_trx_number_high='900001'

                p_open_invoice='N'

                p_check_for_taxyn='N'

                p_choice='SEL'

                p_header_pages='1'

                p_debug_flag='Y'

                p_message_level='10'

                ------------

                 

                 

                APPLLCSP Environment Variable set to :

                 

                 

                Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

                American_America.UTF8

                 

                 

                '.,'

                 

                 

                Enter Password:

                MSG-00100: DEBUG:  AfterPForm_Trigger +

                MSG-00100: DEBUG:  Multi Org established.

                MSG-00100: DEBUG:  AfterParam_Procs.Get_Country_Details

                MSG-00100: DEBUG:  Get_Country_Description.

                MSG-00100: DEBUG:  AfterParam_Procs.Switch_On_Debug

                MSG-00100: Running in debug mode

                MSG-00100: DEBUG:  AfterParam_Procs.Get_Trx_Number_Low

                MSG-00100: DEBUG:  AfterParam_Procs.Get_Trx_Number_High

                MSG-00100: DEBUG:  AfterParam_Procs.Get_Tax_Option

                MSG-00103: lp_trx_date_clause =  and a.trx_date = a.trx_date

                MSG-00100: DEBUG:  BeforeReport_Trigger.Build_Where_Clause

                MSG-00100: DEBUG:  P_Choice:  SEL

                MSG-00500: DEBUG:  About to build WHERE clause.

                MSG-00500: DEBUG:  WHERE clause built.

                MSG-00100: DEBUG:  Choice is other than ADJ, setting ORDER BY.

                MSG-00500: DEBUG:  Table 1:          AR_ADJUSTMENTS                         COM_ADJ,

                        AR_PAYMENT_SCHEDULES                   P,

                        RA_CUST_TRX_LINE_GL_DIST               REC,

                        RA_CUSTOMER_TRX                        A,

                        HZ_CUST_ACCOUNTS                       B,

                        RA_TERMS                               T,

                        RA_TERMS_LINES                         TL,  

                        RA_CUST_TRX_TYPES                      TYPES,

                        AR_LOOKUPS                             L_TYPES,

                        HZ_PARTIES                     PARTY,

                        HZ_CUST_ACCT_SITES                     A_BILL,

                        HZ_PARTY_SITES                         PARTY_SITE,

                        HZ_LOCATIONS                           LOC,

                        HZ_CUST_SITE_USES                      U_BILL

                 

                 

                MSG-00500: DEBUG:  Table 2:          RA_TERMS_LINES                         TL,  

                        RA_CUST_TRX_TYPES                      TYPES,

                        AR_LOOKUPS                             L_TYPES,

                  HZ_CUST_ACCOUNTS                       B,

                        HZ_PARTIES                     PARTY,

                        HZ_CUST_SITE_USES                      U_BILL,

                        HZ_CUST_ACCT_SITES                     A_BILL,

                        HZ_PARTY_SITES                         PARTY_SITE,

                        HZ_LOCATIONS                           LOC,

                        AR_ADJUSTMENTS                         COM_ADJ,

                        RA_CUSTOMER_TRX                        A,

                        AR_PAYMENT_SCHEDULES                   P,

                        RA_TERMS                               T

                 

                 

                MSG-00500: DEBUG:  Where 1:  A.BILL_TO_CUSTOMER_ID = B.CUST_ACCOUNT_ID

                AND REC.CUSTOMER_TRX_ID = A.CUSTOMER_TRX_ID

                AND REC.LATEST_REC_FLAG = 'Y'

                AND REC.ACCOUNT_CLASS   = 'REC'

                AND P.PAYMENT_SCHEDULE_ID + DECODE(P.CLASS,

                                                   'INV', 0,

                                                        '')

                             = COM_ADJ.PAYMENT_SCHEDULE_ID(+)

                AND COM_ADJ.SUBSEQUENT_TRX_ID IS NULL

                AND 'C'    = COM_ADJ.ADJUSTMENT_TYPE(+)

                AND A.COMPLETE_FLAG = 'Y'

                AND A.CUST_TRX_TYPE_ID = TYPES.CUST_TRX_TYPE_ID

                AND L_TYPES.LOOKUP_TYPE = 'INV/CM/ADJ'

                AND A.PRINTING_OPTION IN ('PRI', 'REP')

                AND L_TYPES.LOOKUP_CODE =

                DECODE( TYPES.TYPE,'DEP','INV', TYPES.TYPE)

                AND NVL(P.TERMS_SEQUENCE_NUMBER,nvl(TL.SEQUENCE_NUM,0))=nvl(TL.SEQUENCE_NUM,nvl(p.terms_sequence_number,0))

                AND DECODE(P.PAYMENT_SCHEDULE_ID,'',0, NVL(T.PRINTING_LEAD_DAYS,0))=0

                AND A.BILL_TO_SITE_USE_ID = U_BILL.SITE_USE_ID

                AND U_BILL.CUST_ACCT_SITE_ID = A_BILL.CUST_ACCT_SITE_ID

                AND A_BILL.party_site_id = party_site.party_site_id

                AND B.PARTY_ID = PARTY.PARTY_ID

                AND loc.location_id = party_site.location_id

                AND NVL(LOC.LANGUAGE,'US') = 'US'

                AND A.TERM_ID = TL.TERM_ID(+)

                AND A.TERM_ID = T.TERM_ID(+)

                AND A.CUSTOMER_TRX_ID = P.CUSTOMER_TRX_ID(+)

                MSG-00500: DEBUG:  Where 2:  A.BILL_TO_CUSTOMER_ID = B.CUST_ACCOUNT_ID

                AND P.PAYMENT_SCHEDULE_ID + DECODE(P.CLASS,

                                                   'INV', 0,

                                                        '')

                             = COM_ADJ.PAYMENT_SCHEDULE_ID(+)

                AND COM_ADJ.SUBSEQUENT_TRX_ID IS NULL

                AND 'C'    = COM_ADJ.ADJUSTMENT_TYPE(+)

                AND A.COMPLETE_FLAG = 'Y'

                AND A.CUSTOMER_TRX_ID = P.CUSTOMER_TRX_ID

                AND A.CUST_TRX_TYPE_ID = TYPES.CUST_TRX_TYPE_ID

                AND L_TYPES.LOOKUP_TYPE = 'INV/CM/ADJ'

                AND A.PRINTING_OPTION IN ('PRI', 'REP')

                AND L_TYPES.LOOKUP_CODE =

                DECODE( TYPES.TYPE,'DEP','INV', TYPES.TYPE)

                AND NVL(T.PRINTING_LEAD_DAYS,0) > 0

                AND A.BILL_TO_SITE_USE_ID = U_BILL.SITE_USE_ID

                AND U_BILL.CUST_ACCT_SITE_ID = A_BILL.CUST_ACCT_SITE_ID

                AND A_BILL.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID

                AND B.PARTY_ID = PARTY.PARTY_ID

                AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

                AND NVL(LOC.LANGUAGE,'US') = 'US'

                AND NVL(P.TERMS_SEQUENCE_NUMBER,TL.SEQUENCE_NUM)=TL.SEQUENCE_NUM

                AND T.TERM_ID = P.TERM_ID

                AND TL.TERM_ID(+) = T.TERM_ID

                MSG-00100: DEBUG:  AfterPForm_Trigger -

                MSG-00100: DEBUG:  BeforeReport_Trigger +

                MSG-00100: DEBUG:  BeforeReport_Procs.Populate_Printing_Option

                MSG-00100: DEBUG:  BeforeReport_Procs.Populate_Tax_Printing_Option

                MSG-00100: DEBUG:  BeforeReport_Trigger.Get_Message_Details

                MSG-00100: DEBUG:  BeforeReport_Trigger.Get_Org_Profile.

                MSG-00100: DEBUG:  Organization Id:  87

                MSG-00100: DEBUG:  BeforeReport_Trigger -

                MSG-05000: DEBUG:  Trx No... 900001

                MSG-00100: DEBUG:  Get_Country_Description.

                MSG-00010: 05:38 1 Transaction: 900001

                MSG-00100: DEBUG:  Get_Country_Description.

                MSG-05000: DEBUG:  Remit To Address....

                MSG-05000: DEBUG:  Address Style:   

                MSG-05000: DEBUG:  Address 1:        Avenida Diagonal 640

                MSG-05000: DEBUG:  Address 2:        Planta 6

                MSG-05000: DEBUG:  Address 3:       

                MSG-05000: DEBUG:  Address 4:       

                MSG-05000: DEBUG:  City:             Barcelona

                MSG-05000: DEBUG:  County:          

                MSG-05000: DEBUG:  State:           

                MSG-05000: DEBUG:  Province:        

                MSG-05000: DEBUG:  Postal Code:      08017

                MSG-05000: DEBUG:  Territory:       

                MSG-05000: DEBUG:  Country_Code:     ES

                MSG-05000: DEBUG:  Customer Name:   

                MSG-05000: DEBUG:  Bill To:         

                MSG-05000: DEBUG:  First Name:      

                MSG-05000: DEBUG:  Last Name:       

                MSG-05000: DEBUG:  Mail Stop:       

                MSG-05000: DEBUG:  Country Code:     ES

                MSG-05000: DEBUG:  Country Desc:     Spain

                MSG-05000: DEBUG:  Print Home Flag:  Y

                MSG-05000: DEBUG:  Width:            40

                MSG-05000: DEBUG:  Height Min:       6

                MSG-05000: DEBUG:  Height Max:       6

                MSG-05000: DEBUG:  Remit To Formatted...   Avenida Diagonal 640

                Planta 6

                08017 Barcelona

                Spain

                MSG-05000: DEBUG:  Bill To Address....

                MSG-05000: DEBUG:  Address Style:   

                MSG-05000: DEBUG:  Address 1:        Via on Messana 2

                MSG-05000: DEBUG:  Address 2:       

                MSG-05000: DEBUG:  Address 3:       

                MSG-05000: DEBUG:  Address 4:       

                MSG-05000: DEBUG:  City:             Alcamo

                MSG-05000: DEBUG:  County:          

                MSG-05000: DEBUG:  State:           

                MSG-05000: DEBUG:  Province:        

                MSG-05000: DEBUG:  Postal Code:      91011

                MSG-05000: DEBUG:  Territory:       

                MSG-05000: DEBUG:  Country_Code:     IT

                MSG-05000: DEBUG:  Customer Name:    Sea Group SRL - Hotel La Battigia-CRP2-ES1

                MSG-05000: DEBUG:  Bill To:         

                MSG-05000: DEBUG:  First Name:      

                MSG-05000: DEBUG:  Last Name:       

                MSG-05000: DEBUG:  Mail Stop:       

                MSG-05000: DEBUG:  Country Code:     ES

                MSG-05000: DEBUG:  Country Desc:     Spain

                MSG-05000: DEBUG:  Print Home Flag:  Y

                MSG-05000: DEBUG:  Width:            60

                MSG-05000: DEBUG:  Height Min:       8

                MSG-05000: DEBUG:  Height Max:       8

                MSG-05000: DEBUG:  Bill To Formatted... Attn: Accounts Payable

                Sea Group SRL - Hotel La Battigia-CRP2-ES1

                Via on Messana 2

                Alcamo 91011

                Italy

                 

                 

                Report Builder: Release 10.1.2.3.0 - Production on Mon Sep 30 06:12:06 2013

                 

                 

                Copyright (c) 1982, 2005, Oracle.  All rights reserved.

                 

                 

                 

                 

                +---------------------------------------------------------------------------+

                Start of log messages from FND_FILE

                +---------------------------------------------------------------------------+

                +---------------------------------------------------------------------------+

                End of log messages from FND_FILE

                +---------------------------------------------------------------------------+

                 

                 

                 

                 

                +---------------------------------------------------------------------------+

                Executing request completion options...

                 

                 

                Output file size:

                4284

                 

                 

                +------------- 1) PRINT   -------------+

                 

                 

                 

                 

                Printing output file.

                               Request ID : 574432

                         Number of copies : 0

                                  Printer : noprint

                 

                 

                +--------------------------------------+

                 

                 

                 

                 

                Finished executing request completion options.

                 

                 

                +---------------------------------------------------------------------------+

                Concurrent request completed successfully

                Current system time is 30-SEP-2013 06:12:09

                 

                 

                +---------------------------------------------------------------------------+

                 

                Thanks

                • 5. Re: R12 report errors out  - Different Invoice Type
                  Asif Muhammad

                  Hi,

                   

                  The debug log file only shows generic errors. Was this report working fine before? is this report working with other parameter values?

                   

                  Also check whether there are any invalid objects.

                   

                  Thanks &

                  Best regards,

                  • 6. Re: R12 report errors out  - Different Invoice Type
                    Ragul Halan

                    Hi,

                     

                    Was this report working fine before?

                    -->Yes, it was and is working fine, but only erroring out only for certain parameters, say for invoice type as "Pro forma".

                     

                    check whether there are any invalid objects.

                    -->No there is no invalid objects, all are valid

                     

                     

                    Thanks,

                    • 7. Re: R12 report errors out  - Different Invoice Type
                      Asif Muhammad

                      Hi,

                       

                      Was this report working fine before?

                      Yes, it was and is working fine, but only erroring out only for certain parameters, say for invoice type as "Pro forma".

                      This probably means the report is unable to handle certain exception and as far as i know the development team will have to look into this report running the report with the erroring parameter values.

                       

                      Thanks &

                      Best Regards,