Showing posts with label E-Business Suite. Show all posts
Showing posts with label E-Business Suite. Show all posts

Thursday, January 30, 2014

Oracle error 1403: java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1 has been detected in FND_SESSION_MANAGEMENT.CHECK_SESSION. Your session is no longer valid.

Issue:

Error after login page while executing operations/welcome

<PRE>Oracle error 1403: java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1 has been detected in FND_SESSION_MANAGEMENT.CHECK_SESSION. Your session is no longer valid. </PRE>

Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details.


Solution:

1. Please execute the following scripts from $FND_TOP/patch/115/sql:
SQL> @AFICXSMS.pls
SQL> @AFICXSMB.pls
 

NOTE:

Please ensure that the package FND_SESSION_MANAGEMENT is valid and confirm the version again.

2. Bounce the server.

3. Retest the issue.


4. Migrate the solution to production instance.

Thursday, December 5, 2013

Oracle E-Business Suite R12 - Oracle Homes

Oracle Homes
Oracle E-Business Suite (EBS) uses the latest database version, Oracle 10g. On the middle tier, Release 12 uses Oracle Application Server 10g and Oracle JDeveloper 10.1.3 for Web-based Framework applications. On the client, Oracle EBS uses version 5.0 of the Sun Java Plug-in.
Instructor Note
These ORACLE_HOME changes represent a significant update to the architecture and should be given appropriate consideration.

Wednesday, December 4, 2013

Oracle Applications Technology Layer R12 E-Business Suite


The Oracle Applications technology layer is an integrated collection of components whose functionality is applicable to all Oracle Applications modules. Components in the Oracle Applications technology layer include:


Applications DBA (AD)

Application Object Library (FND)

Applications Utilities (AU)

Common Modules (AK)

Workflow (WF)

Alert (ALR)

OA Framework (FWK)

Oracle XML Publisher (XDO)

Oracle E-Business Suite Application Networks usage


Most discussions about architecture make little, if any, reference to it. And yet, it can have a great impact on your performance. The network is the most important but the least visible component of the R12 architecture. The connection links themselves can vary from slow-speed dial-up connections to high-speed fiber optic channels.
For example, you can have a fast PC running on an R12 instance with a good applications tier and a clustered database tier, but still end up with bad results. If you are using a slow connection either directly from that machine (for example, a dial-up connection) or a shared connection with considerable traffic (a corporate T-1 line that already has considerable bandwidth usage), then you can experience poor performance. This problem cannot be attributed to a tier because it is a network-related issue.

Oracle E-Business Suite R12 Applications Tier


Applications Tier

The applications tier is responsible for storing and executing most of the business logic associated with R12. It also provides all the non-database services required in an R12 instance (for example, Web listeners, Forms servers, Reports servers, Concurrent Processing, and so on). The application tier is the key tier consisting of a host of services within the R12 architecture.

It is simpler to state that all components that are not part of either the desktop tier (that is, Forms display) or the database tier are assigned to the applications tier.

Prominently, six servers comprise the application tier for Oracle Applications:

Web server: The Oracle HTTP Server (powered by Apache) acts as the Web server. It processes the requests received over the network from the desktop clients, and includes additional components such as:

Web Listener

Java Servlet Engine

JavaServer Pages (JSP)

The Web Listener component of the Oracle HTTP Server accepts incoming HTTP requests (for particular URLs) from client browsers.

Forms server: The Forms server hosts the Oracle Applications forms and associated run-time engine that supports the professional interface. It is a component of the Oracle Developer 6i, which mediates the communication between the desktop client and the Oracle database server, displaying client screens and initiating changes in the database according to user actions. It caches data and provides it to the client as required—for example, when scrolling through multiple order lines that exceed the limitations of a single screen. The Forms server communicates with the desktop client using these protocols:

Standard HTTP network connection

Secure HTTPS network connection

TCP/IP connection

Reports server: The Reports server is automatically installed on the same node as the Concurrent Processing server, and its reports are contained in the same directory as the concurrent processing reports. However, reports generated by the Reports server are monitored and administered separately from the concurrent processing reports. It dynamically selects the language of the report at run time, so that users see the reports in the language they prefer.

Discoverer server (optional): The Discoverer server complements the Reports server by allowing performance of ad hoc queries and analysis of the resulting query output. It also allows users to perform projections based on possible changes to the business environment or other strategic factors.

Concurrent Processing server: User interactions with Oracle Applications data are conducted via HTML-based Applications or the more traditional Forms-based Applications. However, there are reporting programs and data update programs that need to run either periodically, or on an ad hoc basis. These programs that operate in the background while users continue to work on other tasks, may contain a large number of data-intensive computations, and run using the concurrent processing architecture. To ensure that resource-intensive concurrent processing operations do not interfere with interactive operations, they are run on a specialized server, the Concurrent Processing server. Processes that run on the concurrent processing server are called concurrent requests.

Administration server: The Administration server is located on the node on which you maintain the data model and the data in your Oracle Applications database. You carry out the following operations from this server:

 

Upgrading Oracle Applications

Applying database patches to Oracle Applications

Maintaining Oracle Applications data
 
Note: The Oracle HTML-based (formerly known as Self-Service) Applications:

Do not use Oracle Forms for the interface

Are designed in pure HTML and JavaScript

Dynamically generate HTML pages by executing Java code

Use a metadata dictionary for flexible layout

Operate by direct connection to the Web server

Technical Architecture: Oracle Applications R12


Technical Architecture: Oracle Applications R12

The R12 technical architecture is a direct response to the business needs of the customer. In support of these business needs, R12 has developed four architectural modes for users that are accessed and controlled through the Personal Home Page (PHP) or Portal.

PHP becomes the gateway through which the user has rights to access all the information to which they have been granted access. Thus, R12 administrative tasks are simplified while operations costs are reduced.

The architectural modes equate to common classes of users. Forms-based users are typically people involved in the transactional operations of an organization. They are full-time users who need and demand a robust, full-featured interface.

Self-service users are infrequent users who want their interface with R12 to be as simple and as quick as possible. Most users fall in this category.

Business intelligence users are senior executives who want an easy-to-use interface that can be used to reveal critical business information. By using a browser, the business intelligence products eliminate the need for users to learn a new system. If they are familiar with browsing, they know the basics of the business intelligence interface.

Finally, mobile users cover a surprisingly large range of users whose jobs are likely to keep them away from a readily available, network-connected computer. These users can range from sales representatives through inventory users. By utilizing the mobile interface, they are able to send and receive information at points where it is important and convenient for them.

How to Export data from Oracle E-Business suite R12

Go to the Form where you want to export the data.
I am exporting accounting values from vision database

Click on ‘File’

From the list select the “Export” option

 
 

Now the data is exporting form oracle application wait till complete the process 


Pop-up will prompt for saving the excel file 

 
Click on the OK to save the file

 Now you can check your data in excel


E-Business Suite Release 12 "SWAN" User Interface


The Swan UI brings together some of the best UI concepts from Oracle E-Business Suite, PeopleSoft, and JD Edwards applications. This new look and feel applies to the whole Oracle E-Business Suite (OAF, JTT (CRM) and Oracle Forms 10g products). The internal codename for improving the user interface was "Project Swan".

So the "R11-Duck" has been changed into a nice "Swan".

 

Converting From Previous Versions

If you've customized or extended Release 11i screens according to our published customization standards, there shouldn't be significant effort involved in getting to the Project Swan look-and-feel.  This is expected to vary a bit by the type of screen.

Oracle Applications Forms

Project Swan changes for Forms are limited to changing the color scheme and using non-boldfaced fonts for field values. These changes will be made in the technology layer, so no changes need to be made by Forms designers. There will be no change to the position or layout of any fields on the forms.

Oracle Applications Framework Screens

In most cases, no code changes will be needed, since the cosmetic changes will be implemented at the OAF technology layer. There may be specific cases where the use of custom stylesheets may require additional tweaks.

CRM/JTT Screens

Like OAF, in most cases, no code changes will be needed, since the cosmetic changes will be implemented at the technology layer. There may be specific cases (e.g. custom renderers, custom stylesheets) that require additional tweaks.

 
Migration Tools or Documents?

Given that the vast majority of existing screens should automatically be uplifted to the Swan UI, I haven't yet been told whether there will be tools to aid in conversions.  It's likely that we'll provide you with the same internal Swan conversion guidelines that E-Business Suite product teams are using today (albeit with better spell-checking and grammar).

Oracle EBS Shortcut Keys


Oracle EBS Shortcut Keys

Just about any repetitive task that you do within Oracle E-Business Suite of applications has an alternative easier method using Key Strokes. These come in handy when you are entering information, searching for information or just executing a set of tasks repeatedly.

So here we have a very own set of keystrokes that will help you accomplish those very tasks in just a couple of seconds. This list has been compiled based on my past experience and the need to have this kind of information handy to either a Business User or to an Functional Users. If time is of essence to you then you will not regret spending some time getting to be familiar with these few Shortcut Keys.

Short Keys for Oracle E-Business Suite
 
 
 
 
 
 
 
Function
Key
Function
Key
 
 
Actions LOV
Shift + Ctrl + F8
Help
Ctrl + H
Block Menu
Ctrl + B
Insert Record
Ctrl + Down
Clear Block
F7
List of Values
Ctrl + L
Clear Field
F5
List Tab Pages
F2
Clear Form
F8
Next Block
Shift + Page Down
Clear Record
F6
Next Field
Tab
Commit
Ctrl + S
Next Primary Key
Shift + F7
Copy
Ctrl + C
Next Record
Down
Count Query
F12
Next Set of Records
Shift + F8
Cut
Ctrl + X
Paste
Ctrl + V
Delete Record
Ctrl + Up
Previous Block
Shift + Page Up
Display Error
Shift + Ctrl + E
Previous Field
Shift + Tab
Duplicate Field
Shift + F5
Previous Record
Up
Duplicate Record
Shift + F6
Print
Ctrl + P
Edit
Ctrl + E
Prompt Value LOV
Shift + Ctrl + F9
Enter Query / Query Mode
F11
Return
Return
Execute Query / Run Query
Ctrl + F11
Scroll Down
Page Down
Exit/Cancel Query
F4
Scroll Up
Page Up
Function 0
Shift + Ctrl + F10
Show Keys
Ctrl + K
Function 1
Shift + Ctrl + F1
Undo Typing
Ctrl + Z
Function 2
Shift + Ctrl + F2
Update Records
Ctrl + U
Function 3
Shift + Ctrl + F3
 
 
Function 4
Shift + Ctrl + F4
 
 
Function 5
Shift + Ctrl + F5
 
 
Function 6
Shift + Ctrl + F6
 
 
Function 7
Shift + Ctrl + F7
 
 
Help
Ctrl + H
 
 
Insert Record
Ctrl + Down
 
 
List of Values
Ctrl + L
 
 
List Tab Pages
F2
 
 
Next Block
Shift + Page Down
 
 
Next Field
Tab
 
 
Next Primary Key
Shift + F7
 
 
Next Record
Down
 
 
Next Set of Records
Shift + F8
 
 
Paste
Ctrl + V
 
 
Previous Block
Shift + Page Up
 
 
Previous Field
Shift + Tab
 
 
Previous Record
Up
 
 
Print
Ctrl + P
 
 
Prompt Value LOV
Shift + Ctrl + F9
 
 
Return
Return
 
 
Scroll Down
Page Down
 
 
Scroll Up
Page Up
 
 
Show Keys
Ctrl + K
 
 
Undo Typing
Ctrl + Z
 
 
Update Records
Ctrl + U