Hello again,
I’m trying to create a Persistent Custom Field (Boolean) in Preliminary Supplier Invoice screen to identify some feature for a newly created invoice. The process goes smoothly, CF is published without errors, but when trying to create a new record with the checkbox ticked for this CF, system displays the error:
Server error messages:
809f34f0-4b7d-4301-a0a3-6578e0a9262d
Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-01410: invalid ROWID
Failed executing statement (ORA-01410: invalid ROWID
ORA-06512: at line 16
ORA-06512: at "IFSAPP.MAN_SUPP_INVOICE_CFP", line 699
ORA-06512: at "IFSAPP.MAN_SUPP_INVOICE_CFP", line 578
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)
I will add that there are already other existing persistent Custom Fields that cause the same error.
However, adding record directly from Manual Supplier Invoice screen does not cause any error. It looks like a system bug.
Any ideas are highly appreciated ;)
Thx in advance