This discussion is archived
0 Replies Latest reply: Dec 28, 2011 1:45 AM by 907812 RSS

Transform is failing : Oracle setup manager

907812 Newbie
Currently Being Moderated
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)

Legend

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