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 Go to next message
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 #626044 is a reply to message #626037] Mon, 20 October 2014 02:41 Go to previous messageGo to next message
cookiemonster
Messages: 13958
Registered: September 2008
Location: Rainy Manchester
Senior Member
Why are you trying to truncate a table from a report?
Re: REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error [message #626046 is a reply to message #626044] Mon, 20 October 2014 03:22 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
Why are you trying to truncate a table from a report?

Thank you for reply cookiemonster and sorry for the Late reply from me.

This report was developed by another user and i don't know i will ask and send u later

can you please give me a solution or is there modification needed in that report
Re: REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error [message #626047 is a reply to message #626046] Mon, 20 October 2014 03:25 Go to previous messageGo to next message
cookiemonster
Messages: 13958
Registered: September 2008
Location: Rainy Manchester
Senior Member
Does the user running the report have the necessary privs to truncate the table?
Re: REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error [message #626048 is a reply to message #626047] Mon, 20 October 2014 03:29 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
Does the user running the report have the necessary privs to truncate the table?


I think yes and i am trying to add below code instead of 0(zero) and ran the program got the same error..
nvl(:CF_A10,0), 
Re: REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error [message #626049 is a reply to message #626047] Mon, 20 October 2014 03:33 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Yes XXC_ABC table have necessary prvlg to insert , update and delete
Re: REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error [message #626050 is a reply to message #626047] Mon, 20 October 2014 03:34 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
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.
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 Go to previous messageGo to next message
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 #626053 is a reply to message #626052] Mon, 20 October 2014 03:48 Go to previous messageGo to next message
cookiemonster
Messages: 13958
Registered: September 2008
Location: Rainy Manchester
Senior Member
So what's CF_A10 exactly?
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 Go to previous messageGo to next message
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 #626055 is a reply to message #626053] Mon, 20 October 2014 04:03 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Hi,

In the BeforeReport trigger they are inserting into the XXC_HHH , but not with this column CF_A10
function BeforeReport return boolean 
is
begin
 If :FLAG = 'Y' then 
Insert into XXC_HHH
(ATTR1,
.....,
.....,
..... 
) 
values 
(bbb
....
....
); 
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 Go to previous messageGo to next message
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 #626068 is a reply to message #626065] Mon, 20 October 2014 06:05 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Function terminates as it reaches the RETURN keyword. Nothing you put behind it is executed.
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 Go to previous messageGo to next message
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 #626109 is a reply to message #626072] Mon, 20 October 2014 23:55 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
can any one please help me?
Re: REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error [message #626112 is a reply to message #626109] Tue, 21 October 2014 00:13 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
  1. Try to recompile all (Ctrl + Shift + K) and run the report. Any improvement?
  2. What is XXC_HHH table's description?
  3. 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)?
Re: REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error [message #626115 is a reply to message #626112] Tue, 21 October 2014 00:22 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Thanks for reply Littlefoot,
Quote:
Try to recompile all (Ctrl + Shift + K) and run the report. Any improvement?

no change
Quote:
What is XXC_HHH table's description?

contains with number,date and character data types
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)?

XXC_ABC table is used to display data

XXC_HHH--> truncating in the AfterPForm trigger and insert the data into the BeforeReport into the XXC_HHH

and in the CF_Formula  column insert the data into the XXC_HHH table 
Re: REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error [message #626118 is a reply to message #626115] Tue, 21 October 2014 01:09 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I asked 3 simple questions. You answered the first one. Text you wrote afterwards doesn't answer my second and third question AT ALL.
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 Go to previous messageGo to next message
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
Re: REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error [message #626121 is a reply to message #626120] Tue, 21 October 2014 01:40 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You are either pulling our leg, or you are a genuine idiot.



  • XXC_HHH table doesn't even contain columns named CF_A10 or ATTR1. Both of them are used in your formula column's code
  • INSERT statement you posted is invalid (contains too many commas)

I quit this discussion. Good luck.
Re: REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error [message #626126 is a reply to message #626121] Tue, 21 October 2014 02:07 Go to previous message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Hi Littlefoot,
QTY10 NUMBER -->is same as CF_A10 and CF_A10 is the formula column , i am just given idea on this

Previous Topic: Report giving total count per one customer id
Next Topic: how to write exception code in the formula column
Goto Forum:
  


Current Time: Sat Nov 23 06:24:17 CST 2024