Hello,
One of my customer is receiving and error when they try to use the Time Clock. The error message they receive is below:
Here is the full details:
Server error messages:
7cc9744a-1057-4d61-86d0-0c30f22c1c74
Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-01400: cannot insert NULL into ("POWE1APP"."TIMREP_TRANSACTION_TAB"."TRANS_ID")
Null value not allowed. (ORA-01400: cannot insert NULL into ("POWE1APP"."TIMREP_TRANSACTION_TAB"."TRANS_ID")
ORA-06512: at "POWE1APP.TIMREP_TRANSACTION_API", line 2375
ORA-06512: at "POWE1APP.TIMREP_TRANSACTION_API", line 2464
ORA-06512: at "POWE1APP.TIMREP_TRANSACTION_API", line 2490
ORA-06512: at "POWE1APP.TIMREP_TRANSACTION_API", line 2025
ORA-06512: at "POWE1APP.TIMREP_TRANSACTION_API", line 2043
ORA-06512: at "POWE1APP.CREATE_STAMPS_API", line 230
ORA-06512: at "POWE1APP.CREATE_STAMPS_API", line 294
ORA-06512: at line 13)
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.Application.TimeClockServices.TimeClockGeneral.InvokeServercall(FndPLSQLSelectCommand& cmd)
This worked fine in their Apps 9 environment but we are having issue with it in Apps 10. We have run the debug console and checked that all the API that it was calling were granted. We also made sure the API in the message above was granted but it didn’t solve the issue.
Any help would be greatly appreciated. I can’t seem to understand what could be causing this in Apps 10.
Thank you,
Nik Kumar