1 Reply Latest reply on Sep 11, 2014 3:57 PM by Hussein Sawwan-Oracle

    Import Price Catalogs - Error

    bilgeBasaltun

      Hi all,

      I try to import my blanket price catalogs. After some tests the program ends with error.

       

      I found 2 patches:

      First applied: (The problem dont resolved)

       

      Patch 10011861:R12.PO.B.


      Second applied:  (The problem dont resolved)

      Patch:12812134:R12.PO.B

       

      Is there any other solution?

       

      Thanks.

       

      Bilge

       

      Error Detail:

       

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

      Purchasing: Version : 12.0.0

       

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

       

      POXPDOI module: Import Price Catalogs

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

       

      Current system time is 11-SEP-2014 17:02:40

       

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

       

       

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

      | Starting concurrent program execution...

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

       

      Arguments

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

       

      Blanket

       

      Y

      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 =  xxxxx

      ************************************

      TRANSACTION ID : xxxxx

      ORGANIZATION ID : xxxx

      TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE

      COLUMN NAME : MASTER_CHILD_1G

      MESSAGE NAME : INV_IOI_MASTER_CHILD_1G

      ERROR MESSAGE : Master - Child Conflict in one of these Attributes: Action(RECEIPT_DAYS_EXCEPTION_CODE), Receipt Routing(RECEIVING_ROUTING_ID), Invoice Close Tolerance Percentage(INVOICE_CLOSE_TOLERANCE), Receipt Close Tolerance Percentage(RECEIVE_CLOSE_TOLERANCE), Starting Lot Prefix(AUTO_LOT_ALPHA_PREFIX), Description(DESCRIPTION), Long Description(LONG_DESCRIPTION).

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_ERR_UTL. Procedure add_fatal_error.0

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_ITEM_PROCESS_PVT. Procedure update_master_item.60

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_ITEM_PROCESS_PVT. Procedure create_items.60

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_lines_add.70

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_lines.10

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process.10

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_PVT. Procedure start_process.110

      User-Defined Exception in Package po.plsql.PO_PDOI_Concurrent. Procedure POXPDOI.30

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

      End of log messages from FND_FILE

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

       

       

      Concurrent Manager encountered an error while running SQL*Plus for your concurrent request 9367521.

       

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

       

       

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

      Executing request completion options...

       

       

      Finished executing request completion options.

       

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

      Concurrent request completed

      Current system time is 11-SEP-2014 17:02:42

       

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