ERPstuff - Oracle EBS Community

Report 6i result on C/S

If there are 50 records in report in tabular, I found a mistake in one record then when I click on this record it will open in form so that i could edit.

It is possible?

Any one can solve this Issue????

I user this code but not exact to my condition

<b>Procedure</b>
PROCEDURE INVOKE_FORM (FormName Varchar2) IS
appID PLS_INTEGER;
BEGIN
AppId:= DDE.App_Begin ('D:\oracle6i\BIN\ifrun60.EXE \ORACLE\Costing\Forms\'
||formName||'.fmx kamran/ahmed', dde.app_mode_normal);

END;

in Filed Format Tigger
function F_MAIL_REFFormatTrigger return boolean is
AppId pls_integer;
begin
if :mail_ref is null then
invoke_form ('Costing-new-1');
end if;
return (TRUE);
end;

For this create a dummy table from reports insert the parameter values (parameters which are needed to pass) to the table, then access the table from the Forms.

For creating and inserting records to the table from Reports, refer on line documentation for SRW.DO_SQL procedure.

Assalam alaikum

Ahmed can I ask you that how can I pass the parameters from report to form
I m confuse how to start.

You can create a button on oracle reports in same repeating frame from where (you want to pass parameter to oracle forms) and write code on action trigger by using srw.do_sql.