This discussion is archived
3 Replies Latest reply: Jun 17, 2010 3:24 AM by 428308 RSS

R12 Transform Step : Unable to upload Users through excel

Franck James Newbie
Currently Being Moderated
Hi,

I wanted to centralize an excel file into ACP Setup Manager with all the project users. The main Idea was to enhance this file and deploy it into the project instance and/or when a refresh is performed. (context ACP 3.1 + R12.1.2)

The test is easy to perform :

1 - Create a project that extracts users
2 - Execute this project
3 - Transform this extract into an excel file
4 - Add new users into the excel file and upload it

When performing the last step I got a failure. Thinkig it comes from the changes done in the excel file, I decided to upload the original excel file but got exactly the same error message :

In ApplyTransformCommand: RUNNING
ExcelToDB: Uploading Excel Data to Database for the Entity USER_FND_USER_1
java.lang.Exception: Attribute Encrypted User Password is not present in shredded data for data source USER_FND_USER_1
     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 Encrypted User Password is not present in shredded data for data source USER_FND_USER_1
     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)

Can anybody help me to understand what is wrong ?

thanks in advance,

Franck

Legend

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