6 Replies Latest reply on Apr 14, 2011 9:54 PM by 850188

    "Import Price Catalogs" fails with RATE not valid

    mamit
      Importing BLANKET using "Import Price Catalogs" but it fails with Error RATE cannot be null, IF I pass rate it fails with RATE not valid.

      CASE#1
      po_headers_interface
      rate_type: Corporate
      Rate: 6.5
      rate_date: xx-xx-xxxx ( same as PO creation date)

      CASE#2
      po_headers_interface
      rate_type: NULL
      Rate: NULL
      rate_date: NULL

      PO currency is USD but its a china PO. ORG currency is USD.

      Any help is appreciated.
      Thanks
        • 1. Re: "Import Price Catalogs" fails with RATE not valid
          Hussein Sawwan-Oracle
          Please mention the details of the application release, database version and OS.

          Also, please post the contents of the concurrent request log file here.

          Thanks,
          Hussein
          • 2. Re: "Import Price Catalogs" fails with RATE not valid
            S.PDASH
            Hi
            You are getting this error b'coz in GL, the corporate (Rate_type) rate is not defined for the period/or for a particular date (rate_date). Consult your GL consultant for this issue.. You won't get error once he defines the corporate rate for the period in which you want your PO conversion to happen.

            CASE#1
            po_headers_interface
            rate_type: Corporate
            Rate: 6.5
            rate_date: xx-xx-xxxx ( same as PO creation date)

            Ans : Define the Corporate rate for the rate_date : xx-xx-xxxx

            CASE#2
            po_headers_interface
            rate_type: NULL
            Rate: NULL
            rate_date: NULL

            Ans : Rate_type should not be null when the trx currency is other than primary currency.. You can take spot/User Rate_type of your own... Populate Rate_type as: User, Rate : 6.5, rate_date: xx-xx-xxxx and try case#2.

            Hope this helps.

            Kind Regards,
            S.P DASH
            • 3. Re: "Import Price Catalogs" fails with RATE not valid
              mamit
              RDBMS : 11.1.0.7.0
              Oracle Applications : 12.1.2
              OS: WIN 7

              Log File:


              ---------------------------------------------------------------------------
              Purchasing: Version : 12.0.0

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

              POXPDOI module: Import Price Catalogs
              ---------------------------------------------------------------------------

              Current system time is 13-APR-2011 13:23:43

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


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

              Arguments
              ------------

              Blanket

              N
              N
              APPROVED



              N
              Y



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

              ---------------------------------------------------------------------------
              Start of log messages from FND_FILE
              ---------------------------------------------------------------------------
              To get the log messages for PDOI, please use the following id to query against FND_LOG_MESSAGES table:
              AUDSID = 36565489
              ---------------------------------------------------------------------------
              End of log messages from FND_FILE
              ---------------------------------------------------------------------------


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

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


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

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


              Finished executing request completion options.

              ---------------------------------------------------------------------------
              Concurrent request completed successfully
              Current system time is 13-APR-2011 13:23:44

              ---------------------------------------------------------------------------
              • 4. Re: "Import Price Catalogs" fails with RATE not valid
                S.PDASH
                Hi,
                You can't get the error details in the log file which you sent.. Did you define the corporate rate in General Ledger for the period in which you are importing catalog. If not then please define in GL and try to run you import program.

                /S.P DASH
                • 5. Re: "Import Price Catalogs" fails with RATE not valid
                  mamit
                  We are doing conversion and the PO_DATE are in past and the period are closed for the date, status_code = 'C'.
                  Could this be the issue?

                  Thanks
                  • 6. Re: "Import Price Catalogs" fails with RATE not valid
                    850188
                    Hi

                    I am working on implementation project and i need to convert PO's and BPA's.
                    Could you please share Import Price Catalogs Conversion Script.
                    if you dont mind please send the script my below email-d.
                    Thanks a lot.

                    praveensourav44@gmail.com


                    Praveen.