Hi All.
Could someone help how could I set up an object transformation from TaskTemplateWorkStep to PmActionWorkStep?
My need is to transform an image from worktaskstep template to the pm actions and finally to a workorder. Also as I create a new revision from it.
This is the transformation I’m using:
TASK_TEMPLATE_ID=PM_ACTION_JOB_API.Get_Std_Job_Id(pm_no,pm_revision,work_list_no),
TASK_TEMPLATE_REV=PM_ACTION_JOB_API.Get_Std_Job_Revision(pm_no,pm_revision,work_list_no),
WORK_LIST_NO=ROW_NO,
WORK_STEP_SEQ=pm_action_work_step_seq
Trying to do but getting the error bellow:
Tks a lot
Server error messages:
580416c0-2cbc-4384-b02a-337d04fabb24
Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Failed executing statement (ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 16
ORA-06512: at "IFSPET.OBJ_CONNECT_LU_TRANSFORM_API", line 3333
ORA-06512: at "IFSPET.OBJ_CONNECT_LU_TRANSFORM_API", line 3339
ORA-06512: at "IFSPET.OBJ_CONNECT_LU_TRANSFORM_API", line 3938
ORA-06512: at "IFSPET.OBJ_CONNECT_LU_TRANSFORM_API", line 3948
ORA-06512: at "IFSPET.OBJ_CONNECT_LU_TRANSFORM_API", line 3252
ORA-06512: at "IFSPET.OBJ_CONNECT_LU_TRANSFORM_API", line 3271
ORA-06512: at "IFSPET.OBJ_CONNECT_LU_TRANSFORM_API", line 3059
ORA-06512: at "IFSPET.OBJ_CONNECT_LU_TRANSFORM_API", line 3078
ORA-06512: at "IFSPET.OBJ_CONNECT_LU_TRANSFORM_API", line 1667
ORA-06512: at "IFSPET.OBJ_CONNECT_LU_TRANSFORM_API", line 1671
ORA-06512: at "IFSPET.OBJ_CONNECT_LU_TRANSFORM_API", line 761
ORA-06512: at "IFSPET.OBJ_CONNECT_LU_TRANSFORM_API", line 772
ORA-06512: at line 10)
at Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)
at Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions)
at Ifs.Fnd.AccessProvider.FndConnection.HandleHttpSuccessResult(HttpWebResponse result, FndManualDecisionCollection decisions, String operation, FndBodyType responseBodyType, Object responseBody)
at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)
--- End of inner exception stack trace ---
at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)
at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(String intface, String operation, Object requestBody, Object responseBody, FndRequestContext requestContext, Boolean forcedSync, Boolean integrationGateway)
at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommandCollection.Invoke()
at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommand.ExecuteNonQuery()
at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommandReader.Read(Boolean prepare)
at Ifs.Fnd.Data.ADONetProvider.FndAPCommand.ExecuteDbDataReader(CommandBehavior behavior)