Creating ADFbc
Sunday, 21 December 2008 17:41
OracleTech
Now that you have DB schema and JDeveloper setup, you are ready to build and test your first service layer. It will take just 10 minutest to build these objects and test them with your database, all within JDeveloper. Make sure that the DB schema created earlier you is available and has all correck PK and FK defined and enabled in DB. You can download this sample application if something goes wrong with steps.
Read more...
Introduction to ADFbc
Sunday, 21 December 2008 14:18
OracleTech
I explained ADF architecture in brief in earlier article Introduction to ADF. If you remember, service layer is at the bottom of the food chain. I also briefly talked about what is the technology ADF provides for this service layer - ADF Business Components or ADFbc. Lets understand quickly what is ADFbc, what are its major components and terminologies that you will get used to when build your service layer.
Read more...
Database Shema Modeling in JDeveloper
Sunday, 21 December 2008 11:21
OracleTech
Database schema is the first step you would take when building a web application. So, I am going to start with showing how can you do DB schema modeling in JDeveloper. Also, I will use schema created in this article for other ADFbc and ADF UI related examples to follow.
Assuming you have a DB installed that you can connect to, we will use the famous scott/tiger schema. You can also download this sample schema project.
Introduction to ADF
Sunday, 07 December 2008 17:46
OracleTech
What is ADF?The Oracle Application Development Framework (Oracle ADF) is an end-to-end application framework built on Java Platform, J2EE standards and open-source technologies. Oracle ADF and JDeveloper 11g gives you an environment that covers the full development lifecycle from design to deployment, with drag-and-drop and wizard driven development, visual UI design, and many more features built in to ease large application development.
Read more...
Welcome to ADF
Thursday, 04 December 2008 18:02
OracleTech
This is my first article in the series to follow on Oracle Application Development Framework (ADF). ADF is a new exciting technology that promises changes to the way web applications are built and the way developers think about a framework. I am posting important links below that will help you get started on ADF and understand the articles to follow.
Read more...
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...
|
|
