What are Task Flows?

As salamo alaikum wa rahmatullah

In simple word

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

* Visual representation of application process flow.

* Each Task Flow contains portion of application navigation.

* They are similar to traditional flow charts.

* Primary purpose is reuse.

---

Ma Asalaam

Passion for Oracle

Task Flow Managed Bean Scope

As Salamo alaikum wa rahmatullah.

Task Flow Managed Bean Scope are following
--------------------------------------------------
Application - Remains till application stop.
Session - Persists till user session.
Page Flow - Also known as task flow scope.
View - Lifespan till current page.
Request - Lives for duration of request only.
BackingBean - UI component based.
Flash Scope - Remains till next encountered view (included in JSF 2.0)

--
Ma Asalaam
Passion for Oracle

View Object Programmatically called in java class

As Salamo alaikum wa rahmatullah

package demo.vo.example.view;

import demo.vo.example.model.EmployeesViewImpl;

import demo.vo.example.model.EmployeesViewRowImpl;

import oracle.jbo.ApplicationModule;

import oracle.jbo.client.Configuration;

public class AppModuleTest {
   public static void main(String[] args) {
       ApplicationModule appModule=Configuration.createRootApplicationModule("demo.vo.example.model.AppModule", "AppModuleLocal");
       EmployeesViewImpl vo = (EmployeesViewImpl)appModule.findViewObject("EmployeesView1");
       while(vo.hasNext()){
           EmployeesViewRowImpl row = (EmployeesViewRowImpl)vo.next();
           System.out.println(row.getFirstName()+row.getLastName()+row.getEmail());
//           System.out.println(row.getLastName());
       }
   }
}

Project Reference

--

Ma Asalaam

Passion for Oracle

Add User in SQL Server 2005/2008/2010/2012/2014

As salamo alaikum wa rahmatullah

Problem - Suppose you have installed the sql server with 'domainname\username' and forgot the enable sa user. for example 'test.com\admin'
Now you join the different domain - 'example.com\admin', now you are trying to access with new domain connection.
your management studio is unable to connect with the current domain user.

Solution - Follow the following step ..

First stop MSSQLSERVER services from the services.
write sqlcmd in run 
SQLCMD run as administrator

c:\> sc start MSSQLSERVER -m (MSSQLSERVER is service name)

C:\>SQLCMD -s GREENTECHAX (GREENTECHAX is instance name)
1>use master
2>go
1>Sp_addsrvrolemember  'fccdynamics\administrator', 'sysadmin'
2>go
1>Sp_addsrvrolemember  'domain\account', 'sysadmin' <CR>
2>Go

After that, Restart the service and start the ssms.
you are able to now connect with new domain.
--

Thanks and Regards

Mohammad Shahnawaz

Passion for Oracle

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