Shannon's JD Edwards CNC Blog: October 2013

Thursday, 24 October 2013

When deciding on a port for a JAS instance, consider this

I generally use something like 81 - DV, 82 - PY, 83 - UA etc. or put a 9081, 9082 etc.

It starts to get a little more complicated with BSSV and SSL, but not too much. Leave at least 1 port between your instances if you are using SSL.

Here is a handy list of default oracle ports that you can also avoid:

Component or Service	Default Port Number	Allotted Port Range
Oracle Business Activity Monitoring	9001	9000-9080
Oracle Directory Integration Platform	7005	7005-9000
Oracle Directory Services Manager	7005	7005-9000
Oracle Forms Services Managed Server	9001	9001-9100
Oracle HTTP Server non-SSL Listen Port	7777	7777-7877
Oracle HTTP Server SSL Listen Port	4443	4443-4543
Oracle Imaging and Process Management	16000	16000
Oracle Identity Federation Server Managed Server	7499	7499-9000
Oracle Internet Directory (non-SSL)	3060	3061 to 3070, 13060 to 13070
Oracle Internet Directory (SSL)	3131	3132 to 3141, 13131 to 13141
Oracle Management Agent (used by Fusion Middleware Control)	5162	5162-6162
Oracle Notification Server Local Port	6100	6100 - 6199
Oracle Notification Server Remote Port	6200	6200 - 6299
Oracle Notification Server Request Port	6003	6003 - 6099
Oracle Portal Managed Server	9001	9001-9100
Oracle Reports Managed Server	9001	9001-9100
Oracle Virtual Directory (non-SSL)	6501	6501-6510
Oracle Virtual Directory (SSL)	7501	7501-7510
Oracle Web Cache Administration Port	7786	7781-7790
Oracle Web Cache Invalidation Port	7788	7781-7790
Oracle Web Cache Listen Port	7785	7781-7790
Oracle Web Cache SSL Listen Port	7789	7781-7790
Oracle Web Cache Statistics Port	7787	7781-7790
Oracle WebCenter Discussions Server	8890	8881-8890
Oracle WebCenter Portlets	8889	8881-8890
Oracle WebCenter Spaces	8888	8881-8890
Oracle WebCenter Wiki and Blog Server	8890	8881-8890
Oracle WebLogic Server Listen Port for Administration Server	7001	7001-9000
Oracle WebLogic Server Listen Port for Managed Server	8001	8000 - 8080
Oracle WebLogic Server Node Manager Port	5556	5556
Oracle WebLogic Server SSL Listen Port for Administration Server	7002	7002-9000

Monday, 14 October 2013

JD Edwards scheduled jobs table demystification

A fairly quick post. Ever wanted to list the JD Edwards scheduled jobs, when they start, recurrence type, etc etc... It's not as easy as you think. There are lots of things going on in that F91300 that need to be decrypted.

Here is something that helped me:

Dump them all into excel, that is a good start.

The following can be used to decipher the recurrence type: (SJSCHRCRTYP)

01	Custom Recurrence
11	Daily - Mode 1
12	Daily - Mode 2
21	Weekly - Mode 1
31	Monthly - Mode 1
32	Monthly - Mode 2
41	Period - Mode 1
42	Period - Mode 2
51	Yearly - Mode 1
52	Yearly - Mode 2

Here are some excel formlas to help you convert the EPOCH (of course bespoke JDE version, which is in minutes) to standard date and time.

time scheduled (UTC)	JDE Vers x 60	start time (UTC)	With DST start time
17964814	1077888840	1:34:00 PM	11:34:00 PM
17964817	1077889020	1:37:00 PM	11:37:00 PM
17964933	1077895980	3:33:00 PM	1:33:00 AM
17964934	1077896040	3:34:00 PM	1:34:00 AM
17964935	1077896100	3:35:00 PM	1:35:00 AM
17964813	+I7*60	=+(J7/86400)+25569	=+K7+TIME(10,,)

The formulas are in the last row.

The combination of the recurrence type, the start time and the table below (showing you weekday / day of month runtime options will help.

Monthly will have a value for the day of the month in SJSCHDAY
Weekly look for the columns that are populated (SJTUESDAY etc)

Here are the table columns

SJSCHJBTYP NCHAR(2)
SJSCHJBNM NOT NULL NCHAR(30)
SJSCHRPTNM NCHAR(10)
SJSCHVER NCHAR(10)
SJPROCNAME NCHAR(10)
SJSCHSTTIME NUMBER
SJSCHENTIME NUMBER
SJNUMJOBOCC NUMBER
SJCURRUNCNT NUMBER
SJMAXRESUB NUMBER(15)
SJSCHJBSTAT NCHAR(2)
SJSCHENHV NCHAR(10)
SJSCHJOBSVR NCHAR(30)
SJSCHUSER NCHAR(10)
SJSCHPSWD NCHAR(10)
SJSCHROLE NCHAR(15)
SJJDELOG NCHAR(1)
SJTRACING NCHAR(1)
SJUBELOGLVL NCHAR(1)
SJSCHPI NCHAR(1)
SJPNTR NCHAR(30)
SJJOBQUE NCHAR(10)
SJRESBONERR NCHAR(2)
SJRESBTIME NUMBER
SJINPRTMOTPY NCHAR(2)
SJINPRMAX NUMBER
SJINPRTMOUT NUMBER
SJJOBEXPIRE NUMBER
SJSCHRCRTYP NCHAR(2)
SJCO NCHAR(5)
SJSCHNUMMNS NUMBER
SJSCHNUMHRS NUMBER
SJSCHNUMDY NUMBER
SJSCHNUMWKS NUMBER
SJSCHNUMMN NUMBER
SJSCHDAY NCHAR(1)
SJWEEKDAY NCHAR(1)
SJWEEKEND NCHAR(1)
SJMONDAY NCHAR(1)
SJTUESDAY NCHAR(1)
SJWEDNESDAY NCHAR(1)
SJTHURSDAY NCHAR(1)
SJFRIDAY NCHAR(1)
SJSATURDAY NCHAR(1)
SJSUNDAY NCHAR(1)
SJTIMEZONES NCHAR(2)
SJDAYLIGHTSV NCHAR(1)
SJDSAVNAME NCHAR(10)
SJSCHCTCD01 NCHAR(6)
SJSCHCTCD02 NCHAR(6)
SJSCHCTCD03 NCHAR(6)
SJSCHCTCD04 NCHAR(6)
SJSCHCTCD05 NCHAR(6)
SJSCHFU1 NUMBER
SJSCHFU2 NUMBER
SJSCHFU3 NCHAR(30)
SJSCHFU4 NCHAR(30)
SJUSER NCHAR(10)
SJPID NCHAR(10)
SJJOBN NCHAR(10)
SJUPMJ NUMBER(6)
SJUPMT NUMBER
SJSCHPWD BLOB()

Thursday, 10 October 2013

Trigger to put certain users jobs in a slow queue

Do you have certain users clogging the system with their crazy jobs? Consultants causing production to slow down? Well, implement this simple solution to force their jobs to goto another dedicated queue, in this case Q812.

Note that this is only going to run if the job has been put into the default queue (won't override QSINGLE for example), also it only fires when the job is being moved from S to W.

Note that I set up a UDC to control this functionality, '55', 'JQ' and I also used a public synonym for F0005, as you see there is no owner in the text.

BEFORE UPDATE

ON SVM812.F986110 FOR EACH ROW

DECLARE

chgFlag NUMBER ;

BEGIN

IF ltrim(rtrim(:new.jcjobque)) = 'QBATCH' and

ltrim(rtrim(:new.jcjobsts)) = 'S' and ltrim(rtrim(:old.jcjobsts)) = 'W' THEN

SELECT COUNT(*) INTO chgFlag

FROM F0005

WHERE drsy = '55'

AND drrt = 'JQ'

AND ltrim(rtrim(drky)) = ltrim(rtrim(:NEW.JCUSER)) ;

IF chgFlag > 0 THEN

:new.JCJOBQUE := 'Q812';

END IF;

Thursday, 3 October 2013

Current list of 9.1 Business Services

From here: http://docs.oracle.com/cd/E16582_01/doc.91/e38040/toc.htm

Shannon's JD Edwards CNC Blog