0 Replies Latest reply: Dec 28, 2011 3:45 AM by 907812 RSS

    Transform is failing : Oracle setup manager

    907812
      We are trying to transform a value set name and get the error given below. All our tranforms are failing with similar kind of message where one particular value does not exist. Please help.


      In ApplyTransformCommand: RUNNING
      ExcelToDB: Uploading Excel Data to Database for the Entity VALUE_SET_VALUES
      java.lang.Exception: Attribute Meaning Column Name is not present in shredded data for data source VALUE_SET_VALUES
           at oracle.apps.acp.az.oms.common.server.ExcelToDB.updateRecordtoDB(ExcelToDB.java:757)
           at oracle.apps.acp.az.oms.common.server.ExcelToDB.synchronizeSheettoDB(ExcelToDB.java:594)
           at oracle.apps.acp.az.oms.common.server.ExcelToDB.synchronizeWorkBooktoDB(ExcelToDB.java:435)
           at oracle.apps.acp.az.oms.common.server.ExcelToDB.synchronizeExceltoDB(ExcelToDB.java:320)
           at oracle.apps.acp.az.oms.common.server.ExcelToDB.writeToDB(ExcelToDB.java:133)
           at oracle.apps.acp.az.oms.api.API.importFromExcel(API.java:408)
           at oracle.apps.acp.az.oms.transform.server.Transformer$APITransformExecuter.run(Transformer.java:507)

      java.lang.Exception: Attribute Meaning Column Name is not present in shredded data for data source VALUE_SET_VALUES
           at oracle.apps.acp.az.oms.common.server.ExcelToDB.updateRecordtoDB(ExcelToDB.java:757)
           at oracle.apps.acp.az.oms.common.server.ExcelToDB.synchronizeSheettoDB(ExcelToDB.java:594)
           at oracle.apps.acp.az.oms.common.server.ExcelToDB.synchronizeWorkBooktoDB(ExcelToDB.java:435)
           at oracle.apps.acp.az.oms.common.server.ExcelToDB.synchronizeExceltoDB(ExcelToDB.java:320)
           at oracle.apps.acp.az.oms.common.server.ExcelToDB.writeToDB(ExcelToDB.java:133)
           at oracle.apps.acp.az.oms.api.API.importFromExcel(API.java:408)
           at oracle.apps.acp.az.oms.transform.server.Transformer$APITransformExecuter.run(Transformer.java:507)

      java.lang.Exception: There were exceptions while processing APIs.
           at oracle.apps.acp.az.oms.transform.server.Transformer.excelToDB(Transformer.java:428)
           at oracle.apps.acp.az.oms.job.command.ApplyTransformCommand.executeCommand(ApplyTransformCommand.java:141)
           at oracle.sysman.emdrep.jobs.BaseJobWorker.runStep(BaseJobWorker.java:614)
           at oracle.sysman.emdrep.jobs.BaseJobWorker.doOneOperation(BaseJobWorker.java:738)
           at oracle.sysman.emdrep.jobs.JobWorker.doOneOperation(JobWorker.java:306)
           at oracle.sysman.emdrep.jobs.JobWorker.run(JobWorker.java:288)
           at oracle.sysman.util.threadPoolManager.WorkerThread.run(Worker.java:261)