Skip to main content

Hello,

I need Advice on how to solve this,

I am trying to get this custom field to work. It is a Read Only Custom Field. The syntax is validated successfully. But when I publish I get “ORA-01403: no data found” (see server error message below). The event  looks like this:

I need to use part_no and price_catalog_no to join. Price_catalog_no was not available in the lines only in the header. That is why I created this custom field. This cf works as intended.

I am using price_catalog_no from here as a join. 

 

Server error messages:
1732c290-72d8-4b97-83c9-929e0d69c15b

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 "IFS”removedcompanyname”.CUSTOM_FIELDS_API", line 4788
ORA-06512: at "IFS.CUSTOM_OBJ_SYS", line 2893
ORA-06512: at "IFS.CUSTOM_OBJ_SYS", line 5098
ORA-06512: at "IFS.CUSTOM_OBJ_SYS", line 5035
ORA-06512: at "IFS.CUSTOM_OBJ_SYS", line 5056
ORA-06512: at "IFS.CUSTOM_OBJ_SYS", line 4269
ORA-06512: at "IFS.CUSTOM_OBJ_SYS", line 4269
ORA-06512: at "IFS.CUSTOM_OBJ_SYS", line 5941
ORA-06512: at "IFS.CUSTOM_OBJ_SYS", line 7398
ORA-06512: at "IFS.CUSTOM_FIELDS_SYS", line 1247
ORA-06512: at "IFS.CUSTOM_FIELDS_SYS", line 1235
ORA-06512: at "IFS.CUSTOM_FIELDS_API", line 4289
ORA-06512: at "IFS.CUSTOM_FIELDS_API", line 4318
ORA-06512: at "IFS.CUSTOM_FIELDS_API", line 4719
ORA-06512: at "IFS.CUSTOM_FIELDS_API", line 4792
ORA-06512: at "IFS.CUSTOM_FIELDS_API", line 4333
ORA-06512: at "IFS.CUSTOM_FIELDS_API", line 4338
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 @Erik ROL 

Remove the PRICE_CATALOG_NO custom field and try with below SELECT statement.

 

SELECT statement: select quote_price from PURCHASE_QUANTITY_PRICE where part_no = :part_no and price_catalog_no = (select price_catalog_no from EXT_PRICAT_HEADER where message_id = :message_id ) and valid_until is null and state = 'Active'

It seems using a Read Only custom field inside the SELECT statement is not possible.

Thank you very much, it now works as intended!

Terms & ConditionsCookie settings