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)
- Navigate to the
selfservice-backend/EBS/seededdirectory to access the necessary scripts. - Open
01_seed_test_users.sqlin a text editor and edit the username information in as needed. - 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
