This discussion is archived
7 Replies Latest reply: Sep 30, 2013 7:25 AM by Asif Muhammad RSS

R12 report errors out  - Different Invoice Type

Ragul Halan Newbie
Currently Being Moderated

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 Guru
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Guru
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Guru
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Guru
    Currently Being Moderated

    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,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points