Professional Buyer Work Center is an interactive web based interface added in Release 12. It brings Requisitions, Orders, Sourcing, Procurement Contracts, Deliverables and Suppliers together in one stop shop for buyers and now users need not to shell out to different forms to access these functional areas. Additionally, Oracle has provided a powerful search mechanism (along with seeded search queries) to query as well as save result sets as per individual's own requirements like Column totaling, sorting, renaming etc. This new tool provides increased throughput derived from a higher degree of functional integration and information availability.

The pdf in link as shown below explains this functionality in detail

In this article, you will find a powerpoint presentation that depicts the step by step approach to call a webservice from pl/sql

The presentation can be downloaded using the link as shown below

Calling webservice from PL/SQL

 

 

There is a beauty of an FND API that resides in the apps schema to convert a string into DATE. This API can take a string value in various formats and convert them into Oracle Date. Many times we have to parse a piece of plain text and convert that to date. This is very true when it comes to converting date values from flat file into a proper date column. In this article we will convert a date value from various possible string formats into a "Date Value".

 

Why use the FND API ?
For example, if you run these SQLs, you can get the following error if you do not explicitly specify the format of the date in to_date

SQL> select to_date( '21-12-2009') as date_value from dual ;
ORA-01843: not a valid month

For example, if you run this SQL, you can get the following error
SQL> select to_date( '21-12-09') as date_value from dual ;
ORA-01843: not a valid month
 

SQL> select to_date( '2009/12/21') as date_value from dual ;
ORA-01861: literal does not match format string
 

Now lets try these with fnd_conc_date.string_to_date

Oracle Apps professionals that are experienced are called "experienced" because they usually have a variety of ideas up their sleeves when it comes to troubleshooting an issue or when designing a solution/extension. Some of their ideas are self invented and some are inspired from others. In my case, a substantial part of experience that I gained is by inspiration from the ideas that are perhaps not mine. The source of those ideas is not a single individual but the Oracle eBusiness suite product code base itself.

Many times we reverse engineer the code in Oracle Apps when troubleshooting an issue or in an attempt to gain in-depth knowledge of the inner working of a module/functionality. In the event of doing so, we unearth the design methodologies implemented by the specific programmer in Oracle product development team. With time we learn that each product development team in Oracle Apps has their own unique style and mindset that is reflected in the design approach of respective module. Being consultant, we are able to grasp the ideas from various design/methodologies of thousands of Oracle product development team members. These tricks/ideas then inspire us when it comes to developing our own extensions. Of course the beauty of being a consultant is that we are able to cherry pick the ideas from the product, those ideas which are elegant from our perspective.

Anyways, coming back to the point, this article is about another one of those ideas that was inspired by Oracle product itself. Let us say your requirement is that when certain event occurs, you then wish to raise yet another event that executes at a specific point in time/hour/minute in future.

Learning from failed ERP Implementations

While Enterprise Systems have the potential to offer benefits beyond Traditional legacy systems, many organizations report that these have been less successful than originally anticipated. The difficulties of successfully implplementing Enterprise system implementation & it’s dependence on critical success factors is what we are attempting to find out in this paper.

At the outset it’s apparent that Enterprise Systems are perceived as more effective and efficient ways of business processes by means of pre-engineered packaged software application, the stated goals of adopting Enterprise Systems are to obtain organizational benefits such as lower inventory costs and shorter cycle times Thus, Enterprise Systems tend to impose a specific logic of doing business, which is particularly shaped by the "best practices" By adopting a process orientation and consequently integrating it with the system Business ‘Hope’ that it would work. Too often, project managers focus on the technical and Financial aspects of a project and neglect to take into account the non-technical issues the ‘Critical Success factors’ & also the interrelationships leading to project success or failure. Overall problem is to understand why even best of breed ERP implementations fail, despite of best minds & best planners spending years to implement the state of the art systems at various businesses.
So the question remains…..

In this article, you will find an audio video demo that shows the integration testing of Self Service HRMS Part 1 to Part 7. Effectively in this demonstration you will see the end result of the solution that we designed in Part 1 of this series.

Oracle provides a wonderful utility for testing your AME. This is called AME Test Workbench.

What is AME Test Workbench?
This is a screen using which you can simulate the calls to AME engine by passing some parameters. For example, Self Service HRMS passes transaction_id from hr_api_transactions to the AME. In this article, you will see an audio video demo that explains how you can use the test workbench in AME for testing and debugging your AME customizations. For this specific example, we will be using transaction_id of Self Service HRMS to simulate an AME call from the AME test workbench.

 

Finally the book is shipping from amazon.com website priced at USD 37/-
Read more...