Enable Business Services for JD Edwards Demo/Standalone

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:

  1. JD Edwards EnterpriseOne Demo 9.0 or 9.0.2 version (Working good) (Preferably SQL Server edition)
  2. JavaTM Platform, Standard Edition Development Kit (JDK) 1.6.x.xx 
  3. Download JDeveloper (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

  1. Create a folder  c:\E900\DEMO\sbfjars
  2. Check if the following tables are missing: F986020 & F986030
    1. If not, then check out in OMW and Generate these two tables.
  3. 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)
    1. update JDEOL900.F98603 set SMPATHCD = ‘DEMO’
    2. update JDEOL900.F98602 set SDPATHCD = ‘DEMO’
  4. Copy the java.tpl as per instructions in the Business Services development Guide
    1. “C:\E900\system\classes\java.tpl” to “C:\JDEV\jdev\system\oracle.developer.10.1.xx.x” folder.
  5. 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
  6. Go to Security Workbench (P00950) – and take form exit – Published BSSV
    Security Workbench BSSV Publish
    Add the following Entry
    Published BSSV = *ALL
    Published BSSV Method = *ALL
    Execute Allowed = Y
  7. 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.
    1. For SQL Server, Open the SQL Server manager, or for Oracle DB open SQL *Plus
      1. Add a user – “JDE” with password “jde”, and grant all privileges.
      2. Similarly add another user “DEMO” with password “DEMO”, and grant all privileges.
    2. 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.
      1. Replace the first line in sqlnet.ora (C:\Oracle\E1Local\NETWORK\ADMIN):
      2. Restart the Oracle Services (Start – Run – services.msc).
      3. go to Start – Run – CMD and type in
        SQLPLUS / NoLog
      4. In there,  type
        This will get connected with DBA privileges
      5. 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.
      6. Open SQLDeveloper, and input the user/pwd = sys/oracle, and role as SYSDBA
      7. Once done, execute the following SQL to create user
        or on the left panel, right click the Other Users entry, and select Create User. Use JDE/jde as user/pwd
      8. 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
        1. Right click the User which has been created in the left panel as shown below, and select EDIT USER
        2. Select all roles, system privileges, and Quotas as applicable, finally, click APPLY to execute the SQL’s generated.
  8. Now on you should be able to create BSSV’s on Local Demo.
  9. One tip – You need to Check In the BSSV, so that you can tick the “Set to Publish” check box to test the BSSV.
  10. 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.
    1. If you do not have values in F98602 and F98603, create couple of Headerless forms on the tables, and add the records. Tips for column values
      1. Use your published object name in the OBNM.
      2. BSSV Archive size can be anything.
      3. BSSV Artifact will be something like – CustomAddressMgr.java
      4. BSSV Status Flag = 1
      5. BSSV Method Exposed =1
      6. BSSV Method Name = GetAddressBookFormat
      7. Once records are inserted, you should be able to check-in and publish your object. Even test it 🙂

Also view http://mshameen.blogspot.in/2012/06/it-took-me-2-full-days-to-get.html

Happy BSSV Development.

Leave a Reply

Your email address will not be published. Required fields are marked *