Its been long time since Chris Koloszar had given steps towards enabling and using BSSV for JD Edwards Demo Jr 9.0 or 9.0.2. I’m summarizing and setting up the following steps for E9 only.
Pre-Requisite Softwares installed:
- JD Edwards EnterpriseOne Demo 9.0 or 9.0.2 version (Working good) (Preferably SQL Server edition)
- JavaTM Platform, Standard Edition Development Kit (JDK) 1.6.x.xx
- Download JDeveloper 10.1.3.5 (used for BSSV Development) from Oracle. The older version is the one compatible with E9. There’s no harm in using the 11G version though.
Once you have all the software in place, let’s go ahead with the steps to working with BSSV
- Create a folder c:\E900\DEMO\sbfjars
- Check if the following tables are missing: F986020 & F986030
- If not, then check out in OMW and Generate these two tables.
- Check the F98602 & F98603 tables for the path code. If the path code is not correct (i.e. DEMO) then you need to update these to correct the issue via SQL (or develop a custom app to do it)
- update JDEOL900.F98603 set SMPATHCD = ‘DEMO’
- update JDEOL900.F98602 set SDPATHCD = ‘DEMO’
- Copy the java.tpl as per instructions in the Business Services development Guide
- “C:\E900\system\classes\java.tpl” to “C:\JDEV\jdev\system\oracle.developer.10.1.xx.x” folder.
- Copy JDBJ.ini from “C:\E900\system\OC4J\j2ee\home\applications\webclient.ear\webclient\WEB-INF\classes” to “C:\E900\DEMO\ini\sbf” and also to “C:\Windows” folders
- Go to Security Workbench (P00950) – and take form exit – Published BSSV
Add the following Entry
Published BSSV = *ALL
Published BSSV Method = *ALL
Execute Allowed = Y
- Now, If you are not able to add any Value Object (BSSV or Table) then you will have to add the following Database User (JDE/jde) to your E1Local DB.
- For SQL Server, Open the SQL Server manager, and add a user – “JDE” with password “jde”, and grand all privileges.
- For Oracle Server you will have to do some more steps. You first have to set a password for SYS, and then create the user.
- Replace the first line in sqlnet.ora (C:\Oracle\E1Local\NETWORK\ADMIN):
- Restart the Oracle Services (Start – Run – services.msc).
- go to Start – Run – CMD and type in
SQLPLUS / NoLog
- In there, type
CONNECT / AS SYSDBA
- This will get connected with DBA privileges
- Now, you can change the password of SYS to set a password with the following SQL
ALTER USER sys IDENTIFIED BY oracle;
Here “oracle” is the password for the user SYS.
Open SQLDeveloper, and input the user/pwd = sys/oracle, and role as SYSDBA
- Once done, execute the following SQL to create user
- CREATE USER JDE IDENTIFIED BY jde;
- or on the left panel, right click the Other Users entry, and select Create User. Use JDE/jde as user/pwd
- Now that the user has been created, you will need to grant privileges on the user to all schema. For that you need to do the following
- Right click the User which has been created in the left panel as shown below, and select EDIT USER
- Select all roles, system privileges, and Quotas as applicable, finally, click APPLY to execute the SQL’s generated.
- Now on you should be able to create BSSV’s on Local Demo.
- One tip – You need to Check In the BSSV, so that you can tick the “Set to Publish” check box to test the BSSV.
- Make sure that you have entries in the F98601, F98602, F98603 tables in Object Librarian, else you get the Not Authorized message when you try to test it.
Happy BSSV Development.