Apps To Fusion

.......contents copyright protected by FocusThread UK Ltd

 
  • Increase font size
  • Default font size
  • Decrease font size
We are glad to announce the launch of Forum for Customizations and Extensions. Click here to visit http://apps2fusion.com/forums
Our OA Framework, BPEL Development & Apps DBA Trainings from USD 299 only [on weekends] . Click here for details.
Also see here fully verifiable feedbacks/testimonials

How to call Oracle Apps Adapters from BPEL ?

This article would cover setups required to enable BPEL to poll Oracle apps adapter as well as we will also see an example of how all of this fits together

 

Read more...
 

Synchronous BPEL Process Tutorial

Synchronous BPEL Process Tutorial

A Synchronous BPEL Process is one which you call and wait for the reply before proceeding further.

This is used in real time processing of services.

 

Anil has done an excellent job in making us create a HelloWorld.

I have created a similar HelloWorld for our use.

 

We will call the same HelloWorld process created earlier. As this process gives us a reply in real time, this can be used as a synchronous process.

Read more...
 

How to get elapsed time for APEX region?

 

Oracle APEX application is blazingly fast. Its' performance can be negatively effected by poorly written queries. To optimize application performance, you can use few substitution strings to see elapsed time for rendering each region in a page. This helps in pin pointing long running regions and tuning queries behind them.

Read more...
 

How to display company logo for APEX application?

A basic requirement in most implementations is displaying company logo. This article shows how to achieve it in Application Express.

Requirement:
Display Apps2Fusion logo on Person Details application http://apex.oracle.com/pls/otn/f?p=62577. To take step forward, I want to make the image clickable to redirect user to apps2fusion website in separate window.

Read more...
 

Application Items in APEX

Hassan, one of the readers has asked I have requirement to capture where if I would be coming from some page say 'page23' then page 2 items should be displayed as uneditable. Can you please mention how I can cater this case in Apex?

Hassan's requirement is, suppose you have two pages Manager and User from where you can navigate to Order page. Items in Order page say Order Number, Order date are editable only when you come from Manager page. Otherwise they are read only or display only fields. This is a perfect example to show use of Application Items.
Read more...
 

How to extend root application module using nested application module

My previous article on Nested application module showed extending root AM by attaching nested AM programmatically. In this article I'll show another approach to achieve same objective. My objective is to add custom logic to print "Requisition Header Id" in console when "Add to Cart" button is pressed during requisition creation in iProcurement. Some details of 'About this Page' for Non-Catalog Request page.

Page Name: NonCatalogRequestPG
Controller: NonCatalogRequestCO
AM: RequisitionAM

Read more...
 

Save State before branching - New Security feature in APEX 3.2

You have seen how APEX URL carries parameters when branched from one page to another. Session State Protection can prevent users from tampering URL, but it doesn't help much in not showing parameters in URL. Imagine how it could be a security vulnerability when you pass sensitive information like passwords, ssn etc.

Read more...
 

Nested Application Modules in OA Framework

In one of my old articles on OA Framework extension, I briefly mentioned about Nested Application modules. Today I will explain how Nested Application module can be used. Nested AM is an application module which is under the scope of root application module. Root application module is the AM attached to top region of the page during design time. It maintains the session state and retention level for requests between client and server.

Root AM can contain one or more nested AMs which can themselves nest children to any arbitrary level. In this scenario, the root AM has access to all the data/objects held by its children, and all children participate in the same transaction established by the root.

Read more...
 

Raising Business Event from PL/SQL or Java Layer

Following are the questions can often come to mind when dealing with Business Event Subscriptions
1. What is the difference between raising a business event from PL/SQL or from Java
2. Why you should not raise a Business Event from OA Framework using a JDBC call to "wf_event.raise"
3. The subscription does not fire in real time, even though business subscription phase is less than 99

Let us deal with these questions one by one.

Read more...
 

Invoke Web Service via Business Event

With the introduction of Integrated SOA Gateway, there are plenty of new SOA related features in R12.1 version. In this article we will see a video demo of the wizard for invoking webservices via Business Event. In R12.1 you can create a subscription of type "Invoke Web Service". Once you select this subscription, you are then prompted to enter the WSDL of the webservice that must be invoked in response to the business event. This initiates a Web Service subscription wizard in R12.1. These steps are shown in the video link below
Read more...
 

Oracle AIM Project Management Methodology

Oracle AIM Project Management Methodology provides the basic framework in the Implementation of Oracle E-Business Suite to Clients by the Implementers. I have prepared this document based on my Project Management experiences and this may not be a 100% fool proof method. But I tried to give importance to the basics of AIM Methodology which will help the freshers, Intermediate and average consultants to gain the basic understanding and knowledge of Oracle AIM Methodology and grow up in their career.

Click here to access this document

 

Prevent URL tampering using APEX Session State Protection

By now you should be having a fair idea of high usability of Oracle Application Express a.k.a APEX with its easy navigation between pages using column links, branches, breadcrumbs, navigation tabs, etc. For example, in Person Details application you can click on edit icon on a person row which takes you to Edit page for editing and saving that person details. The navigation here is done through column link by setting P4_PERSON_ID page item on Edit page (4) with Person_Id column value. If you observe closely parameters appear on URL string, it looks similar to

http://apex.oracle.com/pls/otn/f?p=62577:4:7632245014057279::NO::P4_PERSON_ID:241

where 7632245014057279 is my session id, P4_PERSON_ID is page item and 241 is page item value.

 

Read more...
 

Security using Authorization in APEX

Authorization is a process of determining whether an authenticated/identified person is permitted to access a resource or do an operation. It is based on set of privileges or roles assigned to the user. For Example, In Oracle database, Administrator have privilege to schedule jobs, while an user cannot.

How is Authorization different from Authentication?
Often Authentication and Authorization work together. In other words, Authorization follows Authentication.

Authentication determines Who are you?
Authorization determines What you are allowed to do?

Read more...
 

AME Part 4 - Customize AME For iRecruitment

In this article we will undertake a simple example for AME customization in iRecruitment. This example pertains to Vacancy creation process in iRecruitment.

In the last three AME articles we learnt
1. Basics of AME
2. How SSHR is attached to HRSSA Workflow and AME
3. How to create FND User for AME with necessary RBAC

This example has been purposely kept very simple to show you the end to end process involved in setting up Custom Logic for AME in eBusiness Suite. At the end of this example, you will find a link to see the video demo explaining how these steps are implemented in real-time. Do not miss out the video link at the end of this article if this is first time you are trying to customize AME.

Read more...
 

How to login to APEX with EBS login credentials (Authentication Scheme)

Application Security is one of the prime focuses when designing web applications, as they are prone to many security vulnerabilities. Oracle Application Express (APEX) has many built in security features like Authentication, Authorization i.e. access level of the user, session state protection etc.

This article helps you understand Authentication schemes in APEX and how to use EBS login credentials in APEX. Authentication is a mechanism to securely identify a trusted user. It may be really simple (just enter username) or complex hash algorithm to validate username and password entered by the user.
Read more...
 

AME SSHR - Part 3 - RBAC in AME

In this article we will learn the usage of RBAC [Role Based Access Control] in AME. To illustrate RBAC in AME, we will create a brand new user in eBusiness Suite and will allocate the AME Roles one by one to explain the purpose behind those roles. After going through this article you will learn that RBAC not only controls the menus that are visible in AME Responsibilities, but RBAC also controls the data that is visible to the AME User.
Read more...
 

AME SSHR - Part 2 - How AME relates to Self Service HR

In this article we will discuss basic tech stack used in Self Service HRMS. We will also see how AME is related to SSHR Workflow. The concept covered in this article must be understood before you can begin using AME in Self Service HRMS. In Self Service Oracle Human Resources there is a workflow named "HR". The short code of this workflow is HRSSA. This workflow is initiated as soon as any business activity is initiated in Self Service HRMS. Steps within this Workflow process can be mapped to a specific screens in OA Framework. Therefore the HR workflow guides which screen the user navigates through when making changes to data in self service HRMS. At this stage you might wonder why such an approach is required.
Read more...
 
  • «
  •  Start 
  •  Prev 
  •  1 
  •  2 
  •  3 
  •  4 
  •  5 
  •  6 
  •  7 
  •  8 
  •  9 
  •  10 
  •  Next 
  •  End 
  • »
Page 1 of 13

Search apps2fusion