Home » Developer & Programmer » Reports & Discoverer » REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error
REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error [message #626037] |
Mon, 20 October 2014 02:05 |
|
mist598
Messages: 1195 Registered: February 2013 Location: Hyderabad
|
Senior Member |
|
|
Hi all,
function CF_Formula return Char is
abc varchar2(30);
begin
abc := null;
begin
If :FLAG = 'Y' then
Insert into XXC_HHH
( CF_A10 )
values
(0, -- :CF_A10 ,
,abc
);
end if;
end;
return null;
end;
In that code
If I output 0 directly, it runs (ie. 0, -- :CF_A10 ,)
If I return 0 and try to output :CF_A10 , I get the Internal error
message....
I am getting MSG-05000: DEBUG: Before Parm Trigger
MSG-05000: DEBUG: After Parm Trigger
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-271504897:
error's in the Oracle Apps Reports
function BeforePForm return boolean is
begin
srw.message (5000, 'DEBUG: Before Parm Trigger ');
SRW.DO_SQL('TRUNCATE TABLE XXC_ABC');
SRW.DO_SQL('TRUNCATE TABLE XXC_CCC');
SRW.DO_SQL('TRUNCATE TABLE XXC_DDD');
commit;
RETURN(TRUE);
END;
function AfterPForm return boolean is
begin
srw.message (5000, 'DEBUG: After Parm Trigger ');
If :FLAG= 'Y' then
SRW.DO_SQL('TRUNCATE TABLE XXC_HHH');
commit;
end if;
return (TRUE);
end;
Please help me!!
|
|
|
|
|
|
|
|
|
Re: REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error [message #626052 is a reply to message #626050] |
Mon, 20 October 2014 03:38 |
|
mist598
Messages: 1195 Registered: February 2013 Location: Hyderabad
|
Senior Member |
|
|
Quote:How does the INSERT statement really look like? The one you posted is invalid. You are inserting 2 values ((0 or :CF_A10) and (abc variable)) into a single XXC_HHH.CF_A10 column. 2 -> 1 won't work.
Sorry Littlefoot that is my mistake and please see the changed code below
function CF_Formula return Char is
abc varchar2(30);
begin
abc := null;
begin
If :FLAG = 'Y' then
Insert into XXC_HHH
(CF_A10 ,
ATTR1, --->This one
)
values
(0, -- :CF_A10 ,
,abc
);
end if;
end;
return null;
end;
[Updated on: Mon, 20 October 2014 03:46] Report message to a moderator
|
|
|
|
Re: REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error [message #626054 is a reply to message #626053] |
Mon, 20 October 2014 03:56 |
|
mist598
Messages: 1195 Registered: February 2013 Location: Hyderabad
|
Senior Member |
|
|
function CF_A10 return Number is
v_qty number(10);
begin
v_qty := 0;
If :CF_Qty10 = 0 and :CF_AA <= 1 then
return nvl(v_qty, 0);
end if;
If :CF_B10 < 0 then
If nvl(:CF_Qty10,0) = 0 and nvl(:cf_Lot,0) = 0 then
v_qty := abs(:CF_B10);
return nvl(v_qty, 0);
end if;
v_qty := nvl(:CF_Qty10,0);
If v_qty >= abs(:CF_B10) then
return nvl(v_qty, 0);
end if;
If nvl(:cf_Lot,0) > 0 then
Loop
v_qty := v_qty + nvl(:cf_Lot,0);
exit when v_qty >= abs(:CF_B10);
end loop;
return nvl(v_qty, 0);
end if;
v_qty := abs(:CF_B10);
return nvl(v_qty, 0);
end if;
return nvl(v_qty, 0);
end;
|
|
|
|
Re: REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error [message #626065 is a reply to message #626050] |
Mon, 20 October 2014 05:51 |
|
mist598
Messages: 1195 Registered: February 2013 Location: Hyderabad
|
Senior Member |
|
|
Hi,
I am getting 5000, 'DEBUG: Before Parm Trigger ' and 1000, 'No data found , Please Check!
and what about the after truncated messages means not getting 1000, 'Records Truncated From EMP1 Table Please check!!' why?
function BeforePForm return boolean is
begin
srw.message (5000, 'DEBUG: Before Parm Trigger ');
SRW.DO_SQL('TRUNCATE TABLE emp1');
RETURN(TRUE);
SRW.MESSAGE(1000, 'Records Truncated From EMP1 Table Please check!!');
END;
function BeforeReport return boolean is
v_count number;
begin
select count(*) into v_count from emp1;
if v_count=0 then
SRW.MESSAGE(1000, 'No data found , Please Check !!!');
end if;
return (true);
end;
-
Attachment: MODULE1.rdf
(Size: 48.00KB, Downloaded 2400 times)
|
|
|
|
Re: REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error [message #626072 is a reply to message #626068] |
Mon, 20 October 2014 06:12 |
|
mist598
Messages: 1195 Registered: February 2013 Location: Hyderabad
|
Senior Member |
|
|
Quote:Function terminates as it reaches the RETURN keyword. Nothing you put behind it is executed.
Yes Thanks Littlefoot
Quote:Why are you trying to truncate a table from a report?
function BeforePForm return boolean is
begin
srw.message (5000, 'DEBUG: Before Parm Trigger ');
SRW.DO_SQL('TRUNCATE TABLE XXC_ABC');
SRW.DO_SQL('TRUNCATE TABLE XXC_CCC');
SRW.DO_SQL('TRUNCATE TABLE XXC_DDD');
commit;
RETURN(TRUE);
END;
function AfterPForm return boolean is
begin
srw.message (5000, 'DEBUG: After Parm Trigger ');
If :FLAG= 'Y' then
SRW.DO_SQL('TRUNCATE TABLE XXC_HHH');
commit;
end if;
return (TRUE);
end;
And again i am inserting the Data into the XXC_HHH Table
function BeforeReport return boolean
is
begin
If :FLAG = 'Y' then
Insert into XXC_HHH
(ATTR1,
.....,
.....,
.....
)
values
(bbb
....
....
);
And also i have a insert statement in the below Formula column
function CF_Formula return Char is
abc varchar2(30);
begin
abc := null;
begin
If :FLAG = 'Y' then
Insert into XXC_HHH
(CF_A10 ,
ATTR1, --->This one
)
values
(0, -- :CF_A10 ,
,abc
);
end if;
end;
return null;
end;
[Updated on: Mon, 20 October 2014 06:14] Report message to a moderator
|
|
|
|
|
|
|
Re: REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error [message #626120 is a reply to message #626118] |
Tue, 21 October 2014 01:17 |
|
mist598
Messages: 1195 Registered: February 2013 Location: Hyderabad
|
Senior Member |
|
|
2nd Question
CREATE TABLE XXC_HHH
(
ORG NUMBER,
ITEM VARCHAR2(40 BYTE),
ITEM_DESC VARCHAR2(50 BYTE),
UOM VARCHAR2(3 BYTE),
BB_CODE VARCHAR2(20 BYTE),
LEAD_TIME NUMBER,
CC_STOCK NUMBER,
MIN_ORDER_QTY NUMBER,
FIXED_LOT_MULTIPLIER NUMBER,
PLANNER_CODE VARCHAR2(10 BYTE),
QTY0 NUMBER,
QTY1 NUMBER,
QTY2 NUMBER,
QTY3 NUMBER,
QTY4 NUMBER,
QTY5 NUMBER,
QTY6 NUMBER,
QTY7 NUMBER,
QTY8 NUMBER,
QTY9 NUMBER,
QTY10 NUMBER,
QTY99 NUMBER,
PO_QTY0 NUMBER,
PO_QTY1 NUMBER,
PO_QTY2 NUMBER,
PO_QTY3 NUMBER,
PO_QTY4 NUMBER,
PO_QTY5 NUMBER,
PO_QTY6 NUMBER,
PO_QTY7 NUMBER,
PO_QTY8 NUMBER,
PO_QTY9 NUMBER,
PO_QTY10 NUMBER,
PO_QTY99 NUMBER,
HORIZON_QTY NUMBER,
CC_DATE DATE,
END_DATE DATE,
TAKE_RATE NUMBER,
ATTRIBUTE1 VARCHAR2(30 BYTE),
ATTRIBUTE2 VARCHAR2(30 BYTE),
ATTRIBUTE3 VARCHAR2(30 BYTE),
ATTRIBUTE4 VARCHAR2(30 BYTE),
ATTRIBUTE5 VARCHAR2(30 BYTE),
ATTRIBUTE6 VARCHAR2(30 BYTE),
ATTRIBUTE7 VARCHAR2(30 BYTE),
ATTRIBUTE8 VARCHAR2(30 BYTE),
ATTRIBUTE9 VARCHAR2(30 BYTE),
ATTRIBUTE10 VARCHAR2(30 BYTE),
ATTRIBUTE11 VARCHAR2(30 BYTE),
ATTRIBUTE12 VARCHAR2(30 BYTE),
ATTRIBUTE13 VARCHAR2(30 BYTE),
ATTRIBUTE14 VARCHAR2(30 BYTE),
ATTRIBUTE15 VARCHAR2(30 BYTE)
)
TABLESPACE TESTD
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;
Quote:A report is used to display data. Why do you use it to INSERT data? Why don't you do that elsewhere (in a form, for example)?
I didn't get what you are asking
|
|
|
|
|
Goto Forum:
Current Time: Sat Nov 23 06:24:17 CST 2024
|