Setting Up Employee Self Service V2 - Part 2 - The database data

Continuing our series on looking into the newest version of Oracle's EBS Mobile Applications,  we now move on to Part II - in which we upload the relevant database data.

We assume here you have an EBS instance you can use.  For our purposes we will use a Vision instance as it is well understood as the sample Oracle database for E-Business Suite.

Our steps are as follows

1. Load the database Data 

In order to do this : 
(copypasta from the tutorial information)

1. Navigate to the selfservice-backend/EBS/seeded directory to access the necessary scripts.
2. Open 01_seed_test_users.sql in a text editor and edit the username information in as needed.
3. Run the following scripts as the APPs user:
   

   01_seed_test_users.sql
   02_create_person.sql
   03_create_user.sql
   04_add_resp.sql

OK so let's upload the files :

Done.

There doesn't look like there's any edits needed to the sample data

Insert into TEST_PERSONS (SL_NO,USERID, FIRST_NAME, LAST_NAME, EMAIL, SEX) values (1,'appsol1', 'Douglas', 'Smith', 'dsmith@oracle.com', 'M');

Insert into TEST_PERSONS (SL_NO,USERID, FIRST_NAME, LAST_NAME, EMAIL, SEX) values (2,'appsol2', 'Michael', 'Davis', 'mdavis@oracle.com', 'M');

Insert into TEST_PERSONS (SL_NO,USERID, FIRST_NAME, LAST_NAME, EMAIL, SEX) values (3,'appsol3', 'Patricia', 'Miller', 'pmiller@oracle.com', 'F');

Insert into TEST_PERSONS (SL_NO,USERID, FIRST_NAME, LAST_NAME, EMAIL, SEX) values (4,'appsol4', 'Linda', 'Williams', 'lwilliams@oracle.com', 'F');

so let's go with that.

Let's run these scripts as the APPS user ?

Sourcing the RUN File System ... [oracle@bd8bc7 ~]$

[oracle@bd8bc7 mobilesamp]$ sqlplus apps

SQL*Plus: Release 10.1.0.5.0 - Production on Tue Oct 11 13:06:41 2016

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> @01_seed_test_users.sql

Table created.

1 row created.

1 row created.

1 row created.

1 row created.

Commit complete.

SQL> @02_create_person.sql

PL/SQL procedure successfully completed.

No errors.

Part 3 fails wth 

SQL> @04_add_resp.sql

DECLARE

*

ERROR at line 1:

ORA-20001: APP-FND-02604: One or some of the following data is not valid:

APPLICATION_SHORT_NAME=PER, RESPONSIBILITY_KEY=EMPLOYEE_DIRECT_ACCESS_V4.0,

SECURITY_GROUP=202.

ORA-06512: at "APPS.APP_EXCEPTION", line 72

ORA-06512: at "APPS.FND_USER_PKG", line 3191

ORA-06512: at line 29

BUT 

select * from FND_SECURITY_GROUPS_VL

  2  ;

SQL> set linesize 32000

SQL> /

ROW_ID             SECURITY_GROUP_ID SECURITY_GROUP_KEY             CREATED_BY CREATION_DATE      LAST_UPDATED_BY LAST_UPDATE_DATE   LAST_UPDATE_LOGIN SECURITY_GROUP_NAME                                                            DESCRIPTION

------------------ ----------------- ------------------------------ ---------- ------------------ --------------- ------------------ ----------------- -------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

AAAjqwAAeAAAATWAAA                 0 STANDARD                                1 09-OCT-98                      120 22-OCT-01                          0 Standard                                                                       Default Security Group

AAAjqwAAeAAAATWAAB                 1 GOVERNMENT                           1318 07-OCT-02                     1318 07-OCT-02                    1826651 Government                                                                     Government Security Group

SQL>

Let's try secgroup STANDARD instead ? Edit the scripts and now

[oracle@bd8bc7 mobilesamp]$ sqlplus apps/apps @03_create_user.sql

SQL*Plus: Release 10.1.0.5.0 - Production on Tue Oct 11 13:34:24 2016

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

PL/SQL procedure successful

[oracle@bd8bc7 mobilesamp]$ sqlplus apps/apps @04_add_resp.sql

SQL*Plus: Release 10.1.0.5.0 - Production on Tue Oct 11 13:34:55 2016

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

PL/SQL procedure successfully completed.

No errors.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oracle@bd8bc7 mobilesamp]$

OK now we have it loaded in the next blog we will put in the OTL changes needed to have a good experience in EBS