This discussion is archived
8 Replies Latest reply: Nov 9, 2010 10:55 PM by Hussein Sawwan-Oracle RSS

Supplier conversion into R12 giving error at site level(AP_INVALID_TCA_ERR)

811262 Newbie
Currently Being Moderated
Hi All,
I am running "Supplier Sites Open Interface Import" for Supplier Site conversion but standard program is failing with the following error msg: "AP_INVALID_TCA_ERROR".
Can any one please help me how I can fix this issue. Any help will be Gold for me.

Best Regards,
Shaik.
  • 1. Re: Supplier conversion into R12 giving error at site level(AP_INVALID_TCA_ERR)
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Hi,

    Please post the contents of the concurrent request log file here.

    Also, please mention the details of the application release, database version and OS.

    Thanks,
    Hussein
  • 2. Re: Supplier conversion into R12 giving error at site level(AP_INVALID_TCA_ERR)
    811262 Newbie
    Currently Being Moderated
    Hi Hussein,

    OS: Linux.
    DataBase: Oracle 11g
    Application is : Oracle R12.2

    Below is the coucurrent request Log.

    ---------------------------------------------------------------------------
    Payables: Version : 12.0.0

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

    APXSSIMP module: Supplier Sites Open Interface Import
    ---------------------------------------------------------------------------

    Current system time is 09-NOV-2010 02:48:40

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


    +-----------------------------
    | Starting concurrent program execution...
    +-----------------------------

    Arguments
    ------------
    P_WHAT_TO_IMPORT='ALL'
    P_COMMIT_SIZE='50000'
    P_PRINT_EXCEPTIONS='N'
    P_DEBUG_SWITCH='Y'
    P_TRACE_SWITCH='Y'
    ------------

    APPLLCSP Environment Variable set to :

    Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
    American_America.AL32UTF8

    ' '

    Enter Password:
    MSG-00001: After SRWINIT
    MSG-00002: After Get_Company_Name
    MSG-00003: After Get_NLS_Strings
    MSG-00004: After Importing Suppliers
    MSG-00005: After Get_Header_Information
    MSG-00020: After SRWEXIT

    Report Builder: Release 10.1.2.3.0 - Production on Tue Nov 9 02:48:43 2010

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




    ---------------------------------------------------------------------------
    Executing request completion options...

    Output file size:
    2369

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


    Printing output file.
    Request ID : 1446582      
    Number of copies : 0      
    Printer : noprint

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


    Finished executing request completion options.

    ---------------------------------------------------------------------------
    Concurrent request completed successfully
    Current system time is 09-NOV-2010 02:48:54

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



    Best Regards,
    Shaik
  • 3. Re: Supplier conversion into R12 giving error at site level(AP_INVALID_TCA_ERR)
    811262 Newbie
    Currently Being Moderated
    Hi Hussein,

    OS: Linux.
    DataBase: Oracle 11g
    Application is : Oracle R12.2

    Below is the coucurrent request Log.

    ---------------------------------------------------------------------------
    Payables: Version : 12.0.0

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

    APXSSIMP module: Supplier Sites Open Interface Import
    ---------------------------------------------------------------------------

    Current system time is 09-NOV-2010 02:48:40

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


    +-----------------------------
    | Starting concurrent program execution...
    +-----------------------------

    Arguments
    ------------
    P_WHAT_TO_IMPORT='ALL'
    P_COMMIT_SIZE='50000'
    P_PRINT_EXCEPTIONS='N'
    P_DEBUG_SWITCH='Y'
    P_TRACE_SWITCH='Y'
    ------------

    APPLLCSP Environment Variable set to :

    Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
    American_America.AL32UTF8

    ' '

    Enter Password:
    MSG-00001: After SRWINIT
    MSG-00002: After Get_Company_Name
    MSG-00003: After Get_NLS_Strings
    MSG-00004: After Importing Suppliers
    MSG-00005: After Get_Header_Information
    MSG-00020: After SRWEXIT

    Report Builder: Release 10.1.2.3.0 - Production on Tue Nov 9 02:48:43 2010

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




    ---------------------------------------------------------------------------
    Executing request completion options...

    Output file size:
    2369

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


    Printing output file.
    Request ID : 1446582      
    Number of copies : 0      
    Printer : noprint

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


    Finished executing request completion options.

    ---------------------------------------------------------------------------
    Concurrent request completed successfully
    Current system time is 09-NOV-2010 02:48:54

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



    Best Regards,
    Shaik
  • 4. Re: Supplier conversion into R12 giving error at site level(AP_INVALID_TCA_ERR)
    811262 Newbie
    Currently Being Moderated
    Hi Hussein,

    OS: Linux.
    DataBase: Oracle 11g
    Application is : Oracle R12.2

    Below is the coucurrent request Log.

    ---------------------------------------------------------------------------
    Payables: Version : 12.0.0

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

    APXSSIMP module: Supplier Sites Open Interface Import
    ---------------------------------------------------------------------------

    Current system time is 09-NOV-2010 02:48:40

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


    +-----------------------------
    | Starting concurrent program execution...
    +-----------------------------

    Arguments
    ------------
    P_WHAT_TO_IMPORT='ALL'
    P_COMMIT_SIZE='50000'
    P_PRINT_EXCEPTIONS='N'
    P_DEBUG_SWITCH='Y'
    P_TRACE_SWITCH='Y'
    ------------

    APPLLCSP Environment Variable set to :

    Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
    American_America.AL32UTF8

    ' '

    Enter Password:
    MSG-00001: After SRWINIT
    MSG-00002: After Get_Company_Name
    MSG-00003: After Get_NLS_Strings
    MSG-00004: After Importing Suppliers
    MSG-00005: After Get_Header_Information
    MSG-00020: After SRWEXIT

    Report Builder: Release 10.1.2.3.0 - Production on Tue Nov 9 02:48:43 2010

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




    ---------------------------------------------------------------------------
    Executing request completion options...

    Output file size:
    2369

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


    Printing output file.
    Request ID : 1446582      
    Number of copies : 0      
    Printer : noprint

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


    Finished executing request completion options.

    ---------------------------------------------------------------------------
    Concurrent request completed successfully
    Current system time is 09-NOV-2010 02:48:54

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



    Best Regards,
    Shaik
  • 5. Re: Supplier conversion into R12 giving error at site level(AP_INVALID_TCA_ERR)
    811262 Newbie
    Currently Being Moderated
    Hi Hussein,

    OS: Linux.
    DataBase: Oracle 11g
    Application is : Oracle R12.2

    Below is the coucurrent request Log.

    ---------------------------------------------------------------------------
    Payables: Version : 12.0.0

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

    APXSSIMP module: Supplier Sites Open Interface Import
    ---------------------------------------------------------------------------

    Current system time is 09-NOV-2010 02:48:40

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


    +-----------------------------
    | Starting concurrent program execution...
    +-----------------------------

    Arguments
    ------------
    P_WHAT_TO_IMPORT='ALL'
    P_COMMIT_SIZE='50000'
    P_PRINT_EXCEPTIONS='N'
    P_DEBUG_SWITCH='Y'
    P_TRACE_SWITCH='Y'
    ------------

    APPLLCSP Environment Variable set to :

    Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
    American_America.AL32UTF8

    ' '

    Enter Password:
    MSG-00001: After SRWINIT
    MSG-00002: After Get_Company_Name
    MSG-00003: After Get_NLS_Strings
    MSG-00004: After Importing Suppliers
    MSG-00005: After Get_Header_Information
    MSG-00020: After SRWEXIT

    Report Builder: Release 10.1.2.3.0 - Production on Tue Nov 9 02:48:43 2010

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




    ---------------------------------------------------------------------------
    Executing request completion options...

    Output file size:
    2369

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


    Printing output file.
    Request ID : 1446582      
    Number of copies : 0      
    Printer : noprint

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


    Finished executing request completion options.

    ---------------------------------------------------------------------------
    Concurrent request completed successfully
    Current system time is 09-NOV-2010 02:48:54

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



    Best Regards,
    Shaik
  • 6. Re: Supplier conversion into R12 giving error at site level(AP_INVALID_TCA_ERR)
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Hi,
    Concurrent request completed successfully
    I do not see the error message in the log file. And, the above message indicates that the concurrent request completed successfully.

    Thanks,
    Hussein
  • 7. Re: Supplier conversion into R12 giving error at site level(AP_INVALID_TCA_ERR)
    811584 Newbie
    Currently Being Moderated
    Hi,
    Request is completing normal. But it is not populating the data into base table. Error msg is stored in AP_SUPPLIER_INT_REJECTIONS.
    Best Regards,
    Shaik.
  • 8. Re: Supplier conversion into R12 giving error at site level(AP_INVALID_TCA_ERR)
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Shaik,

    Please log a SR, Oracle support should be able to help.

    Thanks,
    Hussein

Legend

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