tag:blogger.com,1999:blog-76469209090519718792024-03-18T21:22:13.905-07:00Oracle Apps Technical Oracle Apps Technical BlogSekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.comBlogger21125tag:blogger.com,1999:blog-7646920909051971879.post-536940938505261492015-08-16T23:39:00.000-07:002015-08-16T23:43:05.050-07:00Oracle APPS posts<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="color: #888888; font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;">Ø<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><span dir="LTR"></span>O<span style="background: rgb(237, 244, 255); color: #888888; font-family: "Arial","sans-serif";">racle Inventory Questions and Answers <a href="http://ebiztechnics.blogspot.com/2015/08/Oracle-inventory-questions.html" target="_blank">OracleInventory Q&A</a><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="color: #888888; font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;">Ø<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><span dir="LTR"></span><span style="background: rgb(237, 244, 255); color: #888888; font-family: "Arial","sans-serif";">Oracle Receivables Questions and Answers Part1 <a href="http://ebiztechnics.blogspot.com/2015/08/oracle-receivables-certification.html" target="_blank">OracleReceivables Q&A Part1</a><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="color: #888888; font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;">Ø<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><span dir="LTR"></span><span style="background: rgb(237, 244, 255); color: #888888; font-family: "Arial","sans-serif";">Oracle Receivables Questions and Answers Part2 <a href="http://ebiztechnics.blogspot.com/2015/08/oracle-receivables-questions-and-answers-set2.html" target="_blank">OracleReceivables Q&A Part2</a><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="color: #888888; font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;">Ø<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><span dir="LTR"></span><span style="background: rgb(237, 244, 255); color: #888888; font-family: "Arial","sans-serif";">Oracle Constraints <a href="http://ebiztechnics.blogspot.com/2015/08/Oracle-deferred-constraints.html" target="_blank">OracleConstraints</a><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="color: #888888; font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;">Ø<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><span dir="LTR"></span><span style="background: rgb(237, 244, 255); color: #888888; font-family: "Arial","sans-serif";">Oracle APPS techno functional Q and A <a href="http://ebiztechnics.blogspot.com/2015/08/echno-functional-questions-answers.html" target="_blank">Oracle APPS tech- Fun Q&A</a><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="color: #888888; font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;">Ø<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><span dir="LTR"></span><span style="background: rgb(237, 244, 255); color: #888888; font-family: "Arial","sans-serif";">Oracle Forms Creation (From Procedure) <a href="http://ebiztechnics.blogspot.com/2015/08/oracle-forms-creation-using-database.html" target="_blank">OracleForms Creation</a><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="color: #888888; font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;">Ø<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><span dir="LTR"></span><span style="background: rgb(237, 244, 255); color: #888888; font-family: "Arial","sans-serif";">Oracle Forms issues and Solution <a href="http://ebiztechnics.blogspot.com/2015/08/oracle-forms-issues-and-solutons.html" target="_blank">FormsIssues and Solutions</a><o:p></o:p></span><br />
<div>
<div>
Removing of Duplicate ROWS: <a href="http://goo.gl/wOyzJP">http://goo.gl/wOyzJP</a></div>
<div>
Oracle Order Import Part 2 :<a href="http://goo.gl/cTPkoe"> http://goo.gl/cTPkoe</a></div>
<div>
Orace Order Import Part 1 <a href="http://goo.gl/xDfVYG">http://goo.gl/xDfVYG</a></div>
<div>
Oracle Order Holds Release <a href="http://goo.gl/E8Hvsy">http://goo.gl/E8Hvsy</a></div>
</div>
<div>
</div>
</div>
</div>
Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0tag:blogger.com,1999:blog-7646920909051971879.post-53844447003547211892015-05-28T06:52:00.000-07:002015-09-30T21:48:35.589-07:00Oracle APPS:Procedure Registration<div dir="ltr" style="text-align: left;" trbidi="on">
Procedure Registration Steps:<br />
1)Develop the procedure and compile at SQL prompt<br />
2)Connect application select system administrator Responsbility create<br />
Executable by selecting the Execution Method as 'PL/SQL Stored Procedure'<br />
3)Create Concurrent Program and attach Executable to the Program and add the<br />
Parameters and incompatible programs.<br />
4)Create Request group attach concurrent Progrtam<br />
5)Attach Request group to the reponsibility <span class="Apple-tab-span" style="white-space: pre;"> </span><br />
6)Responsiboility will be added to the user.<br />
User will submit the request from SRS Window.<br />
Syntax:<br />
Create Or Replace Procedure <ProcedureName> (Errbuf OUT varchar2,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> Retcode OUT varchar2,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> P1 IN NUMBER,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> P2 IN VARCHAR2,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> P3 IN DATE) AS<br />
Local variable,Cursor,Collections Declare;<br />
Begin<br />
If statement<br />
For Loop<br />
Procedure Calling<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
DBMS_OUTPUT.Put_Line *********{ -- This will not be used instead of this Fnd_File API will be used}<br />
FND_FILE.PUT_LINE(Fnd_File.Log ,'Message'||Variable Name);<br />
FND_FILE.PUT_LINE(Fnd_File.Output,'Message'||Variable Name);<br />
Exception<br />
When Other then<br />
-Exception Statements;<br />
End <Procedure Name>;<br />
PL/SQL Procedure with Parameter:<br />
================================<br />
If we have any user defined Parameters then we have to register these parameters at the<br />
time of Creating the Concurrent Program by selecting the Parameter button<br />
enter the Seqno<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> Parameter Name<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> Value Set<br />
Note : Token Field will be disabled.<br />
Here First Parameter value will be passed to the first variable<br />
Second Parameter will be passed to the second variable and so on........<br />
When we are registering the report as C.P then only we required TOKEN field.<br />
Because report builder bind variables may or may not be in the sequence that's why<br />
we have to map with Token field.<br />
Where as in Procedure variables position is fixed then TOKEN field will be disabled.</div>
Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0tag:blogger.com,1999:blog-7646920909051971879.post-39155286947750230232015-05-28T06:49:00.001-07:002015-05-28T06:49:30.406-07:00Oracle APPS Reports<div dir="ltr" style="text-align: left;" trbidi="on">
Oracle Apps Standards in Reports Registration:<br />
==============================================<br />
1)Define the Mandatroy parameter called P_CONC_REQUEST_ID<br />
2)Call the Following User exit from the Before report Triggers<br />
SRW.USER_EXIT('FND SRWINIT');<br />
3)Call another User Exit from After Report Trigger<br />
SRW.USR_EXIT('FND SRWEXIT');<br />
User Exit:<br />
==========<br />
It is one of the Oracle Reports 6i Built In program which will be used to stop the report execution and pass the control into some other 3GL and retrieves the data then complete the remaining report execution Process.<br />
<br />
We have 5 User Exits in Oracle Applications:<br />
FND SRWINIT<br />
FND SRWEXIT<br />
FND FLEXSQL<br />
FND FLEXIDVAL<br />
FND FORMATCURRENCY<br />
<br />
FND SRWINIT : This User Exit we will initialize user Profile values we will call this<br />
user exit from Before Report Trigger.<br />
FND SRWEXIT: This User Exit will frees the Memory which is Occupied by the User Profile<br />
values in the server. we will call this from After Report Trigger.<br />
We have Five types of Report Triggers :<br />
Before Parameter Form<br />
After Parameter Form<br />
Before Report Trigger<br />
Between Pages<br />
After Report Trigger<br />
We are using Before Report trigger before data is retrieving from data base system<br />
will capture the user profiles data and as per that data will be retrieved from<br />
database.<br />
Once Output is generated we do not require the Information in the system for that<br />
we are using after Report Trigger call the another User Exit.<br />
P_CONC_REQUEST_ID : This is One of the mandatory parameter we have to define for every<br />
concurrent Program.when we submit C.P from SRS window which will generate the<br />
REQUEST_ID that request ID will be passed into this variable.<br />
Reports parameter (value sets, default types,token)<br />
Request group<br />
Responsibility<br />
user<br />
SRS<br />
user exits.<br />
FND_USER<br />
FND_USER_REPS<br />
<br />
Purchasing = functionality 500<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> Imp tables Join<br />
<br />
01243992026<br />
CARD NO<br />
NAME<br />
CONTACT NO<br />
REASON<br />
12307RS<br />
<div>
<br /></div>
</div>
Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0tag:blogger.com,1999:blog-7646920909051971879.post-84887915885053314832015-05-28T06:43:00.000-07:002015-09-30T21:49:04.808-07:00Oracle APPS :Value sets<div dir="ltr" style="text-align: left;" trbidi="on">
Value Set: Value set is nothing but list of values with validations which will be<br />
used to to restrict the user without entering the invalid data in the Parameters<br />
<br />
we will use value sets in two locations.<br />
1)Concurrent Progam parameters<br />
2)Flexfields<br />
NONE:<br />
----<br />
We are not providing any LOV, we can apply some format conditions as per that<br />
conditions user should enter the data<br />
<br />
Notes: 1)Once we create the Value set we can not Delete if we would like to delete<br />
we have to release the value set from the all the concurrent program<br />
parameters then only we can delete.<br />
2)Value set name is case sensitive<br />
3)Once we create Value set we can use for multiple Program parameters.<br />
<br />
Navigation:<br />
-----------<br />
System administrator => Application=>Validation=>set=><br />
Enter value set name<br />
format type<br />
max size<br />
Select validation type = "None" to create None type of Value sets.<br />
<br />
Independent:<br />
------------<br />
<br />
When we would like to provide list of values to the user then we will go for selection<br />
of Independent value set.where we will provide LOV.<br />
User must select the Value from the list otherwise values are not accepted.<br />
<br />
Open the Value set form create value set by selecting the validation type=Independnent<br />
Goto Values screen enter the value set name , Select Find Buttion<br />
enter the values whatever we would like to display as LOV.<br />
attach the value set to the Parameter.<br />
<br />
Note:1)Once we enter the values we can not delete instead of that we can disable by<br />
selecting the Enabled check box<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> or Effective Dates.<br />
Dependent value Set:<br />
====================<br />
This is another LOV which will be used to displays the<br />
list of values which are depending on the previous parameter value.<br />
<br />
Before going to create Dependent first we have to create Independent<br />
then we have to create Dependent<br />
<br />
First parameter will be Independent<br />
Second parameter will be Dependent.<br />
<br />
Note:Without Independent we can not create Dependent Value set.<br />
<br />
Country<span class="Apple-tab-span" style="white-space: pre;"> </span>IND<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>US<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>UK<br />
City Banglore<span class="Apple-tab-span" style="white-space: pre;"> </span>Chennai <span class="Apple-tab-span" style="white-space: pre;"> </span>Delhi<span class="Apple-tab-span" style="white-space: pre;"> </span> Mumbai Pune<br />
Chikago California Anderson<br />
London Hungrant<br />
<br />
1)We have to create Independent value set and enter the values.<br />
2)Create Dependent value set attach independent and then enter values.<br />
<br />
<br />
Job<span class="Apple-tab-span" style="white-space: pre;"> </span> Manager<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> Developer<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> Programmer<br />
<br />
Position Delivery Manager Project manager Financce manager<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> Software Developer Test Developer<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> Trainee Fresher<br />
Navigation:<br />
==========<br />
1)Open the Value set form create Value set by selecting the validation type =Independent<br />
2)Open the Values screen enter the VAlues .<br />
3)Open the value set form enter Dependent value set by select validation type=Dependent<br />
Select the Button called Edit Information button enter the Independent value set<br />
4)open the values form enter the Dependent value set=>Find<br />
enter the values based on the Independent values.<br />
<br />
Table Value set :<br />
=================<br />
<br />
Table value set will be used to displays the list of values from the<br />
oracle apps base tables.<br />
we have to give the table name and column name which will automatically<br />
displays the values.<br />
<br />
Note: If values are not stored in the database table then we have to<br />
go for Independent value set.<br />
If values are there in the table then we will create table value<br />
set.<br />
<br />
1.Open the value set form Select validation type as table select the<br />
button called Edit Information enter table name and column name<br />
in the value field<br />
2.Use where/Order By clause to implement Where/Order By clause.<br />
3.Use Additional Columns field to displays extra columns for reference<br />
purpose.<br />
4.Use the ID column to pass the internally other columns data<br />
for ex displaying username to the user and pass userID internally.<br />
5.If multiple tables are required then enter the table names in the<br />
table name field with alias name and enter the Join Condition in the<br />
Where clause field.<br />
<br />
6.If we know the table name we can find the Table application name from<br />
Application Developer responsibility<br />
Application Developer => Application => Database => table<br />
Query the records based on the table Name.<br />
<br />
Note: If we are displaying additional Columns we are suppose to give the Alias Name<br />
<br />
Translated Independent and Translated Dependent:<br />
================================================<br />
Both value sets will work like Independent and Dependent value sets<br />
will be used to displays the transalation values which will be enabled<br />
if there is multilanguage implementation.<br />
<br />
Special and Pair:<br />
=================<br />
Both Value sets will be used to displays the Flexfield data as LOV to<br />
the User.</div>
Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0tag:blogger.com,1999:blog-7646920909051971879.post-35445494274114455942015-05-28T06:36:00.000-07:002015-09-30T21:49:32.222-07:00Oracle APPS: what is Mutli ORG?<div dir="ltr" style="text-align: left;" trbidi="on">
Multiorg :<br />
=============<br />
Use a single installation of any Oracle Applications product to<br />
support any number of organizations, even if those organizations<br />
use different sets of books.<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>BusinessGroup (HRMS=>Workstructure=>Organization=Description)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Set of Books (GL=>Setup=>Financials=>Books=>Define)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Legal Entity <br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Operating Unit<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Inventory Organization<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Sub Inventory (Inventory=.Setup=>organizations=>SubInventories)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Stock Locations (Inventory=.Setup=>organizations=>Stock locatiors)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Items<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<br />
Major Features<br />
===============<br />
1)Multiple Organizations in a Single Installation<br />
<br />
2)Secure Access<br />
You can assign users to particular organizations. This ensures accurate<br />
transactions in the correct operating unit.<br />
<br />
3)Multiple Organizations Reporting<br />
<br />
You can set up your Oracle Applications implementation to allow<br />
reporting across operating units by setting up the top reporting level.<br />
You can run your reports at the set of books level, legal entity level, or<br />
operating unit level<br />
<br />
Business Group:<br />
===============<br />
The business group represents the highest level in the organization<br />
structure, such as the consolidated enterprise, a major division, or an<br />
operation company. The business group secures human resources<br />
information. For example, when you request a list of employees, you<br />
see all employees assigned to the business group of which your<br />
organization is a part.<br />
<br />
Set Of Books:<br />
============<br />
A financial reporting entity that uses a particular chart of accounts,<br />
functional currency, and accounting calendar. Oracle General Ledger<br />
secures transaction information (such as journal entries and balances)<br />
by set of books. When you use Oracle General Ledger, you choose a<br />
responsibility that specifies a set of books. You then see information for<br />
that set of books only.<br />
<br />
<br />
Legal Entity:<br />
=============<br />
A legal company for which you prepare fiscal or tax reports. You<br />
assign tax identifiers and other legal entity information to this type of<br />
organization.<br />
<br />
Operating unit:<br />
===============<br />
An organization that uses Oracle Cash Management, Order<br />
Management and Shipping Execution, Oracle Payables, Oracle<br />
Purchasing, and Oracle Receivables. It may be a sales office, a division,<br />
or a department. An operating unit is associated with a legal entity.<br />
Information is secured by operating unit for these applications. Each<br />
user sees information only for their operating unit.<br />
<br />
Inventory Organization:<br />
=======================<br />
An organization for which you track inventory transactions and<br />
balances, and/or an organization that manufactures or distributes<br />
products. Examples include (but are not limited to) manufacturing<br />
plants, warehouses, distribution centers, and sales offices. The<br />
following applications secure information by inventory organization:<br />
Oracle Inventory, Bills of Material, Engineering, Work in Process,<br />
Master Scheduling/MRP, Capacity, and Purchasing receiving functions.<br />
<br />
Subinventory:<br />
=============<br />
Which is another organization inside of the Inventory oganization will<br />
be used to define the locations under these location items will be placed.<br />
<br />
<br />
Multiorg Table:<br />
===============<br />
It is a table contains the data which is relted to multiple operating units<br />
all the multiorg table names will be end with '_ALL'.<br />
<br />
like PO_HEADER_ALL<br />
PO_LINES_ALL<br />
AP_CHECKS_ALL and so on<br />
<br />
Note: In all these tables we will find one common column called "ORG_ID"<br />
This column will be populated internally by the system as per the User Operating<br />
Unit ID<br />
<br />
Client_Info:<br />
===========<br />
It is one the RDBMS vaiabel which contains the User Operating Unit value (ORG_ID)<br />
<br />
Multiorg View:<br />
=================<br />
It is a view which is created based on the Multiorg table which contains the WHERE<br />
clause WHERE Org_ID = :Client_Info.<br />
<br />
Note: While development of RICE Components we are suppose to Use Multiorg Views<br />
not Multi Org Tables.<br />
<br />
Because if we use Multiorg tables we will get all the operating units data<br />
if we use multiorg view we will get the operating units data which is related for that<br />
perticular user .<br />
<br />
<br />
1)What is the Diff between ORG_ID and ORGANIZATION_ID?<br />
Ans)ORG_ID is at Operating Unit Level<br />
ORGANIZATION_ID is at Inventory Organization level<br />
<br />
2)Why the PO Receipt functionality will come at Inventory organization level?<br />
Ans)user is creating receipt means indirectley he will be receiving the materials from<br />
suppliers.materials will be received at Gowdons ,Warehouses,manufcaturing plants<br />
all these organizations will come at Inventory Organization level.<br />
<br />
3)how the System Will Identify user is working for so and so operating Unit?<br />
Ans ) By using following Profile called<br />
MO:Operating Unit<br />
<br />
4)What is Multiorg?<br />
5)What is Client_info?<br />
6)how to Implement Multiorg in Reports and at SQL prompt?<br />
7)What is Business group, Legal Entity,Operating Unit,Inventory Organizations?<br />
8)What are the Modules will come at operating Unit level?<br />
9)What is the flow of Multiorg?<br />
10)How to Identify the Multiorg Table?<br />
11)Wat is the Diff between Multiorg Table and Multiorg View?<br />
12)While Developing RICE Components we will use Multiorg Table or Multiorg View?<br />
13)Why there is no _ALL for PO_VENDORS(11i),R12(AP_suppliers)<br />
and there is _ALL for PO_VENDOR_SITES_ALL(11i)/AP_SUPPlIER_SITES?<br />
Ans)Supplier is global<br />
Supplier site is Org Specific.<br />
14)How will you findout Multiorg Succesfully Implemented?<br />
Ans)<br />
<br />
SELECT MULTI_ORG_FLAG ,RELEASE_NAME FROM FND_PRODUCT_GROUPS<br />
<br />
Y - Succesfully Implemented<br />
N - Not Implemented Succesfully.<br />
<div>
<br /></div>
</div>
Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0tag:blogger.com,1999:blog-7646920909051971879.post-67877196125806317882015-05-28T06:32:00.002-07:002015-09-30T21:50:39.295-07:00Oracle APPS:Profiles<div dir="ltr" style="text-align: left;" trbidi="on">
Profile :<br />
Profile is one of the changable option it will change the way of<br />
application execution.<br />
When User Log in to the application and select the the resp or Appl<br />
system will automatically captures all the profile value as per the<br />
profile values application will run.<br />
Ex: If client have three Organizations 1)Hyd<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> 2)Ban<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> 3)Chn<br />
If "hyd" users connect to the Application system will retrive the<br />
data from database which is related to the Hyderabad branch.<br />
If user is working for 'CHN' brnach then chennai branch setups or data<br />
will be retrieved.<br />
For every user we will assign the Profile value<br />
Ex: Operation <br />
Position - Profile Name<br />
Profile Values<br />
--------------<br />
Manager<br />
Supervisior<br />
Clerk<br />
Operator<br />
Trainess<br />
When we want assign any profile value we have four levels<br />
we have to select any one of the level.<br />
Profile Level<span class="Apple-tab-span" style="white-space: pre;"> </span>Profile Profile Value<br />
-------------<span class="Apple-tab-span" style="white-space: pre;"> </span>------- --------------<br />
User<span class="Apple-tab-span" style="white-space: pre;"> </span>- OPERATIONS - Print - 10(This is for for Operations)<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
Responsibility - 22Responsi - Print - 5(This is for 22resp users)<br />
Application - GL Applica - Print - 4(This is for GL App Users)<br />
Site<span class="Apple-tab-span" style="white-space: pre;"> </span>- --- - Print - 2(This is for ALL Users)<br />
Site : this is lowest level to assign the Profile values site values<br />
are applicable for all the users.when we install Application by default<br />
site level values will be assigned.<br />
Application: These values are applicable for the users who are having<br />
the access for the application. If user is eligible for both<br />
application and site level values then application level value will<br />
override the site level value.<br />
Responsibility:We will select the responsibility name assign the value<br />
which is applicable only for the users who are having the access for<br />
specified responsibility.<br />
Responsibility level value will override both application and site<br />
level values.<br />
User: This is highest level in the profile option.<br />
we will select the user name and assign the profile value which is<br />
applicable only for this user.<br />
User level value will override all other profile level values.<br />
<br />
Diff between Application and Responsibility:<br />
============================================<br />
Both are Group of Forms(Menu)<br />
Group of ConcurrentPrograms(Request Group)<br />
Group of Users (Data group)<br />
But Application as per the Business functionality requirement<br />
Responsibility will group as per the position requirement.<br />
Some of the Imp Profile Names:<br />
MO:Operating Unit<br />
Hr:Business Groups<br />
MFG_ORGANIZATION_ID<br />
USER_ID<br />
RESP_ID<br />
USERNAME<br />
RESP_NAME and so on..........<br />
<div>
<br /></div>
</div>
Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0tag:blogger.com,1999:blog-7646920909051971879.post-55972797401834080982015-05-28T06:27:00.000-07:002015-05-28T06:27:58.795-07:00User Creation<div dir="ltr" style="text-align: left;" trbidi="on">
Creation of New User:<br />
1)Open the internet Explorer connect to Oracle Applications<br />
2)Enter the User Name :OPERATIONS<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> Password :WELCOME<br />
3)Select the Responsibility called 'System Administrator'<br />
4)Open the User form.<br />
Security => User =>Define<br />
5)Enter User Name and Password attach the Responsibilities whatever we required<br />
for ex System Administrator<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> Application Developer<br />
<br />
6)Exit from the Appication<br />
File => Exit Oracle Applications<br />
7)Connect to Oracle apps enter new user name password system will shows the message<br />
like 'Password Has Expired'<br />
8)Enter the New Password Press Ok Button<br />
Short Cuts:<br />
===========<br />
1)To Query All the Records Press CTRL+F11<br />
2)To Query Specific Records<br />
i)Open the Form<br />
ii)Press F11 (Form will comes into Query mode)<br />
iii)Enter Search Criteria in any field<br />
iV)Press CTRL+F11<br />
3)To Close Form = F4<br />
5)To Save the Records CTRL+S<br />
<br />
Effective Date From and To:<br />
===========================<br />
In most of the Oracle Application forms we will find two field like<br />
Effective Date From<br />
Effective Date To<br />
<br />
In some of the forms once we create records and save. We can not delete from database<br />
that time we can go for Disable/Enable the record by using these two fields<br />
<br />
Finding Table NameS/Column Names:<br />
=================================<br />
<br />
1)Help => Record History which will shows the Table Name<br />
2)Help Menu=>Diagnastics=>Examine=>Enter the Password(APPS)=>We can find the Column Name<br />
WHO Columns:<br />
=============<br />
WHO Column Will be used to find out the History of the record<br />
we can find from front End Also<br />
Help=>Record History<br />
<br />
CREATED_BY - Which User has created the Record(Userid)<br />
CREATION_DATE - at what time user has created (SYSDATE)<br />
LAST_UPATED_BY -Which User has updated recentley(UserID)<br />
LAST_UPDATE_DATE -at what time user has Updated (SYSDATE)<br />
LAST_LOGON_DATE - At what time user last Login Time<br />
<br />
Find the Login UserName:<br />
==========================<br />
Help Menu=>About Oracle Applications<br />
<br /></div>
Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0tag:blogger.com,1999:blog-7646920909051971879.post-58193210562405808852015-05-06T10:48:00.000-07:002015-05-15T21:48:42.778-07:00Who Columns In Oracle Apps<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
Creation of New User:<br />
1)Open the internet Explorer connect to Oracle Applications<br />
2)Enter the User Name :OPERATIONS<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> Password :WELCOME<br />
3)Select the Responsibility called 'System Administrator'<br />
4)Open the User form.<br />
Security => User =>Define<br />
5)Enter User Name and Password attach the Responsibilities whatever we required<br />
for ex System Administrator<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> Application Developer<br />
6)Exit from the Appication<br />
File => Exit Oracle Applications<br />
7)Connect to Oracle apps enter new user name password system will shows the message<br />
like 'Password Has Expired' <br />
8)Enter the New Password Press Ok Button<br />
<br />
Short Cuts:<br />
===========<br />
<br />
1)To Query All the Records Press CTRL+F11<br />
2)To Query Specific Records<br />
i)Open the Form<br />
ii)Press F11 (Form will comes into Query mode)<br />
iii)Enter Search Criteria in any field<br />
iV)Press CTRL+F11<br />
3)To Close Form = F4<br />
5)To Save the Records CTRL+S<br />
<br />
<br />
Effective Date From and To:<br />
===========================<br />
In most of the Oracle Application forms we will find two field like<br />
Effective Date From<br />
Effective Date To<br />
In some of the forms once we create records and save. We can not delete from database<br />
that time we can go for Disable/Enable the record by using these two fields<br />
Finding Table NameS/Column Names:<br />
=================================<br />
1)Help => Record History which will shows the Table Name<br />
2)Help Menu=>Diagnastics=>Examine=>Enter the Password(APPS)=>We can find the Column Name<br />
WHO Columns:<br />
=============<br />
WHO Column Will be used to find out the History of the record<br />
we can find from front End Also<br />
Help=>Record History<br />
CREATED_BY - Which User has created the Record(Userid)<br />
CREATION_DATE - at what time user has created (SYSDATE)<br />
LAST_UPATED_BY -Which User has updated recentley(UserID)<br />
LAST_UPDATE_DATE -at what time user has Updated (SYSDATE)<br />
LAST_LOGON_DATE - At what time user last Login Time<br />
<br />
Find the Login UserName:<br />
==========================<br />
Help Menu=>About Oracle Applications<br />
<div>
<br /></div>
</div>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-18651341-3', 'auto');
ga('send', 'pageview');
</script></div>
Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0tag:blogger.com,1999:blog-7646920909051971879.post-60546597080047415252015-04-29T05:02:00.001-07:002015-04-29T05:02:16.200-07:00Oracle SQL Loader<div style="text-align: left;">
SIMPLE CONTROL FILE USING SINGLE DATA FILE<br />
<br />
1.create table in scott and give grant to apps then create synonym in app<br />
<br />
create table emp3(empno number(10),ename varchar2(10),job varchar2(10),sal number(10,2))<br />
<br />
SQL> /<br />
<br />
Table created.<br />
<br />
SQL> grant all on emp3 to apps;<br />
<br />
Grant succeeded.<br />
<br />
SQL> conn apps/apps@prod<br />
Connected.<br />
SQL> create public synonym emp3 for scott.emp3;<br />
<br />
Synonym created.<br />
<br />
SQL> desc emp3;<br />
Name Null? Type<br />
----------------------------------------------------- -------- ------------------------------------<br />
EMPNO NUMBER(10)<br />
ENAME VARCHAR2(10)<br />
JOB VARCHAR2(10)<br />
SAL NUMBER(10,2)<br />
<br />
2.data file<br />
<br />
3.control file<br />
4.RUN CMD THEN GIVE COMMAND AS<br />
D:\ORACLE\PRODDB\8.1.7\BIN> SQLLDR APPS/APPS@PROD<br />
CONTROL =D:\DATA\EMP3.CTL<br />
<br />
5.GOTO SQL PROMPT THEN VIEW THE OUT PUT:<br />
<br />
SQL> SELECT * FROM EMP3;<br />
<br />
EMPNO ENAME JOB SAL<br />
---------- ---------- ---------- ----------<br />
100 'smith' 'mgr' 7000<br />
200 'ramu' 'clerk' 4000<br />
300 'raju' 'act' 6000<br />
<br />
SQL><br />
<br />
Multiple Data Files Into Single Database table using single control file<br />
<br />
1.Create second data file:<br />
111,'RAVI','MGR',7000<br />
222,'KIRAN','CLERK',4000<br />
333,'CHANDRA','ASTMGR',10000<br />
<br />
save this as EMP4.DAT in same directory<br />
<br />
<br />
2.Goto control file then assign this file as second infile to control file<br />
<br />
controlfile:<br />
<br />
<br />
load data<br />
infile 'd:\data\emp3.dat'<br />
infile 'd:\data\EMP4.dat'<br />
insert into table emp3<br />
fields terminated by ','<br />
(empno<br />
,ename<br />
,job<br />
,sal<br />
)<br />
<br />
3.Again run cmd as above<br />
<br />
4.goto backend view data<br />
<br />
SQL> select * from emp3;<br />
<br />
EMPNO ENAME JOB SAL<br />
---------- ---------- ---------- ----------<br />
111 'RAVI' 'MGR' 7000<br />
222 'KIRAN' 'CLERK' 4000<br />
333 'CHANDRA' 'ASTMGR' 10000<br />
100 'smith' 'mgr' 7000<br />
200 'ramu' 'clerk' 4000<br />
300 'raju' 'act' 6000<br />
<br />
6 rows selected.<br />
Control file using sql functions<br />
<br />
1) Assign the sql functions to the columns in Control file<br />
<br />
load data<br />
infile 'D:\DATA\emp3.dat'<br />
infile 'D:\DATA\EMP4.dat' <br />
insert<br />
into table emp3<br />
(<br />
empno "S1.NEXTVAL",<br />
ename POSITION(4:7) "UPPER(:ENAME)",<br />
job POSITION(8:10) "INITCAP(:JOB)",<br />
sal POSITION(11:14) "NVL(:SAL*10,0)"<br />
)<br />
into table emp4 when projno!=' '<br />
( <br />
empno "S1.NEXTVAL",<br />
ename POSITION(4:7) "UPPER(:ENAME)",<br />
job POSITION(8:10) "INITCAP(:JOB)",<br />
sal POSITION(11:14) "NVL(:SAL*10,0)",<br />
projno POSITION(15:17)<br />
)<br />
2<br />
AGAIN RUN CMD:<br />
<br />2. THEN VIEW THE DATA IN BACK END AS:<br />
<br />
SQL> SELECT * FROM EMP3;<br />
<br />
EMPNO ENAME JOB SAL<br />
---------- ---------- ---------- ----------<br />
192 RAVI Mgr 70000<br />
193 RAJU Mgr 40000<br />
194 CHAN Mgr 10000<br />
186 RAVI Mgr 70000<br />
187 RAJU Mgr 40000<br />
188 CHAN Mgr 10000<br />
<br />
6 rows selected.<br />
<br />
SQL> SELECT * FROM EMP4;<br />
<br />
EMPNO ENAME JOB SAL PROJNO<br />
---------- ---------- ---------- ---------- ----------<br />
195 RAVI Mgr 70000 120<br />
196 RAJU Mgr 40000 121<br />
197 CHAN Mgr 10000 122<br />
189 RAVI Mgr 70000 120<br />
190 RAJU Mgr 40000 121<br />
191 CHAN Mgr 10000 122<br />
<br />
6 rows selected.<br />
Using where clause in control file to update data into multiple tables<br />
Multiple data files and Multiple tables<br />
<br />
<br />
1.Create 2 tables and 2 data files<br />
first is emp3 which is already created<br />
Now created second table<br />
CREATE TABLE EMP4 AS SELECT * FROM EMP3 WHERE 1=2<br />
<br />
1.1ALTER TABLE EMP4 ADD PROJNO NUMBER; /*for additing additional column for secondtable */<br />
<br />
SQL> DESC EMP4;<br />
Name Null? Type<br />
----------------------------------------------------- -------- ----------------------<br />
EMPNO NUMBER(10)<br />
ENAME VARCHAR2(10)<br />
JOB VARCHAR2(10)<br />
SAL NUMBER(10,2)<br />
PROJNO NUMBER<br />
<br />
<br />
SQL> GRANT ALL ON EMP4 TO APPS;<br />
<br />
Grant succeeded.<br />
<br />
SQL> CONN APPS/APPS@PROD<br />
Connected.<br />
SQL> CREATE PUBLIC SYNONYM EMP4 FOR SCOTT.EMP4;<br />
<br />
Synonym created.<br />
<br />
2.create datafile as emp3<br />
<br />
111RAVIMGR7000120<br />
222RAJUMGR4000121<br />
333CHANMGR1000122<br />
<br />
3.create data file as emp4<br />
<br />
111RAVIMGR7000120<br />
222RAJUMGR4000121<br />
333CHANMGR1000122<br />
<br />
4.create control file as<br />
<br />
<br />
load data<br />
infile 'D:\DATA\emp3.dat'<br />
infile 'D:\DATA\EMP4.dat'<br />
insert<br />
into table emp3<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
(<br />
empno POSITION(1:3),<br />
ename POSITION(4:7),<br />
job POSITION(8:10),<br />
sal POSITION(11:14)<br />
)<br />
into table emp4 when projno!=' '<br />
(empno POSITION(1:3),<br />
ename POSITION(4:7),<br />
job POSITION(8:10),<br />
sal POSITION(11:14),<br />
projno POSITION(15:17)<br />
)<br />
<br />
<br />
save;<br />
<br />
5.run cmd as usual<br />
<br />
<br />
6.view the output in backend<br />
<br />
<br />
SQL> select * from emp3;<br />
<br />
EMPNO ENAME JOB SAL<br />
---------- ---------- ---------- ----------<br />
111 RAVI MGR 7000<br />
222 RAJU MGR 4000<br />
333 CHAN MGR 1000<br />
111 RAVI MGR 7000<br />
222 RAJU MGR 4000<br />
333 CHAN MGR 1000<br />
<br />
6 rows selected.<br />
<br />
SQL> select * from emp4;<br />
<br />
EMPNO ENAME JOB SAL PROJNO<br />
---------- ---------- ---------- ---------- ----------<br />
111 RAVI MGR 7000 120<br />
222 RAJU MGR 4000 121<br />
333 CHAN MGR 1000 122<br />
111 RAVI MGR 7000 120<br />
222 RAJU MGR 4000 121<br />
333 CHAN MGR 1000 122<br />
<br />
6 rows selected.<br />
<br />
<br />
Using commit in control files for each 10 records<br />
<br />
<br />
1 .we will create a sequence as s1<br />
<br />
<br />
SQL> CONN SCOTT/TIGER@PROD<br />
Connected.<br />
SQL> CREATE SEQUENCE S1 INCREMENT BY 1 START WITH 100;<br />
<br />
Sequence created.<br />
<br />
SQL> conn apps/apps@prod<br />
Connected.<br />
2.then we will create control file as<br />
<br />
<br />
load data<br />
infile 'D:\DATA\emp3.dat'<br />
infile 'D:\DATA\EMP4.dat'<br />
insert<br />
into table emp3<br />
(<br />
empno "S1.NEXTVAL",<br />
ename POSITION(4:7),<br />
job POSITION(8:10),<br />
sal POSITION(11:14)<br />
)<br />
into table emp4 when projno!=' '<br />
( <br />
empno "S1.NEXTVAL",<br />
ename POSITION(4:7),<br />
job POSITION(8:10),<br />
sal POSITION(11:14),<br />
projno POSITION(15:17)<br />
)<br />
<br />
then save;<br />
<br />
4.then run as usual.<br />
<br />
<br />
<br />
<br />
5 .view the data from backend as<br />
SQL> /<br />
<br />
EMPNO ENAME JOB SAL<br />
---------- ---------- ---------- ----------<br />
106 RAVI MGR 7000<br />
107 RAJU MGR 4000<br />
108 CHAN MGR 1000<br />
100 RAVI MGR 7000<br />
101 RAJU MGR 4000<br />
102 CHAN MGR 1000<br />
<br />
6 rows selected.<br />
<br />
SQL> ed<br />
Wrote file afiedt.buf<br />
<br />
1* select * from emp4<br />
SQL> /<br />
<br />
EMPNO ENAME JOB SAL PROJNO<br />
---------- ---------- ---------- ---------- ----------<br />
109 RAVI MGR 7000 120<br />
110 RAJU MGR 4000 121<br />
111 CHAN MGR 1000 122<br />
103 RAVI MGR 7000 120<br />
104 RAJU MGR 4000 121<br />
105 CHAN MGR 1000 122<br />
<br />
6 rows selected<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
To Create Commit Statement in cmd Prompt<br />
<br />
<br />
<br />
GOTO RUN CMD AND GIVE COMMAND AS TO FOR EVERY 2 RECORDS<br />
<br />
TO SKIP RECORDS FROM LOADING USING SKIP KEYWORDS IN CONTROL FILE<br />
GO TO RUN CMD:THEN GIVE THE COMMAND AS:<br />
<br />
Goto backend and view the data:<br />
<br />
SQL> SELECT * FROM EMP3;<br />
<br />
EMPNO ENAME JOB SAL<br />
---------- ---------- ---------- ----------<br />
148 CHAN MGR 1000<br />
<br />
<br />
TO SKIP COLUMNS IN CONTROL FILES USING FILLER KEYWORD<br />
Use the FILLER keyword in control files as:<br />
<br />
load data<br />
infile 'D:\DATA\emp3.dat'<br />
infile 'D:\DATA\EMP4.dat' <br />
insert<br />
into table emp3<br />
(<br />
empno "S1.NEXTVAL",<br />
ename POSITION(4:7),<br />
job filler,<br />
sal POSITION(11:14)<br />
)<br />
into table emp4 when projno!=' '<br />
( <br />
empno "S1.NEXTVAL",<br />
ename POSITION(4:7),<br />
job POSITION(8:10),<br />
sal POSITION(11:14),<br />
projno POSITION(15:17)<br />
)<br />
<br />
Then goto run cmd give the command as usual:<br />
Then view the data in backend :<br />
<br />
SQL> select * from emp3;<br />
<br />
EMPNO ENAME JOB SAL<br />
---------- ---------- ---------- ----------<br />
150 RAVI <span class="Apple-tab-span" style="white-space: pre;"> </span> 7000<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
151 RAJU 4000<br />
152 CHAN 1000<br />
156 RAVI 7000<br />
157 RAJU 4000<br />
158 CHAN 1000<br />
<br />
6 rows selected.<br />
<br />
SQL> select * from emp4;<br />
<br />
EMPNO ENAME JOB SAL PROJNO<br />
---------- ---------- ---------- ---------- ----------<br />
153 RAVI MGR 7000 120<br />
154 RAJU MGR 4000 121<br />
155 CHAN MGR 1000 122<br />
159 RAVI MGR 1000 120<br />
160 RAJU MGR 4000 121<br />
161 CHAN MGR 1000 122<br />
<br />
6 rows selected.<br />
<div>
<br /></div>
</div>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-18651341-3', 'auto');
ga('send', 'pageview');
</script>
Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0tag:blogger.com,1999:blog-7646920909051971879.post-32585055000749740982015-04-28T05:23:00.001-07:002015-04-28T06:34:06.562-07:00Oracle Joins <div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Type of joins<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">-------------</span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">(8i and Prior) Compliant
Joins<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">------------------------ -----------------<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">- Equijoin -
Cross Joins<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">- Non-Equijoin -
Natural Joins<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">- Outer Join -
Using Clause<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">- Self Join - Full or Two sided outer joins<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> -
Arbitrary join conditions for outer joins<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">1. Use a join to
query data from more than one table<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> SELECT table1.column, table2.column<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> FROM table1<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> [CROSS JOIN table2]|<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> [NATURAL JOIN table2] |<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> [JOIN table2 USING { column_name } ]
|<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> [JOIN table2 ON (table1.column_name=
table2.column_name)] | <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> [LEFT | RIGHT | FULL OUTER JOIN
table2 ON (table1.column_name = table2.column_name ) ];<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">2. Eg Cross
join:<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> SELECT ename,dname<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> FROM emp<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> CROSS JOIN DEPT;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">3. NATURAL JOIN<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">---------------<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">- NATURAL JOIN
clause is based on all columns in the two tables that have the same name.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">- It selects
rows from the two tables that have equal values in all matched columns<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">- If the columns
having the same names have different data types , an error is returned<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">In oracle 9i it
is possible to let the join be completed automatically based on columns in the<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">two tables which
have matching data types and names using the keywords NATURAL JOIN.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Eg: SELECT deptno,dname,ename,empno<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> FROM DEPT<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> NATURAL JOIN EMP<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> OR<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> SELECT deptno,dname,empno,ename<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> FROM EMP , DEPT<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> WHERE EMP.DEPTNO= DEPT.DEPTNO<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Natural Joins
with WHERE clause<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> Additional restrictions on a natural
join are implemented by using a WHERE clause. The<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">example<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">SELECT
deptno,dname,ename,sal<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">FROM DEPT<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">NATURAL JOIN emp<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">WHERE deptno IN
(20,30)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">4. NATURAL JOINS
WITH THE USING CLAUSE<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">---------------------------------------<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">- If several
columns have the same names but the data types do not match, The NATURAL JOIN<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">clause can be
modified with the USING clause to specify the columns that should be used for<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">an equijoin<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">- Use the USING
clause to match only one column when more thatn one column matches<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">- Do not use
table name or alias in the referenced columns<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">- The NATURAL
JOIN and USING clauses are mutually exclusive.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">- The columns
referenced in the USING clause should not have a qualifier (table name or alias)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">anywhere in the
SQL statement<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">SELECT
E.ENAME,D.DNAME<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">FROM EMP E JOIN
DEPT D USING (Deptno)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">WHERE Deptno=30;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">error coz we can
use alias or depts refered in join in either select or where clause<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">SELECT
E.ENAME,D.DNAME<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">FORM EMP E JOIN
DEPT D <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">USING (DEPTNO);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> or<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">SELECT ENAME,DNAME<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">FORM EMP , DEPT<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">WHERE
EMP.DEPTNO=DEPT.DEPTNO<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">5. CREATING
JOINS WITH THE ON CLAUSE<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">--------------------------------------<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">- The join
condition for the natural join is basically an equi join of all columns with the
same <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">name<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">- To specify
arbitrary conditions or specify columns to join, the ON clause is used.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">- The ON clause
makes code easy to understand<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Eg<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> SQL> SELECT
E.ENAME,E.EMPNO,D.DNAME<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">
2 FROM EMP E<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">
3 JOIN DEPT D<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">
4 USING (DEPTNO);<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> or<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> SQL> ed<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">
1 SELECT ENAME,DNAME<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">
2 FROM EMP<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">
3 JOIN DEPT<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">
4* USING (DEPTNO)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">THREE WAY JOINS
WITH THE ON CLAUSE<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">----------------------------------<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">SELECT
EMPNO,ENAME,DNAME,SALGRADE<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">FROM EMP E<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">JOIN DEPT D<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">ON D.DEPTNO =
E.DEPTNO<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">JOIN DEPT1 D1<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">ON
D1.DEPTNO=E.DEPTNO<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">JOINS COMPARING
SQL to oracle syntax<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">----------------------------------------------------<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">ORACLE SQL
1999<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">---------------------------------------------------<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">EQUI-JOIN NATURAL/INNER JOIN<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">OUTER-JOIN LEFT OUTER
JOIN<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">SELF-JOIN JOIN ON<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">NON-EQUI-JOIN JOIN USING<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">CARTESIAN
PRODUCT CROSS JOIN<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">---------------------------------------------------<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">6. LEFT OUTER
JOIN<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">-------------------<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> SELECT
E.ENAME,E.DEPTNO,D.DNAME<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> FROM EMP E<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> LEFT OUTER JOIN DEPT D-> (+) will on this
table<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> ON (E.DEPTNO=D.DEPTNO)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> OR<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> 1
SELECT E.ENAME,E.DEPTNO,D.DNAME<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> 2 FROM
EMP E,DEPT D<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> 3* WHERE E.DEPTNO=D.DEPTNO(+)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> OR<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> 1
SELECT E.ENAME,E.DEPTNO,D.DNAME<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> 2 FROM
EMP E,DEPT D<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> 3* WHERE D.DEPTNO(+)=E.DEPTNO<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">7. RIGHT OUTER
JOIN:<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">---------------------<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> SELECT E.ENAME,E.DEPTNO,D.DNAME<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> FROM EMP E->(+) will b on this table<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> RIGHT OUTER JOIN DEPT D<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> ON(E.DEPTNO=D.DEPTNO)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> or<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> 1
SELECT E.ENAME,E.DEPTNO,D.DNAME<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> 2 FROM
EMP E,DEPT D<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> 3* WHERE D.DEPTNO=E.DEPTNO(+)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">SQL> / <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">OUTER-JOIN:<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">-------------<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">-> To join n
tables together, you need a minimum of n-1 join conditions. This rule may not<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">apply if your
table has a concatenated primary key, in which case more than one column<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">is required to
uniquely identify each row.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">-> The operator
is a plus sign enclosed in brackets and "it is placed on the side of the
join<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">that is
deficient in information" ie OUTER JOIN<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">This operator
has the effect of creating one or more null rows, to which one or more row from<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">the nondeficient
table can be joined.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Table.column =
is the condition that joins the tables together<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">table.column(+) is the outer join symbol, which can be placed
on either side of the where<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">clause condition
but not on both sides. place the outer join symbol follwing the name of the<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">column in the
table without the matching rows.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">- the outer join
operator can appear on only one side of the expression the side that has <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">information
missing. It returns those rows from one table that have no direct match in the<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">other table.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">- A condition
involving an outer join cannot use the IN operator or b linked to another <o:p></o:p></span><span style="font-family: Times New Roman, serif;">condition</span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">by the OR operator.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Eg: SELECT
E.ENAME,E.EMPNO,E.MGR,M.EMPNO,M.ENAME<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">FROM EMP E,EMP M<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">WHERE
E.MGR=M.EMPNO(+)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">--The above
query gives all the employee details whose empno = mgrno which implies they are
<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">--managers and
we want the details of all employee (empno) who have mgr no or not ie whether<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">-- that empno
has mgr or not it displays all the empno's and if any empno doesnt have mgr
then<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">-- implies that
employee doesnt have manager like the empno=7839 ename =KING<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">8. FULL OUTER
JOIN:<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">--------------------<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">SELECT
E.ENAME,E.DEPTNO,D.DNAME<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">FROM EMP E<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">FULL OUTER JOIN
DEPT D<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">ON
(E.DEPTNO=D.DEPTNO)<o:p></o:p></span></div>
</div>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-18651341-3', 'auto');
ga('send', 'pageview');
</script>
</div>
Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0tag:blogger.com,1999:blog-7646920909051971879.post-70996656283679991672015-04-26T05:49:00.002-07:002015-04-26T08:09:38.109-07:00FlexField Concepts<div style="text-align: left;">
OVERVIEW OF FLEXFIELD CONCEPTS<br /><br />A flexfield is a field made up of sub-fields, or segments. A flexfield appears on your form as a pop-up window that contains a prompt for each segment. Each segment has a name and a set of valid values. There are two types of flexfields: key flexfields and descriptive flexfields. <br /><br />BASIC FLEXFIELD CONCEPTS<br /><br />Segment - A segment is a single sub-field within a flexfield. You define the appearance and meaning of individual segments when customizing a flexfield. A segment is represented in your database as a single table column.<br /><br />For a key flexfield, a segment usually describes a particular characteristic of the entity identified by the flexfield. For example, you can have a key flex field that stores part numbers. The key flexfield can contain the part number PAD-YEL-NR-8 1/2x14, which represents a yellow, narrow ruled, 8 1/2" x 14" note pad. Each section in the part number, separated by a hyphen, describes a characteristic of the part. The first segment describes the object, a note pad, the second segment describes the color of the object, yellow, and so on.<br /><br />Note that we also refer to the fields in a descriptive flexfield pop-up window as segments even though they do not necessarily make up meaningful codes like the segments in key flexfields. However, they do often describe a particular characteristic of the entity identified elsewhere on the form you are using.<br /><br />Values, Validation and Value Sets - Your end user enters a segment value into a segment while using an application. Generally, the flexfield validates each segment against a set of valid values (a "value set") that are usually predefined. To "validate a segment" means that the flexfield compares the value a user enters in the segment against the values in the value set for that segment.<br /><br />You can set up your flexfield so that it automatically validates segment values your end user enters against a table of valid values. If your end user enters an invalid segment value, a list of valid values appears automatically so that the user can choose a valid value. You can think of a value set as a "container" for your values. You choose what types of values can fit into your value set: their length, format, and so on.<br /><br />A segment is usually validated, and usually each segment in a given flexfield uses a different value set. You can assign a single value set to more than one segment, and you can even share value sets among different flexfields. For most value sets, when you enter values into a flexfield segment, you can enter only values that already exist in the value set assigned to the segment.<br /><br />Structure - A flexfield structure is a specific configuration of segments. If you add or remove segments, or rearrange the order of segments in a flexfield, you get a different structure.<br /><br />You can define multiple segment structures for the same flexfield (if that flexfield has been built to support more than one structure). Your flexfield can display different prompts and fields for different end users based on a data condition in your form or application data. Both key and descriptive flexfields may allow more than one structure.<br /><br />In some applications, different users may need a different arrangement of the segments in a flexfield (key or descriptive). Or, you might want different segments in a flexfield depending on, for example, the value of another form or database field.<br /><br />Your Oracle General Ledger application, for example, provides different Accounting Flexfield (Chart of Accounts) structures for users of different sets of books. The Oracle General Ledger application determines which flexfield structure to use based on the value of the GL Set of Books Name user profile option.</div>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-18651341-3', 'auto');
ga('send', 'pageview');
</script>
Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0tag:blogger.com,1999:blog-7646920909051971879.post-72280847626377591402015-04-24T11:49:00.001-07:002015-05-08T09:30:32.212-07:00SUBSTR INSTR<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
SUBSTR<br />
<br />
Oracle/PLSQL: SUBSTR Function<br />
This Oracle tutorial explains how to use the Oracle/PLSQL SUBSTR function with syntax and examples.<br />
Description<br />
The Oracle/PLSQL SUBSTR functions allow you to extract a substring from a string.<br />
<br />
Syntax<br />
The syntax for the SUBSTR function in Oracle/PLSQL is:<br />
<br />
SUBSTR( string, start_position [, length ] )<br />
Parameters or Arguments<br />
string<br />
The source string.<br />
start_position<br />
The starting position for extraction. The first position in the string is always 1.<br />
length<br />
Optional. It is the number of characters to extract. If this parameter is omitted, the SUBSTR function will return the entire string.<br />
<br />
Note:<br />
If start_position is 0, then the SUBSTR function treats start_position as 1 (ie: the first position in the string).<br />
If start_position is a positive number, then the SUBSTR function starts from the beginning of the string.<br />
If start_position is a negative number, then the SUBSTR function starts from the end of the string and counts backwards.<br />
If length is a negative number, then the SUBSTR function will return a NULL value.<br />
<br />
Applies To<br />
The SUBSTR function can be used in the following versions of Oracle/PLSQL:<br />
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i<br />
<br />
Example<br />
Let's look at some Oracle SUBSTR function examples and explore how to use the SUBSTR function in Oracle/PLSQL.<br />
<br />
For example:<br />
SUBSTR('This is a test', 6, 2)<br />
Write Output<br />
SUBSTR('This is a test', 6)<br />
Write Output<br />
SUBSTR('Chandra Sekhar', 1, 4)<br />
Write Output<br />
SUBSTR('Chadra Sekhar', -3, 3)<br />
Write Output<br />
SUBSTR('Chandra Sekhar', -6, 3)<br />
Write ouput<br />
SUBSTR('Chandra Sekhar', -8, 2)<br />
Result: 'On'<br />
<br />
INSTR<br />
<br />
The Oracle INSTR function searches inside a string for a substring. The Oracle INSTR function works in a way similar to the SUBSTR function, but INSTR returns an integer number indicating the position of the substring within the string, rather than returning the substring itself.<br />
Note: For more complex string handling functions, you can make use of Regular Expressions by using the extended version of the INSTR function named REGEXPR_INSTR.<br />
<br />
Example Syntax:<br />
<br />
INSTR( source_string, substring [, start_position [, occurrence ] ] )<br />
<br />
Source_string is the string to be searched.<br />
<br />
substring is the character string to be searched for inside of source_string.<br />
<br />
Start_position is an optional argument. It is an integer value that tells Oracle where to start searching in the source_string. If the start_position is negative, then Oracle counts back that number of characters from the end of the source_string and then searches backwards from that position. If omitted, this defaults to 1.<br />
<br />
Occurrence is an integer indicating which occurrence of substring Oracle should search for. That is, should INSTR return the first matching substring, the second matching substring, etc. This argument is optional. If omitted, it defaults to 1.<br />
<br />
If the sub string is not found in source string, the Oracle INSTR function will return 0.<br />
<br />
INSTR('ABC-DC-F','-',2) output 7 (2nd occurence of '-')<br />
<br />
Question on Instr/Sub string<br />
<br />
<span style="background-color: white; color: #222222; font-family: arial; font-size: x-small;">There is a path in obiee where it is showing as /shared/financials/. In this string, want to get the value after second special character ('/') to before third special character ('/'). </span><br />
<br style="background-color: white; color: #222222; font-family: arial; font-size: small;" />
<span style="background-color: white; color: #222222; font-family: arial; font-size: x-small;">That means i should get the value "financials". </span><br />
<br />
Solution<br />
<span style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 12.8000001907349px;"><br /></span>
<span style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 12.8000001907349px;">select substr(:a,instr(:a,'/',1,2)+1,</span><wbr style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 12.8000001907349px;"></wbr><span style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 12.8000001907349px;">length (:a)) from dual</span><br />
<div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 12.8000001907349px;">
<br /></div>
<div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 12.8000001907349px;">
Pass your string for variable you can get the desired results</div>
<div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 12.8000001907349px;">
<br /></div>
<br />
<br />
<br />
Notes On Date Data Type<br />
<br />
YEAR Year, spelled out<br />
YYYY 4-digit year<br />
YYY<br />
YY<br />
Y Last 3, 2, or 1 digit(s) of year.<br />
IYY<br />
IY<br />
I Last 3, 2, or 1 digit(s) of ISO year.<br />
IYYY 4-digit year based on the ISO standard<br />
Q Quarter of year (1, 2, 3, 4; JAN-MAR = 1).<br />
MM Month (01-12; JAN = 01).<br />
MON Abbreviated name of month.<br />
MONTH Name of month, padded with blanks to length of 9 characters.<br />
RM Roman numeral month (I-XII; JAN = I).<br />
WW Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year.<br />
W Week of month (1-5) where week 1 starts on the first day of the month and ends on the seventh.<br />
IW Week of year (1-52 or 1-53) based on the ISO standard.<br />
D Day of week (1-7).<br />
DAY Name of day.<br />
DD Day of month (1-31).<br />
DDD Day of year (1-366).<br />
DY Abbreviated name of day.<br />
J Julian day; the number of days since January 1, 4712 BC.<br />
HH Hour of day (1-12).<br />
HH12 Hour of day (1-12).<br />
HH24 Hour of day (0-23).<br />
MI Minute (0-59).<br />
SS Second (0-59).<br />
SSSSS Seconds past midnight (0-86399).<br />
FF Fractional seconds.<br />
<br />
ex:<br />
SELECT TO_CHAR(SYSDATE,'MON') FROM DUAL<br />
It will return Month is this Format JAN,FEB,MAR,,,<br />
<br />
Note while comparing need to TRUNC(SYSDATE) otherwise data has Time stamp also<br />
<br />
SQL functions<br />
MIN<br />
SELECT MIN(aggregate_expression)<br />
FROM tables<br />
WHERE conditions;<br />
ex:<br />
SELECT min(sal)<br />
FROM emp<br />
it will return Minimum salary of the Employee table<br />
<br />
MaX<br />
<br />
SELECT MAX(aggregate_expression)<br />
FROM tables<br />
WHERE conditions;<br />
ex:<br />
SELECT MAX(sal)<br />
FROM emp<br />
it will return Maximum salary of the Employee table<br />
<br />
AVG<br />
SELECT AVG(aggregate_expression)<br />
FROM tables<br />
WHERE conditions;<br />
<br />
Example<br />
SELECT AVG(sal)<br />
FROM emp<br />
it will return Average salary of the Employees table<br />
COUNT<br />
Example<br />
SELECT count(*)<br />
FROM emp<br />
it will return no of employee of the Employees table<br />
<br />
<br /></div>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-18651341-3', 'auto');
ga('send', 'pageview');
</script>
</div>
Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0tag:blogger.com,1999:blog-7646920909051971879.post-14254093228779126132015-04-22T07:34:00.002-07:002015-04-23T07:38:28.884-07:00Oracle Dual Table<div style="text-align: left;">
Oracle, DUAL is a table which is created with every installation of Oracle<br />
<br />
The DUAL table's column, the column name, its datatype and even its value are not important. Technically it could be any datatype. DUAL exists just so we have a 1 row table we can reliably select from.<br />
<br />
Don't EVER add rows to DUAL, fiddle with its column, or alter it in any way. If you do, you can expect some very strange and potentially destructive things to happen in your database, assuming the database doesn't just crash and burn completely<br />
<br />
select sysdate from emp<br />
<br />
1) select 1 from DUAL;<br />
returns 1<br />
<br />
2) select 1+2 from DUAL;<br />
returns 3<br />
<br />
3) select sysdate from DUAL;<br />
returns system date of oracle database.<br />
<br />
4) select `sql` from DUAL;<br />
returns`sql`<br />
<br />
5) select user from DUAL;<br />
returns oracle user logged in.<br />
<br />
6) select<br />
(select empno from emp where empno = 10)<br />
from DUAL;<br />
returns 10<br />
<br />
DUAL table can be used to test the SQL functions ( Both in-built and user defined functions)<br />
<br />
7) select func_salary(10) from DUAL;<br />
where func_salary is a user defined function returns a value when argument is 10.<br />
<br />
8) select LOWER(`ORAclE`) from DUAL;<br />
returns`oracle` where LOWER is a in-built SQL function.<br />
<br />
Interview tips<br />
<br />
If DUAL is supposed to have only one row, why is it called DUAL? Why not SINGLE?!<br />
<br />
According to this old article on the history of Oracle’s DUAL table, DUAL was originally not meant to be seen itself but instead used inside a view that was expected to be queried. The idea was that you could do a JOIN to the DUAL table and create two rows in the result for every one row in your table. In that context, the name DUAL seemed fine.<br />
<br />
Is it valid or not??<br />
CREATE TABLE xxemp1<br />
AS<br />
SELECT * FROM DUAL<br />
<br />
*Read*Explore*Succeed*<br />
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-18651341-3', 'auto');
ga('send', 'pageview');
</script>
</div>Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0tag:blogger.com,1999:blog-7646920909051971879.post-31612202150210984342015-04-21T13:14:00.000-07:002015-04-22T07:36:58.991-07:00Oracle Apps Basics<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">ERPs available in market</span></div>
<ul style="margin-top: 0in;" type="disc">
<li class="MsoNormal" style="mso-list: l2 level1 lfo2; tab-stops: list .5in; text-align: justify;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">SAP</span></li>
</ul>
<ul style="margin-top: 0in;" type="disc"><ul style="margin-top: 0in;" type="circle">
<li class="MsoNormal" style="mso-list: l3 level2 lfo1; tab-stops: list 1.0in; text-align: justify;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Oracle
Applications</span></li>
<li class="MsoNormal" style="mso-list: l3 level2 lfo1; tab-stops: list 1.0in; text-align: justify;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">People
soft</span></li>
<li class="MsoNormal" style="mso-list: l3 level2 lfo1; tab-stops: list 1.0in; text-align: justify;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Siebel</span></li>
<li class="MsoNormal" style="mso-list: l3 level2 lfo1; tab-stops: list 1.0in; text-align: justify;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">JD
Edwards</span></li>
</ul>
</ul>
<div class="MsoNormal" style="text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Oracle
Applications are used to capture Business functionality information of the
organization.</span></i></div>
<ul style="margin-top: 0in;" type="disc">
<li class="MsoNormal" style="mso-list: l1 level1 lfo3; tab-stops: list .5in; text-align: justify;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Instances</span></li>
<ul style="margin-top: 0in;" type="circle">
<li class="MsoNormal" style="mso-list: l1 level2 lfo3; tab-stops: list 1.0in; text-align: justify;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Development<span style="mso-spacerun: yes;"> </span>- Development</span></li>
<ul style="margin-top: 0in;" type="square">
<li class="MsoNormal" style="mso-list: l1 level3 lfo3; tab-stops: list 1.5in; text-align: justify;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Development
stage 1</span></li>
<li class="MsoNormal" style="mso-list: l1 level3 lfo3; tab-stops: list 1.5in; text-align: justify;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Development
stage 2</span></li>
</ul>
<li class="MsoNormal" style="mso-list: l1 level2 lfo3; tab-stops: list 1.0in; text-align: justify;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Testing<span style="mso-spacerun: yes;"> </span>- Testing</span></li>
<li class="MsoNormal" style="mso-list: l1 level2 lfo3; tab-stops: list 1.0in; text-align: justify;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Production
– Client testing</span></li>
</ul>
</ul>
<div class="MsoNormal" style="text-align: justify;">
<b style="mso-bidi-font-weight: normal;"><i style="mso-bidi-font-style: normal;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Involved personalities of Oracle Applications
and their roles and responsibilities in brief</span></i></b></div>
<div class="MsoNormal" style="margin-left: .5in; mso-list: l0 level1 lfo4; tab-stops: list .5in; text-align: justify; text-indent: -.25in;">
<span style="font-family: "Arial","sans-serif"; font-size: 11.0pt; mso-fareast-font-family: Arial;"><span style="mso-list: Ignore;">1)<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">DBA
– Database Administrator</span></div>
<div class="MsoNormal" style="margin-left: 1.0in; mso-list: l0 level2 lfo4; tab-stops: list 1.0in; text-align: justify; text-indent: -.25in;">
<span style="font-family: "Arial","sans-serif"; font-size: 11.0pt; mso-fareast-font-family: Arial;"><span style="mso-list: Ignore;">a.<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Installation
of Oracle Applications</span></div>
<div class="MsoNormal" style="margin-left: 1.0in; mso-list: l0 level2 lfo4; tab-stops: list 1.0in; text-align: justify; text-indent: -.25in;">
<span style="font-family: "Arial","sans-serif"; font-size: 11.0pt; mso-fareast-font-family: Arial;"><span style="mso-list: Ignore;">b.<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Applying
patches</span></div>
<div class="MsoNormal" style="margin-left: 1.0in; mso-list: l0 level2 lfo4; tab-stops: list 1.0in; text-align: justify; text-indent: -.25in;">
<span style="font-family: "Arial","sans-serif"; font-size: 11.0pt; mso-fareast-font-family: Arial;"><span style="mso-list: Ignore;">c.<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Maintaining
Multiple Instances</span></div>
<div class="MsoNormal" style="margin-left: .5in; mso-list: l0 level1 lfo4; tab-stops: list .5in; text-align: justify; text-indent: -.25in;">
<span style="font-family: "Arial","sans-serif"; font-size: 11.0pt; mso-fareast-font-family: Arial;"><span style="mso-list: Ignore;">2)<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Functional
Consultant</span></div>
<div class="MsoNormal" style="margin-left: 1.0in; mso-list: l0 level2 lfo4; tab-stops: list 1.0in; text-align: justify; text-indent: -.25in;">
<span style="font-family: "Arial","sans-serif"; font-size: 11.0pt; mso-fareast-font-family: Arial;"><span style="mso-list: Ignore;">a.<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Interaction
with the client</span></div>
<div class="MsoNormal" style="margin-left: 1.0in; mso-list: l0 level2 lfo4; tab-stops: list 1.0in; text-align: justify; text-indent: -.25in;">
<span style="font-family: "Arial","sans-serif"; font-size: 11.0pt; mso-fareast-font-family: Arial;"><span style="mso-list: Ignore;">b.<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Gathering
the requirements for development / customization</span></div>
<div class="MsoNormal" style="margin-left: 1.0in; mso-list: l0 level2 lfo4; tab-stops: list 1.0in; text-align: justify; text-indent: -.25in;">
<span style="font-family: "Arial","sans-serif"; font-size: 11.0pt; mso-fareast-font-family: Arial;"><span style="mso-list: Ignore;">c.<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">About
oracle applications what available and what wasn’t available.</span></div>
<div class="MsoNormal" style="margin-left: 1.0in; mso-list: l0 level2 lfo4; tab-stops: list 1.0in; text-align: justify; text-indent: -.25in;">
<span style="font-family: "Arial","sans-serif"; font-size: 11.0pt; mso-fareast-font-family: Arial;"><span style="mso-list: Ignore;">d.<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Example
invoice form – fields<span style="mso-spacerun: yes;"> </span>- Or develop a
invoice form from scratch</span></div>
<div class="MsoNormal" style="margin-left: 1.0in; mso-list: l0 level2 lfo4; tab-stops: list 1.0in; text-align: justify; text-indent: -.25in;">
<span style="font-family: "Arial","sans-serif"; font-size: 11.0pt; mso-fareast-font-family: Arial;"><span style="mso-list: Ignore;">e.<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Preparation
of FDD (Functional Design Document)</span></div>
<div class="MsoNormal" style="margin-left: .5in; mso-list: l0 level1 lfo4; tab-stops: list .5in; text-align: justify; text-indent: -.25in;">
<span style="font-family: "Arial","sans-serif"; font-size: 11.0pt; mso-fareast-font-family: Arial;"><span style="mso-list: Ignore;">3)<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Technical
Consultant – Input FDD</span></div>
<div class="MsoNormal" style="margin-left: 1.0in; mso-list: l0 level2 lfo4; tab-stops: list 1.0in; text-align: justify; text-indent: -.25in;">
<span style="font-family: "Arial","sans-serif"; font-size: 11.0pt; mso-fareast-font-family: Arial;"><span style="mso-list: Ignore;">a.<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Go
through the FDD</span></div>
<div class="MsoNormal" style="margin-left: 1.0in; mso-list: l0 level2 lfo4; tab-stops: list 1.0in; text-align: justify; text-indent: -.25in;">
<span style="font-family: "Arial","sans-serif"; font-size: 11.0pt; mso-fareast-font-family: Arial;"><span style="mso-list: Ignore;">b.<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Prepare
TDD (Technical Design Document) – Logic, Tables, Procedures, Forms, Menus,
Packages – approval</span></div>
<div class="MsoNormal" style="margin-left: 1.0in; mso-list: l0 level2 lfo4; tab-stops: list 1.0in; text-align: justify; text-indent: -.25in;">
<span style="font-family: "Arial","sans-serif"; font-size: 11.0pt; mso-fareast-font-family: Arial;"><span style="mso-list: Ignore;">c.<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Development
of Component</span></div>
<div class="MsoNormal" style="margin-left: 1.0in; mso-list: l0 level2 lfo4; tab-stops: list 1.0in; text-align: justify; text-indent: -.25in;">
<span style="font-family: "Arial","sans-serif"; font-size: 11.0pt; mso-fareast-font-family: Arial;"><span style="mso-list: Ignore;">d.<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Test
the component</span></div>
<div class="MsoNormal" style="margin-left: 1.0in; mso-list: l0 level2 lfo4; tab-stops: list 1.0in; text-align: justify; text-indent: -.25in;">
<span style="font-family: "Arial","sans-serif"; font-size: 11.0pt; mso-fareast-font-family: Arial;"><span style="mso-list: Ignore;">e.<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Deliver
to the client</span></div>
<div class="MsoNormal" style="text-align: justify;">
<br /></div>
<div class="MsoNormal" style="text-align: justify;">
<b style="mso-bidi-font-weight: normal;"><i style="mso-bidi-font-style: normal;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">All these sessions will go trough the below
mentioned components</span></i></b></div>
<div class="MsoNormal" style="text-align: justify;">
<br /></div>
<div class="MsoNormal" style="text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">R I C
E<span style="mso-spacerun: yes;"> </span>-<span style="mso-spacerun: yes;">
</span>Components for development 70%</span></i></div>
<div class="MsoNormal" style="text-align: justify;">
<br /></div>
<ul style="margin-top: 0in;" type="disc"><ul style="margin-top: 0in;" type="circle"><ul style="margin-top: 0in;" type="square">
<li class="MsoNormal" style="mso-list: l1 level3 lfo3; tab-stops: list 1.5in; text-align: justify;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">R<span style="mso-tab-count: 1;"> </span>-<span style="mso-tab-count: 1;"> </span>Reports <span style="mso-tab-count: 1;"> </span>-<span style="mso-tab-count: 1;"> </span>Reports 6i/10g</span></li>
<li class="MsoNormal" style="mso-list: l1 level3 lfo3; tab-stops: list 1.5in; text-align: justify;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">I
<span style="mso-tab-count: 1;"> </span>-<span style="mso-tab-count: 1;"> </span>Interfaces<span style="mso-tab-count: 1;"> </span>-<span style="mso-tab-count: 1;"> </span>Programs, SQL, PL/SQL</span></li>
<li class="MsoNormal" style="mso-list: l1 level3 lfo3; tab-stops: list 1.5in; text-align: justify;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">C<span style="mso-tab-count: 1;"> </span>-<span style="mso-tab-count: 1;"> </span>Conversion<span style="mso-tab-count: 1;"> </span>-<span style="mso-tab-count: 1;"> </span>Programs, SQL, PL/SQL</span></li>
<li class="MsoNormal" style="mso-list: l1 level3 lfo3; tab-stops: list 1.5in; text-align: justify;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">E<span style="mso-tab-count: 1;"> </span>-<span style="mso-tab-count: 1;"> </span>Extensions<span style="mso-tab-count: 1;"> </span>-<span style="mso-tab-count: 1;"> </span>Forms 6i/10g</span></li>
</ul>
</ul>
</ul>
<div class="MsoNormal" style="text-align: justify;">
<br /></div>
<div class="MsoNormal" style="text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Functions
Knowledge 30%</span></i></div>
<ul style="margin-top: 0in;" type="disc">
<li class="MsoNormal" style="mso-list: l1 level1 lfo3; tab-stops: list .5in; text-align: justify;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Purchase
Order Module</span></li>
<li class="MsoNormal" style="mso-list: l1 level1 lfo3; tab-stops: list .5in; text-align: justify;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Accounts
Payable Module</span></li>
<li class="MsoNormal" style="mso-list: l1 level1 lfo3; tab-stops: list .5in; text-align: justify;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Order
Management Module</span></li>
<li class="MsoNormal" style="mso-list: l1 level1 lfo3; tab-stops: list .5in; text-align: justify;"><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Inventory
Module</span></li>
</ul>
</div>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-18651341-3', 'auto');
ga('send', 'pageview');
</script>
Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0tag:blogger.com,1999:blog-7646920909051971879.post-63690172927873627772015-04-18T19:04:00.000-07:002015-09-30T21:48:07.914-07:00Oracle Applications Architecture<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhyBb5OFEwsdeUWQHPdDlz8vOz6zI0hhzxzBagR40G8hBj46R_SQQeFmh_sjO82-U8cLp_CkwgskHcVeypq52f3huhc3-fm6zLzK-Brv_7SfKRGQMbO5WafdoOsPpp_imOyoLoWgq1oFcTL/s1600/image_1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhyBb5OFEwsdeUWQHPdDlz8vOz6zI0hhzxzBagR40G8hBj46R_SQQeFmh_sjO82-U8cLp_CkwgskHcVeypq52f3huhc3-fm6zLzK-Brv_7SfKRGQMbO5WafdoOsPpp_imOyoLoWgq1oFcTL/s1600/image_1.png" /></a></div>
<br />
<b><span lang="EN" style="font-family: "Verdana","sans-serif"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></b>
<b><span lang="EN" style="font-family: "Verdana","sans-serif"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></b>
<b><span lang="EN" style="font-family: "Verdana","sans-serif"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;">Implementation<o:p></o:p></span></b></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><br /></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">When you use an E-business suite, you need to
engineer it to suit your business requirements. In this topic, you learn about
the principles that form the basis of the business architecture of oracle
11i/R12 E-Business Suite.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">Here we will discuss
how to implement a fresh version of oracle application R12/11i in your
organization. We‘ll do the implementation of below requirements.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<br /></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">1. The organization makes electronic gadgets – Mobile,
Television, Refrigerator<br />
<!--[if !supportLineBreakNewLine]--><br />
<!--[endif]--><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">2. The organization is present in 3 regions – Japan, UK
and India<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">Let’s consider that we have installed a production
instance of R12 in the server.<br />
What next?<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><br /></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<br /></div>
<div class="MsoNormal">
<b><span lang="EN" style="font-family: "Verdana","sans-serif"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;">Oracle Applications Architecture<o:p></o:p></span></b></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">The Oracle Applications Architecture is a framework for
multi-tiered, distributed computing that supports Oracle Applications products.
In this model, various servers or services are distributed among three levels,
or tiers.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<br /></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">A tier is a logical grouping of services, potentially
spread across more than one physical machine. The three-tier architecture that
comprises an Oracle E-Business Suite installation is made up of the database
tier, which supports and manages the Oracle database; the application tier,
which supports and manages the various Applications components, and is
sometimes known as the middle tier; and the desktop tier, which provides the
user interface via an add-on component to a standard web browser.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<br /></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">
</span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">Centralizing the Oracle Applications software on the
application tier eliminates the need to install and maintain application
software on each desktop client PC, and also enables Oracle Applications to
scale well with an increasing load. Extending this concept further, one of the
key benefits of using the Shared Application Tier File System model (originally
Shared APPL_TOP) is the need to maintain only a single copy of the relevant
Applications code, instead of a copy for every application tier machine.<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVkoIkK4OF0E85FilPNfP4Dsr-7bkt4CHOcUJrdsHnYw1K9eb-NlwdrOBp9zMn4GLhY_cJJmUn-vrRUBt_VOv9WLkQZVeaARGREFTEHF9fGxuIrh9nLF1jb1lDYp7YhQ5p5Uc41AzgcCgK/s1600/EBS+R12+Architecture.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="EBS R12 Architecture" border="0" height="173" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVkoIkK4OF0E85FilPNfP4Dsr-7bkt4CHOcUJrdsHnYw1K9eb-NlwdrOBp9zMn4GLhY_cJJmUn-vrRUBt_VOv9WLkQZVeaARGREFTEHF9fGxuIrh9nLF1jb1lDYp7YhQ5p5Uc41AzgcCgK/s1600/EBS+R12+Architecture.png" title="EBS R12 Architecture" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal">
<b><span lang="EN" style="font-family: "Verdana","sans-serif"; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;">The Desktop Tier<br />
</span></b><span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">The client interface is provided through HTML for HTML-based applications,
and via a Java applet in a Web browser for the traditional Forms-based
applications.<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj98zVSvZvnLigzMm0abF9M5ljmxnF6DIXT7f-GGEU02RwYujzVadBe_kOdJrEY7Phd1px6UjCrHtpHX-DTht5Rurwl6Du9_VolotqvNVZnMGVBzhPCaVxrXd0ExgDtVhTngnWLfyLAeBis/s1600/EBS+R12+DB+tier.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="R12 Database tier" border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj98zVSvZvnLigzMm0abF9M5ljmxnF6DIXT7f-GGEU02RwYujzVadBe_kOdJrEY7Phd1px6UjCrHtpHX-DTht5Rurwl6Du9_VolotqvNVZnMGVBzhPCaVxrXd0ExgDtVhTngnWLfyLAeBis/s1600/EBS+R12+DB+tier.png" title="R12 Database tier" width="318" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">The client interface is provided through HTML for
HTML-based applications, and via a Java applet in a Web browser for the
traditional Forms-based applications.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">In Oracle Applications Release 12, each user logs in to
Oracle Applications through the E-Business Suite Home Page on a desktop client
web browser. </span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><br /></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">The E-Business Suite Home Page provides a single point of access
to HTML-based applications, Forms-based applications, and Business Intelligence
applications.<br />
<!--[if !supportLineBreakNewLine]--><br />
<!--[endif]--><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">Once logged in via the E-Business Suite Home Page, you
need not sign on again to access other parts of the system. Oracle Applications
does not prompt again for user name and password, even when you navigate to
other tools and products. <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<br /></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">Oracle Applications also retains preferences as you
navigate through the system. For example, if you registered in the E-Business
Suite Home Page that German is your preferred language, this preference carries
over whether you access Forms-based or HTML-based applications.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">The Forms client applet is a general-purpose presentation
applet that supports all Oracle Applications Forms-based products, including
those with <b>customization</b> and <b>extensions.</b> The Forms client applet is packaged
as a collection of Java Archive (JAR) files. The JAR files contain all Java
classes required to run the presentation layer of Oracle Applications forms.</span><span lang="EN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: EN; mso-bidi-font-family: Mangal; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<b><u><span lang="EN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: EN; mso-bidi-font-family: Mangal; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: "Times New Roman";"><br /></span></u></b></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<b><u><span lang="EN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: EN; mso-bidi-font-family: Mangal; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: "Times New Roman";">The Application Tier</span></u></b><span lang="EN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: EN; mso-bidi-font-family: Mangal; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: "Times New Roman";"><br />
</span><span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">The application
tier has a dual role: hosting the various servers and service groups that
process the business logic, and managing communication between the desktop tier
and the database tier. This tier is sometimes referred to as the middle tier. <br />
Four servers or service groups comprise the basic application tier for Oracle
Applications:</span><span lang="EN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: EN; mso-bidi-font-family: Mangal; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: "Times New Roman";"> <o:p></o:p></span></div>
<ul type="disc">
<li class="MsoNormal"><span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">Web services <o:p></o:p></span></li>
<li class="MsoNormal"><span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">Forms services <o:p></o:p></span></li>
<li class="MsoNormal"><span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">Concurrent Processing server <o:p></o:p></span></li>
<li class="MsoNormal"><span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">Admin
server <o:p></o:p></span></li>
</ul>
<div class="MsoNormal">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN; mso-bidi-font-family: Mangal; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;">Note: In Release 12, the Web and Forms services are
provided by Oracle Application Server (OracleAS) 10g. They are no longer
servers in the sense of being a single process, as was the case in previous
Applications releases. It is advisable to avoid using a mixture of
different platforms on your application tier. This makes maintenance easier,
since only one set of patches needs to be downloaded</span><span lang="EN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: EN; mso-bidi-font-family: Mangal; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;">.</span></div>
<div class="MsoNormal">
<span lang="EN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: EN; mso-bidi-font-family: Mangal; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;"><br /></span></div>
<div class="MsoNormal">
<b><u><span lang="EN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: EN; mso-bidi-font-family: Mangal; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: "Times New Roman";">Applications File System <o:p></o:p></span></u></b></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">An Oracle Applications Release 12 system utilizes
components from many Oracle products. These product files are stored below a
number of key top-level directories on the database and application server
machines.<br />
<!--[if !supportLineBreakNewLine]--><br />
<!--[endif]--><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">Note: No Applications files are installed on desktop
client machines, although JAR files and their supporting utilities are
downloaded as required<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">Depending on how you chose to install Applications, these
product directories may be located on a single machine (the simplest case) or
on multiple machines (the most common type of deployment). Operating system
environment settings indicate the location of the various files in the file
systems of the database and application server machines. <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<br /></div>
<div class="MsoNormal">
<span lang="EN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: EN; mso-bidi-font-family: Mangal; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;">
</span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">This chapter discusses the association between these
environment settings and the corresponding files and directories.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWlnRPiVcG3H-5vnHTrHZjH5PF5aizuWs6tJovfuTZP6lwj2fpyTasc1nHGboucjV7TZGYZ8VvQD1CKE1WGwy2_LzT7W1ms0IZUA-xqrqix0LEakklV4VXECk6Rh3hlNOiIqGof4Vk3CU2/s1600/R12++File+System.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="R12 File System" border="0" height="252" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWlnRPiVcG3H-5vnHTrHZjH5PF5aizuWs6tJovfuTZP6lwj2fpyTasc1nHGboucjV7TZGYZ8VvQD1CKE1WGwy2_LzT7W1ms0IZUA-xqrqix0LEakklV4VXECk6Rh3hlNOiIqGof4Vk3CU2/s1600/R12++File+System.png" title="R12 File System" width="320" /></a></div>
<ol start="1" style="margin-top: 0in;" type="1">
<li class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly; mso-list: l0 level1 lfo1; tab-stops: list .5in;"><span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">The db/apps_st/data
(DATA_TOP) directory is located on the database node machine, and contains
the system table spaces, redo log files, data table spaces, index table
spaces, and database files <o:p></o:p></span></li>
<li class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly; mso-list: l0 level1 lfo1; tab-stops: list .5in;"><span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">The db/tech_st/10.2.0
directory is located on the database node machine, and contains the
ORACLE_HOME for the Oracle10g database <o:p></o:p></span></li>
<li class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly; mso-list: l0 level1 lfo1; tab-stops: list .5in;"><span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">The apps/apps_st/appl
(APPL_TOP) directory contains the product directories and files for Oracle
Applications <o:p></o:p></span></li>
<li class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly; mso-list: l0 level1 lfo1; tab-stops: list .5in;"><span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">The
apps/apps_st/comn or (COMMON_TOP or COMN_TOP) directory contains
directories and files used across products <o:p></o:p></span></li>
<li class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly; mso-list: l0 level1 lfo1; tab-stops: list .5in;"><span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">The apps/tech_st/10.1.2
directory contains the ORACLE_HOME used for the Applications technology
stack tools components <o:p></o:p></span></li>
<li class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly; mso-list: l0 level1 lfo1; tab-stops: list .5in;"><span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">The apps/tech_st/10.1.3
directory contains the ORACLE_HOME used for the Applications technology
stack Java components</span></li>
</ol>
<b style="line-height: 10pt;"><u><span lang="EN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: EN; mso-bidi-font-family: Mangal; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;">Types
of users</span></u></b><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKi6lGnlo8j2MsTV5i5V1zlHw_GP748K22wuXnYB46FvmjasKLXjxorzbiUjUk7YMpBwHLxi44cwiNg7dqud_4BZ9JtN9yma6UMZdhMWLfNOPPDGoXh0EnZqffQsm9jDbpF6UumkmX7ohj/s1600/types+of+Users.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="177" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKi6lGnlo8j2MsTV5i5V1zlHw_GP748K22wuXnYB46FvmjasKLXjxorzbiUjUk7YMpBwHLxi44cwiNg7dqud_4BZ9JtN9yma6UMZdhMWLfNOPPDGoXh0EnZqffQsm9jDbpF6UumkmX7ohj/s1600/types+of+Users.png" width="320" /></a></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<b><span lang="EN" style="color: maroon; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: EN; mso-bidi-font-family: Mangal; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: "Times New Roman";"><br />
</span></b><span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">Forms-based
users are involved in the transnational operations of an organization. These
users are usually full-time users and require a robust interface with maximum
features.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">The desktop tier is only responsible for displaying
forms. To forms-based users, the forms are displayed using java. <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">Therefore, the desktop tier needs java virtual machine
(JVM) and java archive (JAR) files to operate in the forms-based architectural
mode<o:p></o:p></span></div>
<div>
<span style="font-family: Times New Roman, serif;"><span style="line-height: 18.3999996185303px;"><b><u><br /></u></b></span></span></div>
<div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<b><span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">Self-service users</span></b><span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"> are infrequent users of oracle. They
require a simple and quick interface. Typically, most users in an instance are
self-service users<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<br /></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<b><span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">Business Intelligence (BI) users</span></b><span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"> are mainly senior executives, who
require a simple interface to reveal critical business information. Application
designed for BI users provide a browser to eliminate the need for these users
to learn a new system<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<br /></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<b><span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">Mobile Users</span></b><span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"> are users whose jobs prevent them from using
network-connected computers. By using a mobile interface, they can send or
receive information at convenient locations. Usually, sales and inventory personnel
belong to this class of users.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><br /></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<b><span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">To self-service</span></b><span lang="EN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: EN; mso-bidi-font-family: Mangal; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: "Times New Roman";">, business intelligence, and mobile users, forms are displayed using HTML
or JavaScript. The browser is inherently capable of handling HTML and JavaScript.
As a result, additional downloads are not required<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><br /></span>
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">For jobs</span><br />
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";">you can visit <a href="http://ebizjobs4u.blogspot.in/" rel="nofollow">Latest Jobs</a></span><br />
<br />
You can get more information on oracle<br />
<br />
<a href="http://ebiztechnics.blogspot.in/" rel="nofollow">Oracle Info</a><br />
<br />
<br />
<span lang="EN" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN; mso-fareast-font-family: "Times New Roman";"><br /></span></div>
</div>
</div>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-18651341-3', 'auto');
ga('send', 'pageview');
</script>
<script src="http://resources.infolinks.com/js/infolinks_main.js" type="text/javascript"></script>
</div>
Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0tag:blogger.com,1999:blog-7646920909051971879.post-78249091022811908192015-04-16T03:38:00.000-07:002015-09-30T21:54:36.357-07:00Oracle APPS: Interface Basics<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<div>
<div>
What is Interface?</div>
<div>
Device or program for connecting two items of hardware or software so that they can be operated jointly or communicate with each other.</div>
<div>
"an application program interface"(API)</div>
<div>
Interface can be segregated as two types</div>
<div>
1) Inbound 2)Outbound</div>
<div>
Inbound (Open Interfaces):By using this data can be transmitted from source to target system</div>
<div>
Source may be flat file or any third party systems</div>
<div>
OPEN INTERFACES</div>
<div>
Oracle Apps. open interfaces are powerful, flexible tools that allow you to capture data from your own applications, define necessary format conversions, and direct data to your Oracle Apps.</div>
<div>
We can integrate Oracle Apps. With other legacy systems, by Open interface using following methods:</div>
<div>
· Integrating Oracle Apps. Applications with your proprietary or custom applications</div>
<div>
· Importing historical data from your previous application system into your Oracle applications</div>
<div>
· Importing information from various financial information providers</div>
<div>
· Importing information from spreadsheets, flat files.</div>
<div>
CHOOSING A FEEDER PROGRAM:</div>
<div>
You need to choose a tool for writing a feeder program to extract data from your existing application system's printed reports, flat file, relational database, or other repository of application information.</div>
<div>
Using a feeder program, you write, populate an Oracle Applications import table with the information you want to introduce to your Oracle Apps. System using SQL*Loader,.</div>
<div>
SQL*Loader is a powerful and easy–to–use tool you can to write a feeder program.</div>
<div>
SQL*Loader lets you map elements of a regularly formatted file, such as a listing or flat file, and specify which columns of which tables to populate.</div>
<div>
Chances are, SQL*Loader is a powerful enough tool to use for your feeder program.</div>
<div>
DO NOT USE DATABASE TOOLS TO MODIFY ORACLE APPLICATIONS DATA:</div>
<div>
Oracle provides powerful tools you can use to create, store, change, retrieve and maintain information in an Oracle database.</div>
<div>
But if you use Oracle tools like SQL*Plus to modify Oracle Applications data, you risk destroying the integrity of your data and you lose the ability to audit changes to your data.</div>
<div>
Because Oracle Applications tables are interrelated, any change you make using an Oracle Applications form can update many tables at once. But when you modify Oracle Applications data using anything other than Oracle applications forms, you may change a row in one table without making corresponding changes in related tables. If your tables get out of synchronization with each other, you risk retrieving erroneous information and you risk unpredictable results throughout Oracle Applications.</div>
<div>
When you use Oracle Applications forms to modify your data, Oracle Applications automatically checks that your changes are valid. Oracle Applications also keeps track of who changes information. But, if you enter information into database tables using database tools, you may store invalid information. You also lose the ability to track who has changed your information because SQL*Plus and other database tools do not keep a record of changes.</div>
<div>
What is the difference between OPEN INTERFACE & API's?</div>
<div>
OPEN INTERFACE:</div>
<div>
There is no much difference between the open other than the way we load data.</div>
<div>
In case of open interface the data is loaded in to open interface table like GL_INTERFACE or Sales Order Interface(OE_ORDER_HEADERS_IFACE_ALL).</div>
<div>
Run the interface import program.</div>
<div>
This will validate the data and put it into oracle applications. All the invalid records are marked as Error.</div>
<div>
One thing is there are GUI Screens available for most of these interface where you check the error message correct it there only and resubmit the interface.</div>
<div>
From the technical perspective there are Error tables available for each interface</div>
<div>
API:</div>
<div>
API's are the oracle built packages where the validation logic is wrapped inside a package and the data is passed as parameters to the API.</div>
<div>
Most of these api's use the PLSQL tables as parameters to take the advantage of bulk binding concepts for faster loading data.</div>
<div>
They will have the two OUT parameters to throw back the error code and message in case of data validation failure</div>
<div>
Apis' are comparatively faster than open interfaces.</div>
<div>
If a API's and open interface are available it is better to load through API's.If the records are more...<br />
<br />
</div>
</div>
</div>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-18651341-3', 'auto');
ga('send', 'pageview');
</script>
<script src="http://resources.infolinks.com/js/infolinks_main.js" type="text/javascript"></script>
</div>
Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0tag:blogger.com,1999:blog-7646920909051971879.post-40876907915256577332015-04-10T02:39:00.000-07:002015-09-30T22:57:09.773-07:00Oracle APPS: Basics<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="margin-bottom: .0001pt; margin: 0in;">
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: small;">The below example explains a few of the
important terms and concepts used in the Oracle E-Business Suite.<o:p></o:p></span></div>
</div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: small;">This would be a good starting point for
the beginners to better understand the concepts behind Oracle Applications.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-size: small;"><br /></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: small;">Say SkRao is the owner of a wholesale
fruit shop. He buys various fruits like apples, oranges, mangos and grapes etc
from farmers directly and sells them to retail shop owners and also to the
direct customers.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-size: small;"><br /></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: small;">The farmers are referred to as
VENDORS/SUPPLIERS in Oracle Applications. Harry keeps track of all his vendors’
information like addresses, bank account and the amount he owes to them for the
fruits that he bought etc, in a book named Oracle PAYABLE.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-size: small;"><br /></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: small;">SkRao gets an order from a retail shop
owner of Fruit Mart, for a shipment of 11 bags of apples, 25 bags of oranges
and 32 kgs of grapes. In Oracle Apps, bags and kgs are referred to as UOM (unit
of measure), Fruit Mart is called CUSTOMER and the order is referred to as
SALES ORDER. Harry maintains a book called ORDER MANAGEMENT where he writes
down all the details of the SALES ORDERS that he gets from his customers.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-size: small;"><br /></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: small;">Say the fruits have been shipped to the
customer Fruit Mart. Harry now sends him the details like cost of each
bag/fruit, the total amount that the customer has to pay etc on a piece of
paper which is called INVOICE / TRANSACTION.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-size: small;"><br /></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: small;">Once the INVOICE has been sent over,
the customer then validates this against the actual quantity of fruits that he
received and will process the payments accordingly. The invoice amount could be
paid as a single amount or could be paid in installments.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-size: small;"><br /></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: small;">SkRao’s customer, Fruit Mart pays him
in installments (partial payments).<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: small;">So SkRao has to make a note of the
details like date received, amount received, amount remaining, amount received
for what goods/shipments/invoice etc, when SkRao receives the payments.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-size: small;"><br /></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: small;">This detail is called RECEIPT, which
will be compared to the invoice by SkRao to find how much Fruit Mart has paid
to him and how much has to be paid yet. This information is maintained in a
book named RECEIVABLES to keep track of all the customers, their addresses (to
ship the items), what and how much he has shipped to his customers and
the amount his customers owe him etc.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-size: small;"><br /></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: small;">SkRao’s fruit business has begun to
improve and has attracted more and more customers. As a result, SkRao decided
to buy a cold storage unit where he could stock more fruits.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-size: small;"><br /></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: small;">In Apps, this cold storage unit is
known as WAREHOUSE and all the fruits are referred to as INVENTORY. Due to
increase in customers, SkRao needs to hire more people to help him out in his
business without any hiccups.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-size: small;"><br /></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: small;">These workers are called EMPLOYEES. At
the end of every month, Harry pays the salary for all his employees through
Checks. These checks are nothing but PAYROLL in Apps.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-size: small;"><br /></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: small;">At the end of every month, SkRao
prepares a balance sheet in a book called GENERAL LEDGER to determine how much
profit/loss he got and keeps track of the money going out and going in.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-size: small;"><br /></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: small;">As the business grows, it becomes
impossible to record everything on a paper. To make everybody’s life easier, we
have very good tools in the market, which help the business men to keep track
of everything.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><br />
One such tool is <b>Oracle E-Business Suite</b>.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<br /></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">Oracle Applications is not a single
application, but is a collection of integrated applications. Each application<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">is referred to as a module and has it
own functionality trying to serve a business purpose.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<br /></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">Few of the modules are Purchasing,
Accounts Payable, Accounts Receivables, Inventory, Order Management,
Human Resources, General Ledger, and Fixed Assets etc.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<br /></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">Here is a high level business use of
various modules:<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">· <span class="apple-converted-space"> </span><b>Oracle Purchasing</b> handles all
the requisitions and purchase orders to the vendors.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">· <span class="apple-converted-space"> </span><b>Oracle Accounts Payable</b> handles
all the payments to the vendors.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<b><span style="font-family: Verdana, sans-serif; font-size: 10pt;">· Oracle Inventory</span></b><span style="font-family: Verdana, sans-serif; font-size: 10pt;"> deals with the items you maintain in stock, warehouse etc.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<b><span style="font-family: Verdana, sans-serif; font-size: 10pt;">· Order Management</span></b><span style="font-family: Verdana, sans-serif; font-size: 10pt;"> helps you collect all the information that your customers
order.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">· <span class="apple-converted-space"></span><b>Oracle Receivables</b> help you
collect the money for the orders that are delivered to the customers.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<b><span style="font-family: Verdana, sans-serif; font-size: 10pt;">· Oracle</span></b><span style="font-family: Verdana, sans-serif; font-size: 10pt;"> <b>Human Resources</b> helps maintain the Employee
information, helps run paychecks etc.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">· <b>Oracle General Ledger</b> receives
information from all the different transaction modules or sub ledgers and
summarizes them in order to help you create profit and loss statements, reports
for paying Taxes etc.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<br /></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">For<u1:p></u1:p> Example: <o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">when you pay your employees that
payment is reported back to General Ledgers as cost i.e money going out, when
you purchase inventory items and the information is transferred to GL as money
going out and so is the case when you pay your vendors. Similarly when you
receive items into your inventory, it is transferred to GL as money coming in,
when your customer sends payment, it is transferred to GL as money coming in.
So all the different transaction modules report to GL (General Ledger) as
either “money going in” or “money going out”, the net result will tell
you if you are making a profit or loss.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<br /></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">All the equipment, shops, warehouses,
computers can be termed as ASSETS and they are managed by Oracle Fixed
Assets.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">There is a lot more in Oracle
applications. This is the very basic explanation just to give an idea of the
flow in ERP for the beginners.<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 1.25in; margin-right: 0in; margin-top: 0in; mso-line-height-rule: exactly; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 1.25in; margin-right: 0in; margin-top: 0in; mso-line-height-rule: exactly; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
</div>
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><b><span id="goog_1854449136"></span><span id="goog_1854449137"></span><a href="https://www.blogger.com/"></a>1. </b><o:p></o:p></span><span style="font-family: Verdana, sans-serif; font-size: 10pt; line-height: 115%;">. </span>Invoice<br />
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFAboCVvmABM6eFwDhw9HBkS_FU8ZP_8TmwQmLn-Y5fUV73FVwc60DQfvFHVWQr-oD9zha5IX5mpB3FqC9YuaKVbGEjVXUT9kbadrYUdCfKFYdvD0QElImGFyxKZLqVxlRovAZBXcwoMnP/s1600/Invoice.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Invoice" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFAboCVvmABM6eFwDhw9HBkS_FU8ZP_8TmwQmLn-Y5fUV73FVwc60DQfvFHVWQr-oD9zha5IX5mpB3FqC9YuaKVbGEjVXUT9kbadrYUdCfKFYdvD0QElImGFyxKZLqVxlRovAZBXcwoMnP/s1600/Invoice.jpg" title="Invoice" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<ul style="text-align: left;">
<li><span style="color: #444444; font-family: Symbol; font-size: 10pt; line-height: 10pt; text-indent: -0.25in;"><span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal; line-height: normal;"> </span></span><span style="color: #444444; font-family: Verdana, sans-serif; font-size: 10pt; line-height: 10pt; text-indent: -0.25in;">The contact information of the buyer</span></li>
<li><span style="color: #444444; font-family: Symbol; font-size: 10.0pt; mso-bidi-font-family: Symbol; mso-bidi-language: HI; mso-fareast-font-family: Symbol;"><span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><span style="color: #444444; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: Arial; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">The terms of payment (that explain the
means of payment, when the sum should be received, the discount details for
early payment, late payment fees, etc.)</span></li>
<li><span style="color: #444444; font-family: Symbol; font-size: 10.0pt; mso-bidi-font-family: Symbol; mso-bidi-language: HI; mso-fareast-font-family: Symbol;"><span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><span style="color: #444444; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: Arial; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">An account detailing the product/service</span></li>
<li> The cost per unit of the product (if this
applies)</li>
</ul>
<br />
<div class="MsoNormal" style="background: white; line-height: 18.0pt; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 0in; margin-right: 0in; margin-top: 22.5pt; mso-outline-level: 2; vertical-align: baseline;">
<div class="MsoNormal" style="background: white; line-height: 18.0pt; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 0in; margin-right: 0in; margin-top: 22.5pt; mso-outline-level: 2; vertical-align: baseline;">
<b><span style="color: #444444; font-family: "Verdana","sans-serif"; font-size: 15.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Sales
v. purchase invoice<o:p></o:p></span></b></div>
<div class="MsoListParagraph" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 33.1pt; margin-right: 0in; margin-top: 0in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -.25in; vertical-align: baseline;">
<!--[if !supportLists]--><span style="color: #444444; font-family: Symbol; font-size: 10.0pt; mso-bidi-font-family: Symbol; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span style="color: #444444; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: Arial; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">An invoice shows the payment that a buyer
owes to a seller. From a seller’s point of view, an invoice for the sale of
goods and/or services is referred to as a sales invoice.<br />
<br />
From a buyer’s point of view, an invoice for the cost of goods and/or services
rendered is referred to as a purchase invoice.<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 18.0pt; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 0in; margin-right: 0in; margin-top: 22.5pt; mso-outline-level: 2; vertical-align: baseline;">
<b><span style="color: #444444; font-family: "Verdana","sans-serif"; font-size: 15.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Invoices
in e-conomic<o:p></o:p></span></b></div>
<br />
<div class="MsoNormal">
<span style="background: white; color: #444444; font-family: "Arial","sans-serif"; font-size: 10.0pt; line-height: 115%; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">In e-conomic you can design, create,
send and book your own invoices from your computer or smart phone. You can even
scan invoices (from e.g. your suppliers) and book them in your system directly.<o:p></o:p></span></div>
</div>
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><br /></span>
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<b><span style="font-family: Verdana, sans-serif; font-size: 10pt;">2. Receipt</span></b><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVqRNGXEihwCg3RdzLUQlMCFEMl8S0kv0jgbtMBn23TYUoJ5HNTDTw6HMxTXIvroYbtT_W-63vUGZuD_GAJVYVbtZuA1IA_weKA2RFQuO7lGiQrD-bp7H7el3TdBKAahfCzUjTwLI7bdAt/s1600/receipt.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Receipts" border="0" height="192" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVqRNGXEihwCg3RdzLUQlMCFEMl8S0kv0jgbtMBn23TYUoJ5HNTDTw6HMxTXIvroYbtT_W-63vUGZuD_GAJVYVbtZuA1IA_weKA2RFQuO7lGiQrD-bp7H7el3TdBKAahfCzUjTwLI7bdAt/s1600/receipt.jpg" title="Receipts" width="400" /></a></div>
<br />
<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>HI</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:DontVertAlignCellWithSp/>
<w:DontBreakConstrainedForcedTables/>
<w:DontVertAlignInTxbx/>
<w:Word11KerningPairs/>
<w:CachedColBalance/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><span style="font-size: large;"><br /></span>
<!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true"
DefSemiHidden="true" DefQFormat="false" DefPriority="99"
LatentStyleCount="267">
<w:LsdException Locked="false" Priority="0" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" Priority="39" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" Name="toc 9"/>
<w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" Priority="10" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" Priority="11" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" Priority="22" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" Priority="59" SemiHidden="false"
UnhideWhenUsed="false" Name="Table Grid"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:Mangal;
mso-bidi-theme-font:minor-bidi;
mso-bidi-language:AR-SA;}
</style>
<![endif]-->
<br />
<div class="MsoNormal" style="line-height: normal;">
<span style="font-size: large;"><b><span style="font-family: "Times New Roman","serif";">Cash Transactions </span></b></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span style="font-family: "Verdana","sans-serif"; font-size: xx-small; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Cash transactions are ones that are
settled immediately in cash. Cash transactions also include transactions made
through cheques. Cash transactions may be classified into cash receipts and
cash payments.</span></div>
<div class="MsoNormal" style="line-height: normal;">
<span style="font-size: large;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal;">
<span style="font-size: large;"><b><span style="font-family: "Times New Roman","serif";">Cash Receipts</span></b></span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span style="font-family: "Verdana","sans-serif"; font-size: xx-small; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Cash receipts are accounted for by
debiting cash / bank ledger to recognize the increase in the asset.</span></div>
<div class="MsoNormal" style="line-height: 10.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span style="font-family: "Verdana","sans-serif"; font-size: xx-small; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Following are common types of cash
receipt transactions along with relevant accounting entries:</span></div>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGSN87weWwBUvTWOTShyphenhyphengOlqhWlHpC7_e8KN2KnWm8dQComVmIlIxnCUoRzHgXj4J-cc1j13_QVvH3QjuRQ0xu4XAt3H5T0iodclF-l-OlXeq9eb6GJkgSA5gn0y31_d-01mb5hA2CWO_m/s1600/cash_receipts.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Cash Receipt" border="0" height="287" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGSN87weWwBUvTWOTShyphenhyphengOlqhWlHpC7_e8KN2KnWm8dQComVmIlIxnCUoRzHgXj4J-cc1j13_QVvH3QjuRQ0xu4XAt3H5T0iodclF-l-OlXeq9eb6GJkgSA5gn0y31_d-01mb5hA2CWO_m/s1600/cash_receipts.jpg" title="Cash Receipt" width="320" /></a></div>
<br />
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"></span><br />
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><b>3. Customer</b>:<o:p></o:p></span><span style="background-color: white; color: #333333; font-family: Georgia, 'Bitstream Charter', serif; font-size: 14px; line-height: 23.7999992370605px;">But an ERP like oracle does not have any relationship with a person unless he buys something from the company. A customer is someone who has a buying relationship with the company.</span><br />
<span style="background-color: white; color: #333333; font-family: Georgia, 'Bitstream Charter', serif; font-size: 14px; line-height: 23.7999992370605px;">then only PARTY will become "Customer"</span><br />
<span style="background-color: white; color: #333333; font-family: Georgia, 'Bitstream Charter', serif; font-size: 14px; line-height: 23.7999992370605px;"><br /></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<b><span style="font-family: Verdana, sans-serif; font-size: 10pt;">4. Vendor/<o:p></o:p></span><span style="font-family: Verdana, sans-serif;"><span style="font-size: 13.3333330154419px;">Supplier:</span></span></b><br />
<div style="line-height: 10.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<div style="line-height: 12.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="background: white; color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: Arial;">The terms vendor and
supplier are commonly encountered in businesses that procure goods and services
from outside. </span><span style="font-family: Verdana, sans-serif; font-size: 10pt;"><o:p></o:p></span></div>
<div style="line-height: 12pt; margin: 0in 0in 0.0001pt;">
<span style="background: white; color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: Arial;">• Both vendors and
suppliers can provide goods and services to a company </span><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: Arial;"><br />
<span style="background: white;">• A vendor is more close to the end consumer
than a supplier who appears to be earlier in the supply chain </span><br />
<span style="background: white;">• Vendor is a more generic term and applies to
anybody supplying goods and services </span><br />
<span style="background: white;">• A vendor is rarely a manufacturer and gets
products on consignment basis from the manufacturers. He can return unsold
items and get his commission </span><br />
<span style="background: white;">• A supplier is many a times manufacturer also.</span><br />
<br />
<span style="background: white;">Number 2</span><br />
<br />
<span style="background: white;">A vendor basically means a person who supplies
items to customers while a supplier is the one who makes the goods available.
The supplier acts as the middleman between the retailer and the manufacturer. A
supplier is also a distributor who makes the goods available to vendors. The
two terms are not equivalent but are related in the fact that they are both
used in the supply chain.</span><br />
<br />
<span style="background: white;">Number 3</span><br />
<span style="background: white;">Supplier - Supplier are those which provide some
material to the company but they have not any contract to the company </span><br />
<span style="background: white;">Vendor - They also provide the material to the
company but they have contract to the company</span></span><span style="font-family: Verdana, sans-serif; font-size: 10pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 12.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<br />
<b>5 Buyer</b></div>
<div class="MsoNormal" style="line-height: 12.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span style="background: white; color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: Arial; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Party</span> <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">which acquires, agrees to</span> <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">acquire, <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">ownership</span> <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">(in
case of</span> <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">goods), <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">benefit</span> <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">or</span> <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">usage</span> <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">(in
case of</span> <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">services), in <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">exchange</span> <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">for</span> <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">money</span> <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">or
other</span> <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">consideration</span> <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">under a</span> <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">contract
of sale</span><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">.</span></span></span></span><br />
<span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;"><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;"><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;"><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;"><span style="background-color: white; font-family: arial; font-size: 14px; line-height: 21px;"><br /></span></span></span></span></span>
<br />
<div class="MsoNormal" style="line-height: 12.0pt; margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-rule: exactly;">
<span style="background: white; font-family: Arial, sans-serif; font-size: 8.5pt;">*</span>Buyer:* Who is able
to buy the goods in the organization, buyer should be an employee before to buy goods</div>
<span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;"><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;"><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;"><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;"><br /></span></span></span></span></div>
</div>
</div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><b>6. Supplier/Vendor</b>:See point <b>4</b><o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><br /></span><span style="font-family: Verdana, sans-serif; font-size: 10pt;"><b>7. Requisition:</b><o:p></o:p></span><br />
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><br /></span>
<br />
<div class="MsoListParagraphCxSpFirst" style="background: white; margin: 0in 0in 0.0001pt 0.25in; text-indent: -0.25in;">
<span style="color: #333333; font-family: Symbol; font-size: 10pt;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><span style="color: #333333; font-family: Verdana, sans-serif; font-size: 10pt;">Purchase Requisition is a formal request intended to procure/buy something that is needed by the organization. It is created and approved by the department requiring</span> the goods and services.<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; margin: 0in 0in 0.0001pt 0.25in; outline: 0px; text-indent: -0.25in;">
<span style="color: #333333; font-family: Symbol; font-size: 10pt;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><span style="color: #333333; font-family: Verdana, sans-serif; font-size: 10pt;">A purchase requisition typically contains the description and quantity of the goods or services to be purchased, a required delivery date, account number and the amount of money that the purchasing department is authorized to spend for the goods or services. Often, the names of suggested supply sources are also included.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; margin: 0in 0in 0.0001pt 0.25in; outline: 0px; text-indent: -0.25in;">
<span style="color: #333333; font-family: Symbol; font-size: 10pt;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><span style="color: #333333; font-family: Verdana, sans-serif; font-size: 10pt;">Basically, requisitions are of two types:<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; margin: 0in 0in 0.0001pt 0.25in; outline: 0px; text-indent: -0.25in;">
<span style="outline: 0px;"><span style="color: #333333; font-family: Symbol; font-size: 10pt;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><i><span style="color: #333333; font-family: Verdana, sans-serif; font-size: 10pt;">Internal requisition and Purchase requisition</span></i><span style="color: #333333; font-family: Verdana, sans-serif; font-size: 10pt;"><o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; margin: 0in 0in 0.0001pt 0.25in; outline: 0px; text-indent: -0.25in;">
<span style="color: #333333; font-family: Symbol; font-size: 10pt;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><b><span style="color: #333333; font-family: Verdana, sans-serif; font-size: 10pt;">Internal Requisitions</span></b><span style="color: #333333; font-family: Verdana, sans-serif; font-size: 10pt;"> are created if the Items are to be obtained from one Inventory location to another location within the same organization. Here the source of the requisition would be INVENTORY. There is no approval process for internal requisition.<o:p></o:p></span></div>
<span style="background-color: white; color: #333333; font-family: Symbol; font-size: 10pt; text-indent: -0.25in;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><b style="background-color: white; text-indent: -0.25in;"><span style="color: #333333; font-family: Verdana, sans-serif; font-size: 10pt;">Purchase Requisitions</span></b><span style="background-color: white; color: #333333; font-family: Verdana, sans-serif; font-size: 10pt; text-indent: -0.25in;"> are created if the goods are obtained from external suppliers. Here the source of the requisition would be SUPPLIERS. The purchase requisitions are sent for approvals</span><br />
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><br /></span><span style="font-family: Verdana, sans-serif; font-size: 10pt;"><b>8. Purchase Order:</b><o:p></o:p></span><br />
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-alt: 8.4pt;">
A buyer-generated <span style="color: windowtext; text-decoration: none; text-underline: none;">document</span> that
authorizes a <span style="color: windowtext; text-decoration: none; text-underline: none;">purchase</span> <span style="color: windowtext; text-decoration: none; text-underline: none;">transaction</span>.
When accepted by the <span style="color: windowtext; text-decoration: none; text-underline: none;">seller</span>,
it becomes a <span style="color: windowtext; text-decoration: none; text-underline: none;">contract</span> <span style="color: windowtext; text-decoration: none; text-underline: none;">binding</span> on
both <span style="color: windowtext; text-decoration: none; text-underline: none;">parties</span>.</div>
<br />
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; mso-line-height-alt: 8.4pt;">
A purchase <span style="color: windowtext; text-decoration: none; text-underline: none;">order</span> <span style="color: windowtext; text-decoration: none; text-underline: none;">sets</span> forth
the <span style="color: windowtext; text-decoration: none; text-underline: none;">descriptions</span>, <span style="color: windowtext; text-decoration: none; text-underline: none;">quantities</span>, <span style="color: windowtext; text-decoration: none; text-underline: none;">prices</span>, <span style="color: windowtext; text-decoration: none; text-underline: none;">discounts</span>, <span style="color: windowtext; text-decoration: none; text-underline: none;">payment terms</span>,
date of <span style="color: windowtext; text-decoration: none; text-underline: none;">performance</span> or <span style="color: windowtext; text-decoration: none; text-underline: none;">shipment</span>,
other <span style="color: windowtext; text-decoration: none; text-underline: none;">associated</span> <span style="color: windowtext; text-decoration: none; text-underline: none;">terms and
conditions</span>, and identifies a specific seller. Also <span style="color: windowtext; text-decoration: none; text-underline: none;">called</span> order.</div>
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><br /></span>
<br />
<div class="MsoNormal" style="background: white;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Oracle purchasing is a comprehensive procurement</span><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-size: 11.0pt; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> solution </span><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">designed to:</span><span style="color: #333333; font-family: "Helvetica","sans-serif"; font-size: 8.5pt; line-height: 115%; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> </span><span style="color: #333333; font-family: "Helvetica","sans-serif"; font-size: 8.5pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpFirst" style="background: white; margin: 0in 0in 0.0001pt 0.25in; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="color: #333333; font-family: Symbol; font-size: 8.5pt; mso-bidi-font-family: Symbol; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Help purchasing professionals reduce
administration costs.</span><span style="color: #333333; font-family: "Helvetica","sans-serif"; font-size: 8.5pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="background: white; margin: 0in 0in 0.0001pt 0.25in; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="color: #333333; font-family: Symbol; font-size: 8.5pt; mso-bidi-font-family: Symbol; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Process requisitions, purchase orders,
requests for quotation, and receipts quickly and efficiently.</span><span style="color: #333333; font-family: "Helvetica","sans-serif"; font-size: 8.5pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt; text-indent: -0.25in;">
<br /></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt; text-indent: -0.25in;">
<span style="color: #333333; font-family: "Times New Roman","serif"; font-size: 7.0pt; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> </span><span style="color: #333333; font-family: "Times New Roman","serif"; font-size: 7.0pt; mso-bidi-font-size: 11.0pt; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> </span><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Enable you to focus on:</span><span style="color: #333333; font-family: "Helvetica","sans-serif"; font-size: 8.5pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="background: white; margin: 0in 0in 0.0001pt 0.25in; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="color: #333333; font-family: Symbol; font-size: 10.0pt; mso-bidi-font-family: Symbol; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> Value Analysis<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; margin: 0in 0in 0.0001pt 0.25in; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="color: #333333; font-family: Symbol; font-size: 10.0pt; mso-bidi-font-family: Symbol; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Development of strategic supplier
relationships<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="background: white; margin: 0in 0in 0.0001pt 0.25in; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="color: #333333; font-family: Symbol; font-size: 10.0pt; mso-bidi-font-family: Symbol; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Management of the procurement process<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<b><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Oracle Purchasing satisfies the following
business needs:</span></b><span style="color: #333333; font-family: "Helvetica","sans-serif"; font-size: 8.5pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpFirst" style="background: white; margin: 0in 0in 0.0001pt 0.25in; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="color: #333333; font-family: Symbol; font-size: 8.5pt; mso-bidi-font-family: Symbol; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Replaces paper processing with online
requisition generation, purchase-order creation and document approval.</span><span style="color: #333333; font-family: "Helvetica","sans-serif"; font-size: 8.5pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; margin: 0in 0in 0.0001pt 0.25in; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="color: #333333; font-family: Symbol; font-size: 8.5pt; mso-bidi-font-family: Symbol; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Regulates document access, controls
modification activity and approval, and is based on organizational signature
and security policies.</span><span style="color: #333333; font-family: "Helvetica","sans-serif"; font-size: 8.5pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; margin: 0in 0in 0.0001pt 0.25in; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="color: #333333; font-family: Symbol; font-size: 8.5pt; mso-bidi-font-family: Symbol; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Minimizes</span><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-size: 11.0pt; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> data entry </span><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">time
with item-saving templates.</span><span style="color: #333333; font-family: "Helvetica","sans-serif"; font-size: 8.5pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; margin: 0in 0in 0.0001pt 0.25in; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="color: #333333; font-family: Symbol; font-size: 8.5pt; mso-bidi-font-family: Symbol; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Controls purchasing activity and enables
accurate, automatic pricing using approved suppliers and supplier lists.</span><span style="color: #333333; font-family: "Helvetica","sans-serif"; font-size: 8.5pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; margin: 0in 0in 0.0001pt 0.25in; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="color: #333333; font-family: Symbol; font-size: 8.5pt; mso-bidi-font-family: Symbol; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Consolidates purchase</span><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-size: 11.0pt; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> requirements from </span><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">multiple warehouses, plants or locations.</span><span style="color: #333333; font-family: "Helvetica","sans-serif"; font-size: 8.5pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; margin: 0in 0in 0.0001pt 0.25in; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="color: #333333; font-family: Symbol; font-size: 8.5pt; mso-bidi-font-family: Symbol; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Enables negotiations from a position of
strength based on easy access to purchase volume statistics and</span><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-size: 11.0pt; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> supplier performance </span><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">reports.</span><span style="color: #333333; font-family: "Helvetica","sans-serif"; font-size: 8.5pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; margin: 0in 0in 0.0001pt 0.25in; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="color: #333333; font-family: Symbol; font-size: 8.5pt; mso-bidi-font-family: Symbol; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: Verdana, sans-serif;"><span style="font-size: 10pt;">Facilitates communication between </span><span style="font-size: 13.3333330154419px;">requester</span><span style="font-size: 10pt;">, buyers, receiving staff, and accounts payable staff using online </span><span style="font-size: 13.3333330154419px;">inquiries</span><span style="font-size: 10pt;">, attachments and notes.</span></span><span style="color: #333333; font-family: "Helvetica","sans-serif"; font-size: 8.5pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; margin: 0in 0in 0.0001pt 0.25in; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="color: #333333; font-family: Symbol; font-size: 8.5pt; mso-bidi-font-family: Symbol; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Provides related functions, such as
marketing, finance, master scheduling, inventory management, production, cost
accounting, and customer</span><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-size: 11.0pt; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> order
entry </span><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">with access to purchasing information.</span><span style="color: #333333; font-family: "Helvetica","sans-serif"; font-size: 8.5pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="background: white; margin: 0in 0in 0.0001pt 0.25in; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="color: #333333; font-family: Symbol; font-size: 8.5pt; mso-bidi-font-family: Symbol; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Manages historical purchasing data.</span><span style="color: #333333; font-family: "Helvetica","sans-serif"; font-size: 8.5pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<b><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Benefits</span></b><span style="color: #333333; font-family: "Helvetica","sans-serif"; font-size: 8.5pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpFirst" style="background: white; margin: 0in 0in 0.0001pt 0.25in; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="color: #333333; font-family: Symbol; font-size: 10.0pt; mso-bidi-font-family: Symbol; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Automate the Entire Procure-to-Pay Cycle:
Define suppliers and agreements; then automate your entire purchasing cycle
from purchase order to settlement.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; margin: 0in 0in 0.0001pt 0.25in; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="color: #333333; font-family: Symbol; font-size: 10.0pt; mso-bidi-font-family: Symbol; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Improve Supply Base Management: Take
central control of all supplier and item master information with an application that
tightly integrate suppliers into your organization by leveraging advanced supply
management capabilities.<o:p></o:p></span></div>
<br />
<div class="MsoListParagraphCxSpLast" style="background: white; margin: 0in 0in 0.0001pt 0.25in; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="color: #333333; font-family: Symbol; font-size: 10.0pt; mso-bidi-font-family: Symbol; mso-bidi-language: HI; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Adapt to Any Purchasing Practice: Adapt the
application to your organization’s purchasing practices with uniquely
configurable policies and an open architecture that integrates legacy and
supplier systems.<o:p></o:p></span></div>
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><br /></span>
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><b>9. Sales Order:</b></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #333333; font-family: Verdana, sans-serif; font-size: 10pt;"><br /></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Sales orders represent
our mutually binding contract to provide the enumerated products and services
you have ordered for the dollar amount specified therein. Generation of a sales
order will automatically prompt our fulfillment department to ship your order
or activate your digital testing account and produce an invoice. A sales
order requires documentation. Examples include an email or fax in which
you place the order, or a government contract, or a signed price quote, or
organizational purchase order. Conditions of sale are included on sales
orders.<o:p></o:p></span></div>
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><br /></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">10. Pack Slip<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">11. Pick Slip:<o:p></o:p></span><br />
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><br /></span>
<br />
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><b>A pack slip</b> denotes what should be
"packed" for a delivery. It may consolidate several orders to a
route, truck or customer. However, in some businesses the <b>pack slip </b>or packing
slip shows what has been “picked" for delivery or shipment a pick
sheet denotes what items to pull from inventory. it too may be derived from
consolidated orders. for example: Customers A, B and C all have orders shipping
today. <o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Each customer is within 10 min of each other
and all will be delivered from the same truck/route. <o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">A single <b>pack slip</b> is generated, detailing
the 3 customer’s orders (qty and items) for the truck. <o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Depending on the type of picking utilized,
one or several pick sheets may be generated. in this case, we'll say there are
three "picking zones" in the warehouse. so three pick slips are
generated, one for each zone. the pick slip tells each zone picker what items
to pick. <o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">The three zones then deliver their picked
items to a staging zone where the items are sorted into 3 boxes, one for each
customer. <o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">These boxes get loaded onto the truck and
each one is checked against the pack slip to ensure that each customer is
receiving their order accurately. in short: a <b>pick slip </b>facilitates the
method/order/consolidation of picking items from inventory. a <b>pack slip</b>
facilitates the method in which orders are consolidated/organized and shipped
to a customer. "<b>pick</b>" - pick it from inventory "<b>pack"</b> -
pack up the truck</span><o:p></o:p></div>
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><br /></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><b>12. Drop Ship:</b><o:p></o:p></span><br />
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><b><br /></b></span>
<br />
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">One example of</span><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"> <i>drop ship</i> <span style="color: #333333;">is a manufacturer
shipping goods directly to one of its customers' customer (instead of delivering
the goods to the customer that placed the order with the manufacturer). The
following illustrates the concept of drop ship, drop shipping or a drop
shipment.</span><br style="box-sizing: border-box;" />
<br style="box-sizing: border-box;" />
Assume that XYZ Distributors Inc (XYZ) sells only
the Premier brand of water heaters. XYZ receives an order for 40 of the water
heaters from a condominium developer located 30 miles away. XYZ then places an
order for 40 water heaters from Premier Manufacturing Corp. However, XYZ
instructs Premier to <i>deliver them directly</i> <i>to the
condo project.</i> <span style="color: #333333;">So instead of delivering
them to XYZ's warehouse, Premier is asked to</span> <i>drop ship</i> <span style="color: #333333;">them to the condo project. The drop ship means that XYZ
will not have to receive the water heaters, unload them, reload them onto its
trucks and then deliver them to the condo project. Hence the drop ship allows
XYZ to avoid some expensive non-value-added activities.</span><br style="box-sizing: border-box;" />
<br style="box-sizing: border-box;" />
When Premier ships the water heaters, it will bill
XYZ and will send the invoice to XYZ. As a result XYZ will have a purchase and
an <span style="color: #333333;"><span style="color: #333333; text-decoration: none; text-underline: none;">account payable</span></span> <span style="color: #333333;">for the amount
charged by Premier. XYZ will prepare its own sales</span> <span style="color: #333333;"><span style="color: #333333; text-decoration: none; text-underline: none;">invoice</span></span> <span style="color: #333333;">to bill the condo
developer.<o:p></o:p></span></span></div>
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><br /></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><b>13. Back Order:</b><o:p></o:p></span><br />
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><br /></span>
<br />
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">A customer order that has not been fulfilled.
A back order generally indicates that customer demand for a product or service
exceeds a company's capacity to supply it. Total back orders, also known as
backlog, may be expressed in terms of units or dollar amount.</span><o:p></o:p></div>
<span style="-webkit-tap-highlight-color: transparent; -webkit-text-stroke-width: 0.150000005960464px; font-family: gandhiserif-regular-webfont, Helvetica, Arial, Verdana, sans-serif; font-size: 15px;"><br /></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><b>14. ATP: Available to Promise:</b></span><br />
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">is a business function that provides a
response to customer order enquiries, based on resource availability.It
generates available quantities of the requested product, and delivery due
dates. Therefore, ATP supports order promising and fulfillment, aiming to
manage demand and match it to production plans.<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Available-to-promise functions are
IT-enabled and usually integrated in enterprise management <span style="color: #333333; text-decoration: none; text-underline: none;">software</span> packages.
However, ATP execution may need to be adjusted for the way a certain company
operates.<o:p></o:p></span></div>
<br /></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"><b>15. Lot/Serial Number</b><o:p></o:p></span><br />
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Lot tracking system records information
regarding a batch of product. Lot tracking allows to track several units of a
stock item using the same lot or batch number. User can determine what can be
purchased or sold by Lot status. <o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Expiry dates and user defined statuses
allow you to further control the stock item. You cannot sell stock items that
have reached or passed their expiry date.. You can track items by lot number
and serial number - Lot tracked items are where the tracking (Lot) number refers
to a specified quantity of the items, serial numbers are applied to individual
items.<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Lot Control and serialization options are
defined at the system level and when one of these options is activated
individual items are defined to be controlled by either lot number or serial
number or by item number (not lot or serial tracked) on the part master file. <o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">When a part is defined as being tracked by
lot number or serial number, that tracking is enforced throughout all material
transactions for that item and upward through its parent items.<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><br /></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">For purchased items lot or serial numbers
are required for the full quantity of receipt, and are entered as part of the
receiving transaction. For receipts with many serial number tracked items,
ranges of numbers may be entered.<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><br /></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">A running total of items accounted for with
lot or serial number assignments are displayed, thereby ensuring that the
entire received quantity is properly identified prior to completion of the
transaction.<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><br /></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";">Furthermore, the system checks current
inventory to ensure that duplicate numbers are not assigned. On subsequent
inventory transactions, lot and serial traceability is enforced upward through
the item's bill of material structure. The lot or serial number and quantity
are required on all material issues.<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt;">
<span style="color: #333333; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HI; mso-fareast-font-family: "Times New Roman";"><br /></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">17. Organization:</span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">Generic Definition :</span><br />
<div class="table block" frame="all" id="wrenchorgcomm_0.0-ch01_s01_s01_t01" style="-webkit-text-stroke-width: 0px; color: black; font-family: Calibri2, Calibri, Arial, 'Trebuchet MS', sans-serif; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; margin-bottom: 20px; margin-top: 20px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<table cellpadding="0" cellspacing="0" style="border-collapse: collapse; font-size: 0.9em;"><tbody>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;"><b class="emphasis bold">Dictionary Definition</b></td></tr>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;">(1) the act of organizing or the state of being organized; (2) an organized structure or whole; (3) a business or administrative concern united and constructed for a particular end (4) a body of administrative officials, as of a political party, a government department, etc (5) order or system; method.<span class="footnote" id="wrenchorgcomm_0.0-fn01_002">organization. (2009). Collins English Dictionary—Complete & Unabridged 10th Edition. Retrieved March 18, 2012, from Dictionary.com website:<span class="Apple-converted-space"> </span><a class="link" href="http://dictionary.reference.com/browse/organization" style="color: black; text-decoration: underline; word-wrap: break-word;" target="_blank">http://dictionary.reference.com/browse/organization</a></span></td></tr>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;"><b class="emphasis bold">General Business Definitions</b></td></tr>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;">“a system of consciously coordinated activities of two or more persons.”<span class="footnote" id="wrenchorgcomm_0.0-fn01_003">Barnard, C. I. (1938).<span class="Apple-converted-space"> </span><i class="emphasis">The functions of the executive</i>. Cambridge, MA: Harvard University Press, pg. 73.</span></td></tr>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;">“The accomplishment of an objective requires collective effort, men set up an organization designed to coordinate the activities of many persons and to furnish incentives for others to join them for this purpose.”<span class="footnote" id="wrenchorgcomm_0.0-fn01_004">Blau, P. M., & Scott, W. R. (1962).<span class="Apple-converted-space"> </span><i class="emphasis">Formal organizations: A comparative approach</i>. San Francisco: Chandler, pg. 5.</span></td></tr>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;">“A social unit of people, systematically structured and managed to meet a need or to pursue collective goals on a continuing basis. All organizations have a management structure that determines relationships between functions and positions, and subdivides and delegates roles, responsibilities, and authority to carry out defined tasks. Organizations are open systems in that they affect and are affected by the environment beyond their boundaries.”<span class="footnote" id="wrenchorgcomm_0.0-fn01_005">organization. (n.d.). Retrieved March 18, 2012, from BusinessDictionary.com website:<span class="Apple-converted-space"> </span><a class="link" href="http://www.businessdictionary.com/definition/organization.html" style="color: black; text-decoration: underline; word-wrap: break-word;" target="_blank">http://www.businessdictionary.com/definition/organization.html</a></span></td></tr>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;">“a Body of individuals working under a defined system of rules, assignments procedures, and relationships designed to achieve identifiable objectives and goals.”<span class="footnote" id="wrenchorgcomm_0.0-fn01_006">Greenwald, H. P. (2008).<span class="Apple-converted-space"> </span><i class="emphasis">Organizations: Management without control</i>. Los Angeles, CA: Sage, pg. 6.</span></td></tr>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;"><b class="emphasis bold">Organizational Behavior Definitions</b></td></tr>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;">“a social unit within which people have achieved somewhat stable relations (not necessarily face-to-face) among themselves in order to facilitate obtaining a set of objectives or goals.”<span class="footnote" id="wrenchorgcomm_0.0-fn01_007">Litterer, J. A. (1963).<i class="emphasis">Organizations: Structured behavior</i>. New York: John Wiley and Sons, pg. 5.</span></td></tr>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;">“an organization is a complex system, which includes as subsystems: (1) management, to interrelate and integrate through appropriate linking processes all the elements of the system in a manner designed to achieve the organizational objectives, and (2) a sufficient number of people so that constant face-to-face interaction is impossible.”<span class="footnote" id="wrenchorgcomm_0.0-fn01_008">Lundgren, E. F. (1974).<span class="Apple-converted-space"> </span><i class="emphasis">Organizational management: Systems and process</i>. San Francisco: Canfield Press, pg. 7.</span></td></tr>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;"><b class="emphasis bold">Economics Definition</b></td></tr>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;">A short hand expression for the integrated aggregation of those persons who are primarily involved in: “(1) the undertaking or managing of risk and the handling of economic uncertainty; (2) planning and innovation; (3) coordination, administration and control; (4) and routine supervision” of an enterprise.<span class="footnote" id="wrenchorgcomm_0.0-fn01_009">Harbison, F. (1959). Entrepreneurial organization as a factor in economic development.<span class="Apple-converted-space"> </span><i class="emphasis">The Quarterly Journal of Economics, 70</i>, 364–379, pg. 365.</span></td></tr>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;"><b class="emphasis bold">Industrial/Organizational Psychology Definition</b></td></tr>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;">“work consists of patterned human behavior and the ‘equipment’ consists of the human beings.”<span class="footnote" id="wrenchorgcomm_0.0-fn01_010">Katz, D., & Kahn, R. L. (1978).<span class="Apple-converted-space"> </span><i class="emphasis">The social psychology of organizations</i>. New York, NY: John Wile & Sons, pg. 55.</span></td></tr>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;">“lively sets of interrelated systems [task, structure, technology, people, and the environment] designed to perform complicated tasks.”<span class="footnote" id="wrenchorgcomm_0.0-fn01_011">Levitt, H. J. (1972).<span class="Apple-converted-space"> </span><i class="emphasis">Managerial psychology: An introduction to individuals, pairs, and groups in organizations</i>. Chicago: The University of Chicago Press, pg. 265.</span></td></tr>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;"><b class="emphasis bold">Organizational Communication Definitions</b></td></tr>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;">“social collectives in which people develop ritualized patterns of interaction in an attempt to coordinate their activities and efforts in the ongoing accomplishment of personal and group goals.”<span class="footnote" id="wrenchorgcomm_0.0-fn01_012">Kreps, G. L. (1986). Organizational communication. New York: Longman, pg. 5.</span></td></tr>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;">“including five critical features—namely, the existence of a social collectivity, organizational and individual goals, coordinated activity, organizational structure, and the embedding of the organization with an environment of other organizations.”<span class="footnote" id="wrenchorgcomm_0.0-fn01_013">Miller, K. (2012).<span class="Apple-converted-space"> </span><i class="emphasis">Organizational communication: Approaches and processes</i><span class="Apple-converted-space"> </span>(6th ed.). Boston, MA: Wasdworth-Cengage, pg. 11.</span></td></tr>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;">“Communicative structures of control.”<span class="footnote" id="wrenchorgcomm_0.0-fn01_014">Mumby, D. (in press).<span class="Apple-converted-space"> </span><i class="emphasis">Organizational communication</i>. Los Angeles, CA: SAGE.</span></td></tr>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;">“an organized collection of individuals working interdependently within a relatively structured, organized, open system to achieve common goals.”<span class="footnote" id="wrenchorgcomm_0.0-fn01_015">Richmond, V. P., & McCroskey, J. C. (2009).<span class="Apple-converted-space"> </span><i class="emphasis">Organizational communication for survival: Making work, work</i><span class="Apple-converted-space"> </span>(4th ed.). Boston: Allyn & Bacon, pg. 1.</span></td></tr>
<tr><td style="border-style: solid; border-width: 1px; padding: 5px;">“an aggregate of persons, arranged in predetermined patterns of relationships, in order to accomplish stated objectives.”<span class="footnote" id="wrenchorgcomm_0.0-fn01_016">Redding, W. C. (1964). The organizational communicator. In W. C. Redding & G. A Sanborn (Eds.),<span class="Apple-converted-space"> </span><i class="emphasis">Business and industrial communication: A source book</i><span class="Apple-converted-space"> </span>(pp. 29–58). New York: Harper & Row, pg. 33.</span></td></tr>
</tbody></table>
</div>
Organization id EBS: </div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
</div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
What is an Organization? In EBS it is a generic term, infact, varied term.
In Oracle EBS an organization can be a Legal Entity, or an Inventory,
or a department. Anything can be treated as organization in Oracle.
In our daily routine if we say the word “organization”, we will
certainly be referring to some company, for example, Inbox Business
Technologies, IBM, Acer, HP, these are the example of organization
selling hardware. But in Oracle Multi Org structure they are referred to
as Legal Entities.<br />
<br />
The Multi Org structure in Oracle consists of following organizations<br />
<br />
<ul>
<li>Business Group or HR Business Group</li>
<li>Ledger</li>
<li>Legal Entity or GRE</li>
<li>Operating Unit</li>
<li>Inventory Organization</li>
</ul>
<br />
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">18. Business Unit:</span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"> BUSINESS GROUP (BG)<br /><br />A business group is the top level in multi org structure. Oracle view human resource as the basis for the business. A human resource is selling the products that organization is manufacturing, a human resource is purchasing raw materials required to make a product, a human resource is making accounting and financials statement. In short a legal entity transacts because of Human Resources.<br /> </span></div>
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">19. Multi Org</span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">20. DFF: Descriptive Flex Fields<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">21. KFF: Key Flex Fields<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">22. Value Sets<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">23. Folders</span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">24. WHO Columns<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">25. Oracle Reports<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">26. Oracle Form<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">27. Workflow Builder<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">28. Toad<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">29. SQL Developer<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">30. SQL Navigator<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">31. Discoverer Reports<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">32. XML/BI Publisher<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">33. ADI: Application Desktop Integrator<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">34. Winscp<o:p></o:p></span></div>
<div style="line-height: 9.0pt; margin-bottom: .0001pt; margin: 0in; mso-line-height-rule: exactly;">
<span style="font-family: Verdana, sans-serif; font-size: 10pt;">35. Putty<o:p></o:p></span></div>
<div style="line-height: 9pt; margin: 0in 0in 0.0001pt;">
<br /></div>
</div>
</div>
</div>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-18651341-3', 'auto');
ga('send', 'pageview');
</script>
<script src="http://resources.infolinks.com/js/infolinks_main.js" type="text/javascript"></script>
</div>
Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0tag:blogger.com,1999:blog-7646920909051971879.post-38324659994853022702015-03-24T11:00:00.000-07:002015-03-24T12:30:37.076-07:00<div dir="ltr" style="text-align: left;" trbidi="on">
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikitLAEGp0YNGxVuDVOpy9i4rUMBiaZOuJJ1OFkY0vjuge2iV4zToGA3R5-zxZh3t6boavUEiwK3zAjN-nzEA4yNXU-vyZ_mJz7Fgul8Q6GkKZ6pTDcGYZfDsRmTBVxD1tx0UirA7GnlvT/s1600/images2.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="Content writer ,Web designer Jobs" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikitLAEGp0YNGxVuDVOpy9i4rUMBiaZOuJJ1OFkY0vjuge2iV4zToGA3R5-zxZh3t6boavUEiwK3zAjN-nzEA4yNXU-vyZ_mJz7Fgul8Q6GkKZ6pTDcGYZfDsRmTBVxD1tx0UirA7GnlvT/s1600/images2.jpg" title="Hot jobs:Content writer ,Web designer Jobs" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Content writer ,Web designer Jobs</td></tr>
</tbody></table>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br /></div>
Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0tag:blogger.com,1999:blog-7646920909051971879.post-21904526171046214302015-03-24T10:50:00.000-07:002015-03-24T10:20:47.543-07:00<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDECQ2ndKzLQra2rf9yJN3DshN7eAKaodRdRKJ1TNKeNSCyowkg5Phn608c8yY_mwX8ujkJkL-UBw4RKDj_3IEgPdxxwLA2AodxqGWl54f0iALOYphYAGSOPOA7CAsIB6JEUS2z-MJ54LQ/s1600/images3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDECQ2ndKzLQra2rf9yJN3DshN7eAKaodRdRKJ1TNKeNSCyowkg5Phn608c8yY_mwX8ujkJkL-UBw4RKDj_3IEgPdxxwLA2AodxqGWl54f0iALOYphYAGSOPOA7CAsIB6JEUS2z-MJ54LQ/s1600/images3.jpg" height="148" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br /></div>
Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0tag:blogger.com,1999:blog-7646920909051971879.post-74778827969260004132015-03-24T08:22:00.000-07:002015-03-24T10:21:01.116-07:00<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjz_UIatVavSAKDRCpFHIdHOXy_1NJINSsMAdbiZIQR9BSsm3wlzLwnA4aTuA8dsnBi_7fa5W5svJ9SeUMmlGZ0G9bQqPwZ7JUGiSMT17B2dwwTj1oVIrvHL1g4_tKMv7afQg3PK3c8JKnP/s1600/images1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjz_UIatVavSAKDRCpFHIdHOXy_1NJINSsMAdbiZIQR9BSsm3wlzLwnA4aTuA8dsnBi_7fa5W5svJ9SeUMmlGZ0G9bQqPwZ7JUGiSMT17B2dwwTj1oVIrvHL1g4_tKMv7afQg3PK3c8JKnP/s1600/images1.jpg" height="217" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
Flash news ...</div>
Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0tag:blogger.com,1999:blog-7646920909051971879.post-73035197099208687222015-03-22T09:49:00.000-07:002015-03-24T10:24:41.555-07:00<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqV-dzCV3oV90rA6Mu4TxR_IO_ORg4Z1AWfu6OztRWtiE1lc6nE4E1TszPX9kMsUR9tE_TAGSI3UR-0W9XNZkRx55mliOF5vKoq7QH7XNyLsryUhro2kmXeCREa3L4U2O4fAS4gXbo5C75/s1600/images12.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqV-dzCV3oV90rA6Mu4TxR_IO_ORg4Z1AWfu6OztRWtiE1lc6nE4E1TszPX9kMsUR9tE_TAGSI3UR-0W9XNZkRx55mliOF5vKoq7QH7XNyLsryUhro2kmXeCREa3L4U2O4fAS4gXbo5C75/s1600/images12.jpg" height="158" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br /></div>
Sekhar Bynahttp://www.blogger.com/profile/08314069562943847860noreply@blogger.com0