Core Workflow - EBS (MOSC)

MOSC Banner

FRM-40350 Query Caused No Records To Be Retrieved in oracle 10g Forms,but data exists in the table

edited Sep 27, 2018 2:16AM in Core Workflow - EBS (MOSC) 3 commentsAnswered

Hi All,

In 10 g forms i am trying to fetch the data from FIND BLOCK using FIND button to the main block.

There is data in the table but not able to fetch using below code.Getting the "FRM-40350 Query Caused No Records To Be Retrieved".

here is the code i use to get the details of purchase order in the find block find button when button pressed trigger.

SELECT  INTERFACE_HEADER_ID INTO L_INTERFACE_HEADER_ID FROM JEG_PO_HDRS_INT_RECON WHERE DOCUMENT_NUM = :PO_QF.po_num_qf;

set_block_property('JEG_PO_HEADERS_INTERFACE', default_where, ' where :JEG_PO_HEADERS_INTERFACE.po_num = '||''''||:PO_QF.po_num_qf||''''||'and'||' :JEG_PO_HEADERS_INTERFACE.interface_header_id = '||''''||l_interface_header_id||'''') ;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center