8 Replies Latest reply: Nov 10, 2010 12:55 AM by Hussein Sawwan-Oracle RSS

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

    811262
      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
          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
            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
              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
                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
                  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
                    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
                      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
                        Shaik,

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

                        Thanks,
                        Hussein