Hi all.
I'm using Forms and Reports 12c (12.2.1.3).
I have the following issue running a particular report:
El informe ha terminado con error:
REP-1401: A fatal PL/SQL error occurred in program unit beforereport. ORA-03147: Missing mandatory TTC field .
I have determined the problem is related with the % character in a report parameter on a before report trigger:
if instr(:p_co_grupo_producto,'%') = 0 then
:p_co_grupo_producto := :p_co_grupo_producto||'%';
end if;
--
if instr(:p_co_producto,'%') = 0 then
:p_co_producto := :p_co_producto||'%';
end if;
--
This report does not fail on C/S 6i.
I would like a solution that works on C/S as well as on Web.
Is it possible to know in what platform the report module is being run . Similar to get_application_property on Foms???
Thanks so much in advance !!!.