Feed aggregator

Payables Hold Release Workflow

Krishanu Bose - Fri, 2011-04-29 01:12
In R12 Oracle Payables integrates with Oracle Workflow to provide a resolution of user releasable holds through workflow. A new transaction type called “Payables Hold Resolution” (APHLD) in AME has been introduced in R12 for the same. There has been a business requirement to release the AP invoice holds, especially the matching holds based on an approval mechanism. In R12 of Payables, this feature has been provided so that, we can send the invoice lines on hold to approvers before the hold is released. As usual the seeded AME objects can be extended to accommodate different approval groups, rules and other business conditions before the hold is released.

Following setup needs to be done at Payables level: Setup > Invoice > Hold and Release Names.

The Initiate Workflow option is selected for the hold type in the Hold and Release Names window.

The hold is setup to be user releasable

Notify After X Days: The Notify After X days setup, will cause the notification to be sent to the approver after X days of the hold being placed.

Remind After X Days: The Remind after X days will cause a reminder to be sent to the appover after X days of the first notification, and subsequently, if no action is taken.

At AME setup Level, for the Transaction Type: Payables Holds Resolution setup Attribute, Condition, Action types, Approver groups and Rules

1. Choose the Default/seeded Attribute existed for Hold Look Up Code as shown below

2. E.g. Use the seeded Condition by assigning Hold Look Up Code with String values “Amt Ord, Amt Rec, Price, Qty Ord, Qty Rec” as below: 3. Create an Custom Approver group ‘Demo1’ by choosing “Serial” Voting method assign with Static to generate Invoice Hold notifications and send for release to approvers on basis of below logic 4 Assign this Approval group to the action type.
Create a Rule for this Hold notification and assign above Condition and Action type to the Rule as shown below:

Steps to Release the Hold:

1. Validate invoice on matching hold like “Amt Ord, Amt Rec, Price, Qty Ord, Qty Rec”

2. A notification will be sent to the approver for hold release

3. Once the Approver clicks on “Release Hold”, the hold gets released from the invoice.

Time Spent, Time Wasted

Jeff Hunter - Thu, 2011-04-28 17:11
Sometimes tuning a database can be rewarding.  I get great satisfaction when helping a user take their query from 10 minutes down to 3 seconds.  But it doesn't always work that way.  Consider this recent exchange: Developer to DBA Manager: The database is slow. DBA Manager to DBA: Trace his process. The DBA traces the developer's process and comes up with about 12 queries that can benefit from

Is Local Optimization kicking in your WS Binding?

Ramkumar Menon - Thu, 2011-04-28 09:12

As we know, WS bindings are local-optimized as long as the Server URL configuration for your soa-infra matches your invoked endpoint. To check if local optimization is actually kicking in, you can wither
a) Chek your HTTP access log to see if calls are going over HTTP.
b) Set the the logger for oracle.integration.platform.blocks.soap.WebServiceExternalBindingComponent to FINE (TRACE:32). If local optimization is kicking in, you should be able to see logging messages such as "Invoking service request locally..." in your log files.

Is Local Optimization kicking in your WS Binding?

Ramkumar Menon - Thu, 2011-04-28 09:12

As we know, WS bindings are local-optimized as long as the Server URL configuration for your soa-infra matches your invoked endpoint. To check if local optimization is actually kicking in, you can wither
a) Chek your HTTP access log to see if calls are going over HTTP.
b) Set the the logger for oracle.integration.platform.blocks.soap.WebServiceExternalBindingComponent to FINE (TRACE:32). If local optimization is kicking in, you should be able to see logging messages such as "Invoking service request locally..." in your log files.

After all these years I've finally got

Susan Duncan - Tue, 2011-04-26 07:30
After all these years I've finally got my first major article published in the ODTUG Technical Journal. I'm really excited as it's about Database Design Using JDeveloper - from Logical to Physical modeling and more. This is not a topic that normally attracts that much attention outside of those of us who know all about its merits so I'm especially happy.
And just like buses, you wait ages for one and then two come at once (if you're outside the UK this might not mean much to you!) I'm now writing a second deep dive into JDeveloper's Logical modeling, and some fantastic new features that are coming your way, for the next quarterly issue due out around the time of Kaleidoscope, the ODTUG conference. Unfortunately I am not able to attend this year, but if you happen to be Long Beach Way in June - you should try and make it.

MOS Workshop: Fixing SRs

Charles Schultz - Mon, 2011-04-25 11:42
So I am heading to Oracle the first week of May (May 2-4) to talk about improving MOS, specifically the SR creation process.

I have two similar previous posts on this topic:

The agenda is:

The Service Request process is undergoing a redesign and a specific customer intensive feedback type session called “The Bridge” is being used to evaluate changes to the design. This process works over a 3 day period with two customers, the business owner, a lead developer, a designer and two facilitors to help the structured process to move forward.

The results are extensive requirements and user interfaces which are tested and approved during these sessions by development, customers, and business owners. This process works because the customers are in the room.

I ask for your help because I am but one person. I have filed a goodly number of SRs, ranging from the stupid to the complex, so I feel comfortable in that I can represent my own thoughts in what I would like to see improved. And I'll detail those ideas below. But if there are other pressing matters that I miss, please speak up! :)

Overall, I want the SR creation process to be easier on me, the client. I see the merit of Configurations and suppling an extra level of detail to the SR Analyst, and I see how the OCM intends to make the collection of such configurations mostly transparent. But above and beyond what is best for the analyst, I want to have a satisfying and confident SR creation experience.

Currently, it takes a minimum of 17 steps (skipping all optional steps) in both the Flash and HTML versions to get to the point of hitting the "Create SR" button (different steps to be sure, but they amount to the same thing). Some of the steps are completely redundant, some are nonsense. I would contend that 95% of those steps can be deferred until after the SR is created - basically, you just need the SR to end up in the right Support group. A note about the OCM - In the HTML version, I found that it was faster (according to the wall clock) to not use the OCM because the pop-up window to choose the system/host can take a long time to churn through the available systems (at least for us). The Flash version is a bit smarter and fills-in as you type, which is perhaps one of the best things about the Flash version.

What information does Oracle need at an absolute minimum to file the SR with the right group? Well, for starters, how about displaying all the possible groups? Currently (in both the HTML and Flash versions), the LOV (list of Values) that populate the "Problem" drop-down menu are determined by the Product that is chosen. Personally, I would prefer to pick an area of Support to send my SR to, instead of having to wade through various menus that play out like a "choose your own adventure" story.

Once the proper group within Support is selected, I want a "File it NOW!" button. All the other information can be entered after the SR is filed. I would even be ok with Oracle spitting out a message like "the analyst is going to ask a lot of questions unless you can provide more details". This makes sense. If all you have done is quickly file an SR without providing the product, version and some details of the problem, what is the analyst supposed to do? Practice ESP?

Next, I want the ability to fill in information that is pertinent to my case. If I use the a configuration, I want a list of configurations that gives priority to usage such that those configs that I use more often would percolate to the top. Same with the product and versions. I want the whole operation geared around getting it done as fast as possible. I want it all to be saved as I go so that if my connection is lost or I timeout (emergency meeting with the boss), I want to be able to slide back into it where I left off with no hassles.

In terms of "Related Knowledge" or other relevant documents, I do not mind if Oracle wants to spin extra cycles looking and filtering for possible metalink docs that might help me out. Just do not be obnoxious about it. Run the search in the background and populate a sidebar that I can click on at my convenience. In fact, I would want all related docs to be here, including any others that the analyst might find and possible bugs.

I want my SR to be filed with an analyst who shares my working hours. I prefer they speak my language proficiently, but initially and more importantly, I want to know that when I am at work, so is my analyst. I want the option of specifying different work hours. There has been a bit of talk about indicating the skill level of the DBA filing the SR so as to get a competent analyst, and this idea has been shot down with good reason. Rather, I want Oracle to provide top quality analysts from the get-go. If you have a newbie who is taking the SR, fine, but make sure there is some oversight from an escalation manager right off the bat. I do not want to escalate the SR simply because I am smarter than the analyst.

Lastly, I want my experience to be completely independent of my browser choice. I realize this is a huge obstacle as HTML "standards" are not standard at all.

Here are some things that Oracle is doing well, and I want the basic functionality to be retained. In both the HTML and Flash versions, there is an attachment link where you can view uploaded files. I like how the Flash version allows you to map a system after filing the SR. Although, I do not like how you have to change other parameters as well just to make that stick. I like how entries in the SR can be filtered and/or sorted. I like the concept of the OCM (as mentioned previously) - I think there is still untapped potential there. I like how the Flash version allows one to navigate the various sections of the SR creation process (the HTML version only has a "back" and a "next" button). Pre-filled values - the more the merrier.

I am toying with the idea of generating a step-by-step example of my concerns. I have already down two recorded webX sessions with Oracle about this, and it would be simpler just to make those public. :) But I did not record them, Oracle did.

Renaissance of Programming Languages

Venkat Viswa - Wed, 2011-04-20 22:42
Really good talk by Venkat Subramaniam on Progamming language Renaissance.

Some of the key points

* We are in the middle of programming language renaissance
* Nice analogy between history and Progamming Languages

MOS Mashup: the summary or the saga?

Charles Schultz - Wed, 2011-04-20 15:18
Jonathan Lewis started a small conversation; what I gleaned from that thread is he and Tanel (and other experts?) mainly use MOS for "bug hunting" and looking up specific documents. Not so much for filing SRs. Therefore their comments revolved around the utility of the site in that context. However, the general consensus is that they do not use the Flash version, only the HTML version.

Lots of threads on oracle-l - I'll provide the first thread from the freelists and let you read through it if you like.

Robert Freeman "Do you ask the question: How do I work with Oracle Support....?":
Lots of varied comments here, great for "mining" what users are expecting. If I have a ton of free time, I would love to go through and categorize what I find here more thoroughly. In summary, 1 overtly positive comment, 12 negative and 11 on the fence (both good and bad). This thread was mostly about the analysts and not MOS, per se, but a few comments did tickle MOS (negative).

Jared Still "Just my opinion - the move of MOS to Flash is still a bunch of crap":
14 negative comments and 2 "neutral" - I did not find a single person who absolutely loved Flash, let alone MOS. In fact, the majority seem to feel that Flash is REALLY BAD(tm) and the HTML version is passable. General sense that the design was driven from top-heavy management structure, not from collected opinions of the user-base. A little progress seen on fixing bugs, but not nearly enough. MOS still excruciatingly slow.

Yon Huang "Anything Flash MOS can do HTML MOS cannot?":
A number of browser differences ("you got an error in XXXX broswer, try the YYYY browser"). Some comments about how Flash was initially better at creating SRs, but now it seems the HTML version is more robust. With the possible exception of annoying timeouts. As if it would take an hour to file an SR, say it ain't so!!!

Andrew Kerber "more MOS pain":
I think the initial issue might not have been the interface (MOS) itself, but more about how some documents are not published ("unpublished"). I agree, I also find this practice highly annoying. If I cannot see, don't mention it.

Don Granaman "Obtuse errors at MOS":
I also have seen a number of these errors, even recently. This can be generalized into a category of the "Unexplainable", strange messages that pop up for no apparent reason with no apparent solution path. Or like when the entire GUI is in Japanese.

Amit Bansal "Problems with MOS":
Browser and performance issues.

Jon Crisler "Metalink fiasco":
This long strand of messages wandered all over the place and I could not bring myself to read all of them. There are some good efforts to point to specific problems and possible solutions. I am dearly hoping that someone categorized that already.... you know, reinventing the wheel and all. :)

There is a ton more on oracle-l - what I have above only scratches the surface. Not to mention the proliferation of myriad blogs. But two I do want to mention are from the folks at Oracle who have started a couple blogs which have garnered their own collection of colorful ideas.

Chris Warticki's "Support":
I actually took it as a good sign when Oracle briefly pulled the plug on Chris after a noticeably contentious article. Chris knows there are issues with the GUI and Support in general, and he tries really hard to put a positive spin on all of it. Its just that there is only so much positive spin one can put on.... anyway, many of the folks who commented on the oracle-l articles are active here as well.

Support Portal - maintained by members of the Dev team:
I have had a lot of great conversations with Richard Miller, and I am glad he started blogging a bit more. As I blogged about earlier (a long time ago it seems), they have been doing a great job of collecting feedback and Richard did write a series of posts (1, 2, 3) about that collection process. Good stuff. The only major downside is... what did they actually do with all that awesome feedback? How is MOS better for it? *pause* I do not hear anyone singing the praises of MOS.

Whew.... that is a lot of stuff. Here is my Very Basic, Gross Summary(tm).
Customers want the online Support Site to be very fast and they want it to work. They do not want to see silly little nonsense messages. They do not want to jump through hoops and tie themselves in knots to do basic things. Customers want to talk with and interact with humans. Not monkeys reading scripts. Not a cumbersome website. Customers want a powerful search utility that helps them find documents and information quickly. Lastly, customers expect that when they are asked for their feedback, something will magically happen. When nothing happens, the pool of that feedback can quickly turn sour and/or dry.

Day 1 Last session : Javascript powerful language out there

Venkat Viswa - Wed, 2011-04-20 06:50
Last session of the day by Venkat on the power of Javascript


Feels like Java & C
Similar to perl in some ways
Untyped Language


1) Case sensitive
2) goo idea to use ;
3) commenting style is same as Java/C++
4) null and undefined are used to indicated null
5) Strings are single or doule quotes and are immutable

Functional in nature : Functions are first class citizens

Pass and return functions. Everything should be object oriented is a wrong notion.

Variables are typeless. but you need to declare variables with var

Global and local scoping for variables. No block level.

Control structures are like C : statements, expressions, for loops

var sayHello = function(name) {

sayHello is now a handle to a function.Its powerful since, you can now register them as event handlers.

IN Javascript everything is an expression. there is no statement as such.

Functions are Objects

function Car(year) {

var myCar = new Car(2011);

print (myCar.year);

myCar is an instance of Car.

Encapsulation is not really about security. Its for code maintainence.

prototype is like a backpack. Any method not defined on object is routed to prototype.

Car.prototype.drive = function(dist) {
this.miles += dist;
Car.prototype.tune = function() {print ('tune')};

print (myCar["year"]); --> you can use this instead of dot notation. You can dynamically recieve the parameter since its in a double quote.

Object is nothing but a collection (property holder).
It can be a function, object or a collection of properties

for (var prop in myCar.__proto__) {
print(prop + '\n');

Inheritance in Javascript

Composition is better than Inheritance. Ruby and Groovy have delegation (@delegate).

Javascript supports inheritance through method composition.

function Base() {

function Dervied() {

Derived.prototype = new Base();

Code Quality

jslint is a nice tool to check code quality.

You need to separate the logic from HTML page.

Overall it was an amazing session with good insights on JS

GIDS Session 6- Microformats and semantic web

Venkat Viswa - Wed, 2011-04-20 06:04
Scott Davis on Microformats for the web.

He explains the significance of metadata.

meta name="description" content=""

meta name="keywords" content=""

SEO : Search Engine optimization

RDFa : Microformats http://rdfa.info

Sites like flickr , facebook are using RDFa



Article on How Best Buy is using the Semantic Web.

Tools on Semantic Web
GoodRelations Annotator tool
Semantics Radar


e.g. hcalendar,hcard

Mircoformats made Simple.


Social Graph API : Google code

Microformats are not meant to replace webservices. They are meant to augument them.

Session 5 : JQuery at work

Venkat Viswa - Wed, 2011-04-20 04:53
Tom Marrs is giving a session on JQuery at work.

How to get started with JQuery :

JQuery/Javascript Basics --> AJAX --> JQUERY UI --> Jquery Plugins

3 layers of web --> Behaviour (Javascript), Presentation (CSS), Content (HTML)

http://www.sitepoint.com/ : WebDesign for developers.

Some Caveats :
1) Javascript should be unobtrusive
2) Prefer External Styles
3) Just enough CSS --> Tag , Class & ID selectors, Descendent/combination selectors

Demos on javascript with Java and Javascript.

How to iterate, How to navigate the dom, utility methods.

Ajax : $.ajax

JSON : Lightweight $.getJSON

JQuery Widgets : DatePicker, Accordion, Tabs, Dialog Box, Auto complete,Tool tip, JGrowl

GIDS Award ceremony

Venkat Viswa - Wed, 2011-04-20 03:43

Best .NET productivity tool : Code rush

Best Collobaration tool : Adobe acrobat connecct

Best Content Management and Document Managment tool :Microsoft sharepoint 2010

Best Modeling tool : IBM Rational rose

Change and Configuration Management : Telerik

Testing category : Junit testing framework.

Security Category : Microsoft security essentials.

Web Development : Adobe Flash Platform

Mobile development : Nokia symbian platform

Frameworks : .NET framework

Databases : Dev Express Analytics

Session 4 : HOw to create a beautiful web

Venkat Viswa - Wed, 2011-04-20 03:22
Harish Vaidyanathan from MIcrosoft is giving a quick session on HTML 5, IE 9.

Demo on Native HTML 5

Installing websites as applications. If you have IE 9 installed, you can PIN applications.

Graphical capabilities in IE 9

Browser scales across multiple cores.

All of graphics is offloaded to GPU. Leverage native capabilities in IE. the aquarium demo rocked in IE9 whereas it sucked in chrome.

There is also another fishbowl demo where IE9 wins hands down against Chrome.

IE 9 Patterns


Microsoft is also annoucing an early look at Internet Explorer 10 (IE 10). It moves the web forward by being 100% compatible with Html 5. and supports css gradients, multi column Layout , ECMA script 5 .

ie6countdown.com : Microsoft website to initiate people to move away from IE 6. If people come to your website from IE6, send a message to them buy copying the piece of code.

Good to know that Microsoft too is joining the HTML5 bandawagon.

HTML 5 Deep dive

Venkat Viswa - Wed, 2011-04-20 01:54

Venkat subramaniam is giving a deep dive into HTML 5 features.

Presenatation is a todo list in textmate instead of a presentation, which is quite cool.

New HTML 5 tags like section,article,aside,header,footer

CSS 3 Pseudo- classes
nth-of-type(even) and nth-of-type(odd) are new things for changing background for alternate colours.

last-child is special for last row. can be applied for tr and td.

No more classes through each element

Targeted input types
email : input type=email
placeholders :get a clue for placeholders in grayed out manner
autofocus : set focus on field
turning off autocomplete
range min 1 max 10 value
date , datetime,color

Inplace editing : contenteditable

border-radius:10px; ( oval box)

moz-tranform,webkit-transform,transform --> for rotating sections : rotate(degree)




Audio and video

Client side data
localStorage is par of window object. its part of a hashMap.
local storage,session
offline web apps

GIDS Session 3 - HTML 5

Venkat Viswa - Wed, 2011-04-20 00:34

Scott Davis : I really loved his sessions last year. He is a real expert on Grails. He has a website on thirstyhead.com.

Starts of with a quip on his new shirt.

HTML 5 enhancements

1) Form enhancements, mobile support

Biggest new feature. --> Semantics over markup. Currently pages are cluttered with Divs currently. You can provide separate tags for various page sections like nav, header , footer and sections.

Screen readers can parse the code and act accordingly.

Desktop Browser support for HTML 5
Google already uses HTML 5 and provides outstanding support in their chrome browser.
Apple Safari already supports HTML 5
Mozilla Firefox and Opera supports HTML 5 as well.

IE 9 supports HTML 5 specification even though its not available on windows xp.

Good that everyone is now meeting the specifications.

Support for Mobile in HTML 5

All applications are HTML 5 with a thin app wrapper like NYTImes. Javascript is the write once run anyware platform finally :).

RIM Playbook has outstanding HTML 5 support.

Cost to implement technology is very high initially, and the value is very low. Dont wait for final standard. You need to wait for Oreilly book on that technology then its here to be used :)

HTML 5 is here to stay and start now instead of waiting .

http://diveintohtml5.org by Mark Pilgrim . Entirely free online book.

New Elements

Doctype is amazingly simple :

New semantic elements: header, nav, footer,section, article, aside.

HTML 5 Reset Stylesheet : Include all these to use display:block;


Form Enhancements

INput elements support following new values : tel,search, url, email, dateime, date, month, week, time, email .

Any browser that doesnt support the new values, will present a text instead. this is true only for desktop browsers. But mobile browses have issues.

Checks for html features support. New idea is to program to the most mordern browser and pollyfill for the others using Modernizr.

Mobile support : Smart phones and Tablets are selling really fast.


App Cache : explicitly cache js, css, images.

Cache Manifest can explicity cache resources.

Cache,Network and fallback sections.

typical application could be an twitter client in html5 that can switch between online and offline mode. Full control of the cache through javascript.

Data Storage : Allows you to storage as a hashmap.Upto 5 MB of local storage is available per domain per url.

Web SQL database : supported by all browsers except firefox and IE.

Video support

Youtube html5 video player. Use video with object tags combination.

Some more websites to checkout :

ON the whole it was an awesome session , that really opened up the world of HTML 5.

HTML 5 Cross browser Polyfills is the way to go

GIDS Session 2 : Demo on Blackberry playbook

Venkat Viswa - Wed, 2011-04-20 00:11

Next up is a session on playbook that was launched in US yesterday

What is a Tablet?

Combines best of both worlds : smartphone and Laptop

Features of Blackberry playbook

features are amazing : dual core 1ghz processor , 7 inch touch screen , front and rear cameras.

multitasking --> this is not currently possible in ipad

full support for adobe flash sites.

support for HTML 5


ultra convenient and less than a pound

sales force integration

lots of enterprise features : securely pair Blackberry, document viewing and editing over 2000 apps available.

Developing for playbook

Browser : Flash 10.x + html5

RIA : Adobe AIR + blackberry web works


GIDS Session 2 : Demo on Blackberry playbook

Venkat Viswa - Wed, 2011-04-20 00:11
Next up is a session on playbook that was launched in US yesterday

What is a Tablet?

Combines best of both worlds : smartphone and Laptop

Features of Blackberry playbook

features are amazing : dual core 1ghz processor , 7 inch touch screen , front and rear cameras.

multitasking --> this is not currently possible in ipad

full support for adobe flash sites.

support for HTML 5


ultra convenient and less than a pound

sales force integration

lots of enterprise features : securely pair Blackberry, document viewing and editing over 2000 apps available.

Developing for playbook

Browser : Flash 10.x + html5

RIA : Adobe AIR + blackberry web works


GIDS 2011 - .Web day Session 1

Venkat Viswa - Tue, 2011-04-19 23:03

Arijit Chatterjee from Adobe is giving an excellent session on Building Next Generation of Experiences.

His presentation is full of interesting images. I like the fact that there is less content in the presentation and more of verbal communication.

The main message behind the presentation is to how to make the user experience better - Understand your users, how to make beautiful websites, understanding local sentiments and speaking in local language.

Some key things to keep in mind

1) Build trust
2) Maintain Focus on workflows --> move from one task to another
Create in context help - if necesary
3) Involve all Senses - the more sensory organs are involved, the more you will be able to retain users.
for web app Visual,Touch,Sound are the key .

4) do not build something Jazzy - it might drive people away from your site

5) Acknowledge Status clearly once you are done with something irrespective of Victory or Failure.

6) 3 D display wherever relavant

7) Use sound - Judiciously

8) use of high definition haptics

Wrapping up with a few stunning images . Aquarium Sink, Bubble Cosmos , Interactive multi modal workspace.

Heading out to talk to MOS Devs in May

Charles Schultz - Tue, 2011-04-19 15:17
I have been invited to a workshop to talk about enhancements to MOS. I am dearly hoping to collect and possibly organize feedback from the user community in general. So here is what I am looking for:
1) What do you like about MOS? Ie, the things you do not want to see changed.
2) What do you not like about MOS? The more specific the better, and bonus points for suggesting an alternative.

I'll be compiling my own list in the next few days. I realize many user communities have tossed this topic around ad nauseum, so this little effort is mostly my feeble way to gather all that wonderful feedback into a small concise package that can be communicated in a very clear and distinct manner.

The curse of the cursor

Tony Andrews - Tue, 2011-04-19 04:58
For some reason, many Oracle developers avoid SELECT INTO as if it were dangerous, preferring to "have more control" over their code by using cursors for everything. This morning I spent over an hour debugging some code written by one such developer, only to find that the issue I was trying to fix was one that would have been caught by the original developer immediately had he used SELECT Tony Andrewshttp://www.blogger.com/profile/16750945985361011515noreply@blogger.com1http://tonyandrews.blogspot.com/2011/04/curse-of-cursor.html


Subscribe to Oracle FAQ aggregator