Oracle Install Base - Track your assets and Items
Monday, 17 November 2008 22:18
Ranu Srivastava
Where exactly is my Copier that’s making me money & what’s happened to it?  Where is that Car we leased out & customer wants us to repair? How many cars? Where do I have copiers installed at various offices across country & how many copies did we print in last 3 months in division xxx? The Answer ‘Oracle Install Base’ InstallBase Overview Oracle Install Base is an item instance life cycle tracking application that facilitates enterprise-wide life cycle item management and tracking capability. Helps you to track instance from the time that it is received in inventory, in work in process, in projects, at customer sites, and throughout the return and repair process.Oracle Install Base is a centralized repository of information for an item instance and its tracking details including location, status, ownership, party, account and contact relationships, configuration data linked to Contracts,service requests repairs.Oracle Install Base is capable of tracking serialized and non-serialized item instances including: - Tangible items such as those that are manufactured, purchased, and shipped
- Intangible items such as software, services, licenses, and agreements
- Tangible assets including fixed, movable, and leased assets
- Key features and functionality include the following:
- Item instance maintenance
- Support for inventory transactions
- Centralized repository of information:
|
Projects Intelligence - Add new Fields using client extensions
Saturday, 15 November 2008 13:04
Anil Passi
Project Management is a Web Based application for Oracle Projects, which allows project managers to supervise the full project lifecycle of a project. All the pages for Oracle Project Management have been developed using OA Framework. This module also hooks onto another module named project intelligence that provides dashboards styled reporting for Projects. For performance reasons, the SQL intensive data used for some reports is stored in de-normalized format. This article contains step by step instructions to add custom columns [called measures] in the Project Management Intelligence screen as shown below. Project Intelligence screen for reporting is an OA Framework page, but yet we do not need to use traditional approach of extending OA Framework here. This requirement can be implemented by a combination of PL/SQL and Personalization, by leveraging Client Extension feature of Project Intelligence.
Read more...
Discoverer Installation and EUL Setup
Saturday, 15 November 2008 12:47
Pramod Bellamkonda
In this article, Pramod walks you through all the required steps from Installing Discoverer, to setting up End User Layer and logging in as Apps User to discoverer.
Pramod Bellamkonda is a technical Oracle Apps consultant with vast experience in OA Framework, Discoverer and other related technologies.
Feet free to get in touch with Pramod to avail his expert consulting services in US.
Read more...
Paris Seminar - This week - EBS Development Concepts + Best Practices Seminar
Saturday, 15 November 2008 12:34
Anil Passi
I will be delivering a face-to-face training seminar on Oracle Applications development and its best practices.
This seminar will take place on 20th November 2008 at Oracle Office in Paris. In the past, we used to run 1 Day seminars, which were quite challenging given the vastness of topics/subjects. Hence in future, these seminars will be 2 Day event. Seminar will cover day-to-day activities in Oracle Apps development, its challenges, best practices, and various troubleshooting tricks and techniques.
Also various Question and Answer sessions will be embedded within the seminar.
In case you are based in Europe, then you may consider attending this training event.
Click here to see the link to this seminarand register http://education.oracle.com/
This training seminar will cover various topics like
Read more...
BPEL,ESB Using Oracle SOA Suite - Article IV
Friday, 31 October 2008 03:33
Prasad Bhogle
BPEL Process Activities Summary In this article we will be discussing about various BPEL Process Activities and their usage. As the name suggests the process activities are nothing but the tasks to be performed at a specific stage. Considering a BPEL process as a workflow or a block diagram, process activities become the building blocks of BPEL Process.
Read more...
BI Publisher Training
Friday, 31 October 2008 14:37
Anil Passi
Focusthread is pleased to announce 4Day weekend basic+advanced BI Publisher training for just USD 399/- This training also covers integration of BI Publisher with OA Framework Details can be found at this link Course Fee: USD 399 Only/-
Training is scheduled on: 15th, 16th, 22nd & 23rd November 2008.
FND_USER Script for Techies
Thursday, 23 October 2008 23:43
Anil Passi
You can use this SQL Script to create a FND_USER for any Technical Developer that joins your team.
This simple script will set all the desired admin responsibilities and all common profile options for a given FND_USER.
Salient features of this simple script are
1. If a user is inactive, that FND_USER will be re-activated
2. If any of their Sysadmin or WF Admin or Application Developer or Functional Admin responsibilities are inactive, those responsibilities will be re-activated
3. Add commonly used responsibilities will be assigned to the user
3. Personalization, Diagnostic and Utilities profile options will be assigned to this user.
4. Password expiration will be removed from the FND_USER
Read more...
Web ADI and Reports Manager Video Demo
Sunday, 19 October 2008 10:16
Anil Passi
Oracle have published some very good audio-video demonstrations on Web ADI and Reports Manager.
These videos explain the concepts and also have working demonstrations.
Read more...
Extend View Object to Add new Field In OA Framework
Saturday, 18 October 2008 16:38
Anil Passi
In this article you will learn from a working example, how to extend view object in OA Framework to add a new field to standard page.
This article will also teach you how this extension can be tested from both jDeveloper and also how this can be deployed to eBusiness Suite.
In the iProcurement shopping home page, we need to add Supplier Number field in the “My Requisitions” region.
My requisition region primarily displays the data from PO_REQUISITION_HEADERS_ALL Table.
However it is the table po_requisition_lines_all that contains the vendor id.
Executing SQL Queries from Extended Controller
Saturday, 18 October 2008 20:46
Anil Passi
It is not recommended to use JDBC Connections from within Controllers.
However, sometimes from within our extended controllers, we have a need to fire some SQL Statements.
You have various options to achieve this, and these are discussed with code samples in this article below.
Read more...
Generating Recruitment Letters using Web ADI
Tuesday, 07 October 2008 00:00
Sanjay Singh
Web ADI can be used to generate mail merge letters from the Request Recruitment Letter window in Oracle HRMS which associates a letter with an applicant assignment status, or
Letter Request form in Oracle Learning Management which uses enrollment status. The first step is to identify the information required from database and create a view
to retrieve data for the letter to be downloaded to Word.
The view must join with the PER_LETTER_REQUEST_LINES table, and
must include the column LETTER_REQUEST_ID. For example,
Read more...
Schedule Email Notification using BPEL - Part II
Wednesday, 17 September 2008 15:06
Kishore Ryali
This article is continuation of Part I of Scheduling Email notifications using BPEL. In the earlier article, I created a bpel process which uses  email activity and manually invoked the bpel process from BPEL Console to send email notification. Now I will improvise it by scheduling the bpel process without manual intervention.
Scheduling a bpel process can be done in many ways and few of them are:
- Use a life-time running bpel process whose only purpose is invoke other bpel processes. It can be implemented by using WHILE, WAIT and INVOKE activities.
- Use Java Timer (Scheduled bean in a container) or Quartz Scheduler to create Cron type schedules for bpel processes.
- Use DBMS_SCHEDULER Oracle 10g functionality. BPEL Designer has many predefined event listener activities like File Adapter, FTP Adapter, Database Adapter which constantly watches for any event to happen. You can use one of those activities to trigger bpel process when DBMS_SCHEDULER say creates a file in a location, insert a record in table etc.
Read more...
Schedule Email Notification using Oracle BPEL - Part 1
Tuesday, 16 September 2008 00:07
Kishore Ryali
Email notifications are widely used in Oracle Applications for FYI or Action notifications. They can be achieved in many ways using Workflow, PL/SQL, host file etc. As we are all getting geared up for Fusion Middleware, I wanted to explore the option of using BPEL process. In my article, I will create a bpel process which it scheduled to send email notifications say every 30 min. For simplicity I will do this in two steps which are covered in two articles. 1. Create a bpel process which sends email notification. 2. Schedule the above bpel process to run every 30 min. This article covers the sending emails using BPEL process. Before I go into the steps of implementing email notification, I will brief you about the environment I'm using for this article.
BI Publisher Report Migration Utility
Tuesday, 09 September 2008 20:35
Kishore Ryali
Oracle BI Publisher provides a utility for converting reports from RDF reports to BI Publisher reports using RTF templates. This utility can come really handy in migration projects involving large number of oracle reports. Though this process greatly reduces time and effort, all the migrated reports have to be code reviewed to ensure there is no buggy generated code. I will discuss at the end of the article of the scenarios where that can happen. In Oracle Reports, the data model (SQL query or extraction logic) and layout are contained in a single file. In Oracle BI Publisher the data model and the layout are separate objects, which is a major feature of XML Publisher architecture. It gives a flexible to use the same data model and generate multiple presentations using templates. The conversion utility generates several files that will make up your report in Oracle BI Publisher. In most cases this will include a PL/SQL specification and body that you will need to create in the database that contains the report trigger code. The utility will also generate a report definition file and a layout template file that you will upload to the Oracle BI Publisher repository.
Matrix Report in BI Publisher
Tuesday, 09 September 2008 00:33
Kishore Ryali
Cross-Tab/Matrix Feature in XML Publisher A matrix (crosstab) report contains one row of labels, one column of labels, and information in a grid format that is related to the row and column labels. In other words, a matrix report displays the data in a grid. A distinguishing feature of matrix reports is that the number of columns is not known until the data is fetched from the database.
A simple matrix report might look like the one below, where the jobs are fetched dynamically for the first row and the departments are fetched dynamically for the first column. The salaries of the employees with the job in a particular department are places along the grid. The aggregate totals are displayed in the last row and last column.
Read more...
ESB BPEL Using Oracle SOA Suite -Article III
Monday, 08 September 2008 08:52
Prasad Bhogle
File And FTP AdaptersIn this article we will discuss various aspects and features of File Adapers and FTP Adapters. These adapters are mostly used in projects which deal with data transfer activities like interfacing with legacy systems. File and FTP Adapters
Read more...
Oracle HRMS Data Migration Scripts Collection
Sunday, 07 September 2008 13:14
Anil Passi
On http://apps2fusion.com/forums, you will find several data migration scripts for Oracle HRMS and Payroll. Please find the link below that gives you listing of these HRMS and Payroll data migration scripts.
Read more...
|
|
|
|
|
|
|
Page 1 of 10 |
