Skip to main content

Hi I am trying to create a custom field that references a field from custom logical unit that i have created. However when i go to publish the custom field i get an error saying “No data found” this is the stack message from the error: 

Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-01403: no data found

Failed executing statement (ORA-01403: no data found
ORA-06512: at line 15
ORA-06512: at "IFSAPP.CUSTOM_FIELDS_API", line 4792
ORA-06512: at "IFSAPP.CUSTOM_OBJ_SYS", line 2914
ORA-06512: at "IFSAPP.CUSTOM_OBJ_SYS", line 5119
ORA-06512: at "IFSAPP.CUSTOM_OBJ_SYS", line 5056
ORA-06512: at "IFSAPP.CUSTOM_OBJ_SYS", line 5077
ORA-06512: at "IFSAPP.CUSTOM_OBJ_SYS", line 4290
ORA-06512: at "IFSAPP.CUSTOM_OBJ_SYS", line 4290
ORA-06512: at "IFSAPP.CUSTOM_OBJ_SYS", line 5962
ORA-06512: at "IFSAPP.CUSTOM_OBJ_SYS", line 7431
ORA-06512: at "IFSAPP.CUSTOM_FIELDS_SYS", line 1247
ORA-06512: at "IFSAPP.CUSTOM_FIELDS_SYS", line 1235
ORA-06512: at "IFSAPP.CUSTOM_FIELDS_API", line 4293
ORA-06512: at "IFSAPP.CUSTOM_FIELDS_API", line 4322
ORA-06512: at "IFSAPP.CUSTOM_FIELDS_API", line 4723
ORA-06512: at "IFSAPP.CUSTOM_FIELDS_API", line 4796
ORA-06512: at "IFSAPP.CUSTOM_FIELDS_API", line 4337
ORA-06512: at "IFSAPP.CUSTOM_FIELDS_API", line 4342
ORA-06512: at line 8)
   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)

hi @dnyande, 

Issue could be causing from field which is being referenced. It would be helpful if you could share the custom field creation/configuration information and the IFS track version which is being used.

Thanks,
Nilushi

Hi @Nilushi Silva,

Thank you for your response this the code for the custom field i am trying to create;

argument: 

Part_no,  CF$_FABRIC_CODE

 

select statement:

Select CF$_MBF_CUTTING_CLASSIFICA from M_B_F_CUTTING_INFORMATION_CLV t
where  A.CF$_FABRIC_CODE =:CF$_FABRIC_CODE
and    A.CF$_PART_NUMBER=:PART_NO
 

Hi @dnyande,

Thanks for the response. Could you kindly let me know the  IFS track your using and it would be helpfull if you could share some screen shots of the custom field configuration.

Nilushi - 

What’s the “A.” for?  You have “t” as the view alias.

Reply


Terms & ConditionsCookie settings