What is RICE implementation in Oracle Apps Technical?

As Salamo alaikum wa rahmatullah

Mostly an oracle apps technical consultant will be working on RICE components.
R--Reports
I--Interfaces
C--Conversions
E--Extensions(Forms personalization)

Reports:
For suppose I'm running a business named 'Mobile and Accessories' which is wide spread across the globe.Now,I want to know how my business is running across the globe.I will ask a tech guy(oracle apps technical consultant) to develop a report.In that report I ask him to simply print the details of profit or loss,of every branch of my business across the world.He(tech guy) will come up with the report to me then I will come to know whether my company is running fine or not.Thereby, I can take necessary decisions to run my business fine.
Clearly we have seen that report will be developed by technical person,who must know the report building.
We build a report using sql,pl/sql.So,if your are strong in sql,pl/sql then its not a big deal to learn the report building.Its enough to learn the report developer tool.

Conversion:
As I said earlier I'm running a 'vnk' business(which is fictious).Suppose I,m using excel sheets to store the data.Now I want to install oracle apps(E-Business Suite) in my company. So,What ever data that is present in my excel sheets must also be present in my oracle apps tables(A table is a collection of rows and columns).Now I ask a tech guy to write a code such that my excel sheet data will get into oracle apps base tables.Then that tech guy will use 'conversion' to get the data from the legacy system(in our case it is excel sheet) into oracle apps base tables.

Interfaces:
Interfaces are similar to conversions.Conversion is a one-time process where as Interface is on-going process every now and then.We run interfaces daily or periodically.
Interfaces are of two types
1)Inbound Interface
2)Outbound Interface
Inbound Interface:Transferring the data from the legacy system(in our case it is excel sheet) into the Oracle apps base tables.
Outbound Interface:Transferring the data from the Oracle apps base tables into the legacy system(It might be any of these SAP,Peoplesoft etc).

Extensions:
Extensions are nothing but persionalizing the forms.In oracle e-business suite we have some where around 5000 to 6000 forms.In my 'vnk' business i want to customise the po(purchase order) form of the oracle apps then i ask the tech guy to do that.He will use form builder tool to do that.
--
Ma Asalaam
Passion's for Oracle

user creation in oracle 12c

As salamo alaikum wa rahmatullah

Question:  I am trying to create a user in Oracle 12c and I don't give a rat's butt about pluggable databases.  When I try to create a user with the c## prefix I get the dreaded ORA-65096 error:

create user fred identified by flintstone;
ORA-65096: invalid common user or role name
I don't care if the user ID is used as a pluggable database, I just want to create a user named fred without being required to add the c## prefix (create user c##fred).
How do I fix the ORA-65096 error and create my use without a container database c## prefix?
Answer:  The oerr utility is not at all helpful for the ORA-65096 error:

ORA-65096: invalid common user or role name

Cause: An attempt was made to create a common user or role with a name that was not valid for common users or roles. In addition to the usual rules for user and role names, common user and role names must start with C## or c## and consist only of ASCII characters.

Action: Specify a valid common user or role name.

The solution to the ORA-06596 is to set a hidden parameter "_oracle_script".  When you set the undocumented (hidden) parameter "_oracle_script"=true  you can create the fred user without a C## in from of the user ID.  However, this user will not used useful in a pluggable/container database:

connect system/manager as sysdba

alter session set "_ORACLE_SCRIPT"=true;

create user fred identified by flintstone;

grant dba to pubs;

connect fred/flintstone

Always consult Oracle support before using any hidden Oracle parameters. 

--
Mohammad Shahnawaz
Passion for Oracle
Kuwait

SQL Error: ORA-01950: no privileges on tablespace 'USERS'

As salamo alaikum wa rahmatullah

It is generated while i am trying to insert the data in the newly created table in newly created schema.

SQL Error: ORA-01950: no privileges on tablespace 'USERS'


01950. 00000 -  "no privileges on tablespace '%s'"
*Cause:    User does not have privileges to allocate an extent in the
           specified tablespace.
*Action:   Grant the user the appropriate system privileges or grant the user
           space resource on the tablespace.


answer - alter user c##prac Quota 100M ON SYSTEM;
Grant unlimited Tablespace to c##prac;


now row has been inserted.

Thanking you to visit 
--
Mohammad Shahnawaz
Passion for Oracle

Oracle Table Partitioning

As salamo alaikum wa rahmatullah,

 Table partition for range with example.

Create table sales_range_ex
(
 salesman_id number(5),
salesman_name varchar2(50),
salesman_amount number(10,2),
sales_date date),
partition by range (sales_date)
(
partition sales_jan2014 value less than To_Date('31-01-2014','dd-mon-YYYY'),
partition sales_feb2014 value less than To_Date('29-Feb-2015,'dd-mon-yyyy'),
partition sales_mar2014 value less than To_Date('31-Mar-2014','dd-mon-yyyy'),
partition sales_apr2014 value less than To_Date('30-Apr-2014','dd-mon-yyyy')
);

insert data into table, that is normal insertion process,

Insert into sales_range_ex value(10001,'Zahangeer Khan',66666.90,'22-Jan-2014')
Insert into sales_range_ex value(10002,'John Dell',666.90,'22-Feb-2014')
Insert into sales_range_ex value(10001,'Darrell john',66666.90,'22-Mar-2014')

Selecting data normally,

Select * from sales_range_ex;

Selecting data by partition

Select * from sales_range_ex partition (sales_jan2014);

Select * from sales_range_ex partition (sales_feb2014);


Select * from sales_range_ex partition (sales_mar2014);

Thanks and Best Regards
-----
Mohammad Shahnawaz
passion for oracle

Trace file viewing ADRCI

As salamo alaikum wa rahmatullah
E:\> adrci
you will get the message
No ADDR base is set
after that write the following command at the prompt
adrci>show base -product client
ADDR base is "C:\Users\Administrator\oracle\oradiag_Administrator"
adrci> set base C:\Users\Administrator\oracle\oradiag_Administrator
adrci>show home
diag\clients\user_adminstrator\host_1002378956_76
diag\clients\user_administrator\host_500236987_78
adrci>show tracefile
the tracefile will be shown with full path
adrci>show alert
and now select the option

----
Mohammad Shahnawaz
Passion for Oracle

Sql excution plan in oracle - 12c

As salamo alaikum wa rahmatullah

c:\windows\system32>sqlplus scott/tiger
sql>explain plan for select ename,dname from emp natural join dept;
select * from table(dbms_xplan.display);
sql>set autotrace on
sql> explain plan for select ename,dname from emp natural join dept;
sql> select * from table(dbms_xplan.display);
sql>select * from table(dbms_xplan.display_cursor(format=>'allstats last'))


Thanking you
--
Mohammad Shahnawaz
Passion for Oracle

EXP-00011

As salamo alaikum

i try to export a table from scott user named salgrade. i encountered error below

Exp-00011 scott.salgrade; does not exist. platform windows7 (64 bits) oracle 11.2.0.

solution - connect with sysdba

c:\  windows\system32>sqlplus / as sysdba

sql> show parameter deferred;

outout 

Name                                                      Type                   Value

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

 deferred_segment_creation                        boolean                  True

sql> alter system set deferred_segmet_creation=false;

sql> shut immediate

sql>startup

sql> show parameter deffered;

outout 

Name                                                      Type                   Value

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

 deferred_segment_creation                        boolean                  False

sql> exist

c:\windows\system32> 

now here you put your command to export the table scott.salgrade.

in oracle10g+, this type of error is occured.

Thanking you

Mohammad Shahnawaz

Passion for Oracle