Document Management and Oracle EBusiness Suite Attachments - Seven Implementation Options Explained
Friday, 09 July 2010 00:52
Anil Passi
In oracle EBusiness Suite, document/attachments for an employee can exist against various different types of records. To access those documents, the back office staff has to navigate to various different  responsibilities/menu/screens/navigation paths and search for the record to which documents are attached. For example documents can exist against staff's HRMS person record, against their absence records[medical certificates], qualification records [professional certificates], appraisal records, CRM Service requests [complaints, other issues], SIT's, EIT's etc. It is a huge challenge for the back office HRMS staff to access those attached documents in a simple manner from various different places. The navigation to so many screens can be a nightmare for the back office HRMS team, just to pluck out a single document against for one of their staff members.
I have had multiple clients demanding an elegant solution to the issue around access to these EBusiness Suite documents in a secured and simple way. In this article, I would like to discuss seven different practical implementation options/solutions that can be implemented to achieve a unified yet secured access to documents held within Oracle EBusiness Suite. You can pick the option depending upon your business requirements and subject to the Document Management system that you have implemented.
Before getting into the details, in brief, the seven options are 1. Copy the attachments from different entities into PER_PEOPLE_F entity. 2. Synchronize with Document Management System like Documentum with Oracle EBusiness Suite using third party tools. Also use Attachment repositories to integrate with UCM. 3. Consume document management system's web services, routed via XML Gateway 4. Use SOA Middleware to pull documents from Oracle Apps and push the documents into Document Management System 5. Oracle 11g Database feature to consume document management system's webservice from PL/SQL DB trigger attaching blob attachments 6. Use Business Events, with PL/SQL or Java subscription consuming document management system's webservice 7. Use forms personalization in HRMS Person Screen to enable tools menu
Option 1 - Copy the attachments from different entities into PER_PEOPLE_F entity. This is a simple solution that can be implemented via PL/SQL code as explained below.
Read more...
People Management Templates
Sunday, 27 June 2010 17:42
Raja Palli
 Before we talk about 'People Management Templates' in Oracle HRMS let us find out about 'Forms Configurator' in HRMS which is used to create/modify such templates for easy use of forms in HRMS.You have many Forms customisation facilities in Oracle HRMS. But 'Forms Configurator' is one such tool which holds the best of all features and easy-to-use user-friendly tool in HRMS.
'Forms Configurator' Navigation: Oracle HRMS Manager (Responsibility) -> Security -> Forms Configurator
Using configurator we can customise most forms in the following areas:
Read more...
Oracle Apps Development Book UK
Saturday, 26 June 2010 23:10
Anil Passi
UK reader can buy the Oracle Apps Development Book from this link
Extend FNDLOAD
Sunday, 20 June 2010 10:14
Anil Passi
There are several instances where you will be required to extend the standard FNDLOAD processing. This allows you to implement new data centric logic. Let us take a simple example. You might have descriptive flexfields on lets say FND_LOOKUP_VALUES table, and the descriptive flexfield Attribute1 might be attached to a table validated value set. Therefore the table will contain entries as
Read more...
Remove Descriptive Flexfield Segments by Script
Sunday, 20 June 2010 09:51
Anil Passi
Here is a small script to delete all the segments in a Descriptive FlexField. This is useful in some cases because FNDLOAD does not perform a delete of segments. Hence such a script can be used for cleanup of the DFF. Simply replace the contents in "bold" text below to make this work on your environment
Read more...
SOA and Integration Repository - 11i versus R12
Friday, 11 June 2010 01:03
Anil Passi
Integration Repository [ iRep ] in Release 11i is perhaps meaningless unless your customer has Oracle SOA Suite and of course unless the developer decides to use the Oracle Apps Adapter in their BPEL flow.  To work with integration repository in Release 11i, not only you are enforced to use Oracle's Oracle Apps Adapter, but also there is another major restriction in Integration Repository of Release 11i. This second limitation exists because the Integration Repository in Release 11i is not extensible. These limitations however are elegantly overcome in Release 12. This article discusses the comparison and R12 SOA features in details.
Where is this OA Framework component personalized
Thursday, 10 June 2010 07:24
Anil Passi
Sometimes you get runtime errors in OA Framework self service pages due to some unwarranted personalizations. For example, someone can create a text input accidentally as a message link or someone might add a controller class that is not yet deployed. The issue becomes intriguing because a custom component can be added to an OA Framework page at various levels of personalization. Also, even if you know the name of the page where the error occurred, yet that page might consist of several nested regions, and one of those regions might have the culprit personalized component at one of the personalization leves. This article presents a simple example in pursuit of finding the controller class which exists in personalization layer. This can be applied for any OA Framework component in MDS. All you need to do is to run a simple SQL statement to query MDS Repository in JDR tables.
Find the parameters passed to a business event
Thursday, 10 June 2010 06:49
Anil Passi
In many cases there is no documentation available in Oracle to specify the list of parameters that are passed to Workflow Business Events. In case you wish to develop a custom subscription for an existing Oracle Apps business events, then it helps for you to know the list of Business Event Parameters being passed by Oracle's code to this business event. More importantly, some products do not even pass parameters, but instead only pass XML payload to the business event. Using the simple steps below, you will be able to capture both the XML payload and parameters that are passed to the business event.
Although you can query table wf_deferred, but this table will only list the event details provided the event was raised from pl/sql layer. The sample code in this article can be applied equally to any business event regardless of whether it gets raised from pl/sql or from java
Running the R12 iExpenses Page from JDeveloper
Tuesday, 01 June 2010 01:46
Anil Passi
In This article, you will see a video tutorial for running the iExpenses Page from JDeveloper. Before you begin your configuration of JDeveloper, you must first do some analysis of the page that you wish to run from EBusiness Suite.
OA Framework - Getting started in R12
Monday, 31 May 2010 00:20
Anil Passi
In this audio-video tutorial you will see how to download the right version of jDeveloper for R12.1 instance and will also learn how to run your first OA Framework Page from jDeveloper for R12.1.1 version. This video will get you started with OA Framework Development in Release R12. Following this, in next few articles, I will show a demonstration of taking this to the next steps, i.e. extending Self Service HRMS, iExpenses, Project Management etc.
The steps in brief are listed below, you will see these in the audio-visual link too
Read more...
iRecruitment Vacancy Segregation Solution
Wednesday, 26 May 2010 22:32
Anil Passi
In this article you will find a complete real life solution in Oracle iRecruitment that I implemented for one of my prestigious
clients in past. In large organizations that have implemented Oracle iRecruitment, usually there is a business need to have
multiple external facing Oracle iRecruitment URL's.
Each such URL might correspond to one or more business groups.
For example, the standard URL http://apps2fusion.com:8012/OA_HTML/IrcVisitor.jsp can display all the vacancies across
all the business groups in apps2fusion.
However, your client might need URLs similar to below
http://apps2fusion.com:8012/OA_HTML/xxUSA.jsp
The above URL should show vacancies from all the business groups that are in USA http://apps2fusion.com:8012/OA_HTML/xxUK.jsp
The above URL should show vacancies from all the business groups that are in United Kingdom http://apps2fusion.com:8012/OA_HTML/xxIndia.jsp The above URL should show vacancies from all the business groups that are in India
I am giving this totally for free despite the sales potential of this solution.
It will not take you more than 20minutes to implement this solution by following steps in attached document.
This document describes the detailed steps for implementing Vacancy segregation in Oracle iRecruitment by attaching
one or more business groups to a URL.
I will be sharing further real-life solutions of my past projects via this URL. You may decide to share your solutions too.
http://apps2fusion.com/solutions
Read more...
OAF Personalization and Extensions - A case study
Monday, 24 May 2010 20:07
Senthilkumar Shanmugam
Abstract OAF Personalization means personalize the user interface (UI) of Oracle Self-Service Web Applications without modifying any underlying code whereas OA Framework extensibility is geared to enable customers to add new functionality and override or extend existing business logic beyond what can be accomplished via personalization. In short it the programmatic approach for personalization. 
In this article I will explain a case study for OAF Personalization and Extension by analyzing real time requirement and how we have to use OAF Personalization and OAF Extension tomeet the requirement.
Read more...
Install missing rpm packages from Oracle's Yum server for Oracle Enterprise Linux 5
Wednesday, 19 May 2010 22:03
Anil Passi
World wide web is full of hits/errors whereby techies & DBA's try to install Oracle Database or Oracle R12 or other Oracle Products on Oracle Enterprise Linux, and they bump into missing rpms. In this article, you will see step by step instructions of how you can leverage the public rpm repository exposed by Oracle. There is no need of login/password to install these publicly available rpm's from Oracle's website. Missing RPM's are the single most important hurdle that dba's & developers must cross when installing desired Oracle software's on linux boxes. The best way for any Oracle developer to get started with Linux based installations is by installing Oracle 11g Database on Oracle Enterprise Linux. Steps are a. Register, download & install VMWare server. Youtube has many videos for this. Simply search for VMWare server install in http://youtube.com b. Register and download Oracle Enterprise Linux from http://edelivery.oracle.com/linuxc. Download Oracle Database 11g for Linux from d. Unzip the files in any temp/staging or installation directory By following steps a) to e), you can get first hand experience of the process of installing Oracle Software's on linux. However, the Step (e) on Oracle's webpage does not give a clue about how you will install the RPMs This article gives step by step instructions to install missing RPMs, and this knowledge can be carried forward into learning installation of other complex Oracle Products.
Read more...
My Oracle Podcast Interview on oracle.com
Wednesday, 19 May 2010 23:36
Anil Passi
In this podcast on Oracle.com, I have explained what lies inside the Oracle EBusiness Suite Extensibility book. This is a 10minutes podcast, and which you can listen to over the web, or for best quality, listen on iPhone :) http://oracle.com/podcasts/author-podcasts.html
Read more...
Add Workflows Notification Worklist To Home Page
Sunday, 28 March 2010 00:38
Anil Passi
This article is a quick video demo of how you can leverage personalizations to display notification worklist on the home page of EBusiness Suite. This will allow the users to see the open notifications as soon as they login to EBusiness Suite
Read more...
Limitations in Attachments using OAF Personalizations - - Part 3
Saturday, 27 March 2010 01:29
Anil Passi
The attachment functionality via personalization has got two limitations. The first limitation has a workaround and second limitation has some proper solution. What are these limitations and how can we overcome those? We will discuss those in this article. The first limitation is that you can specify only one primary key when defining attachments via personalization. For example if you wish to capture attachments against a combination of PO Header Id and PO Line Number, then in such a case you will not be able to implement this requirement via personalization. It must be noted that this is just an example, because in real life you would rather use po_line_id as the primary key. But in some project cases we do need composite primary key to identify the attachments. The second limitation is that the view object attribute that is used as a primary key of attachment must have a value populated in it, otherwise you cannot upload the attachments. It sounds obvious that you need a primary key value to attach documents against it. This is logical because you must have the transaction_id in place before you can load attachments against that transaction. However in reality, most of the screens generate the primary key just prior to the commit taking place, which means attachments can not be uploaded until after the save/apply button has been clicked by the user.
In this article we will discuss the possible solutions for both these limitations
Read more...
|
|
