Blog Aggregator

Step by Step : ‘AuditTrail’

OracleApps Epicenter - 6 min 24 sec ago
Previous Post: Are seeking auditing ability in EBS…use ‘AuditTrail’ Steps by step: Enabling audit trial As per the below example the ‘Define An application user’ is a user table name for FND_USER,the same steps you can follow for your own tables.
Categories: APPS Blogs

Are seeking auditing ability in EBS…use ‘AuditTrail’

OracleApps Epicenter - 6 min 24 sec ago
What is an AuditTrail? An AuditTrail is one of functionality for retaining a history of changes to data. What ,who and when can be identified on a particular table or column if the functionality is enabled. When you enter or update data in your forms, you change the database tables underlying those forms. [...]
Categories: APPS Blogs

MOAC :”Multi-Org Preferences”

OracleApps Epicenter - 6 min 24 sec ago
MOAC allows users of a single responsibility to perform task in multiple operating units without having to switch responsibilities.Out of Box functionality of MOAC, there is something called “Multi-Org Preferences”. What is “Multi-Org Preferences”? Multi-Org Preferences allows you to control the list of operating units to which you have access. Lets say you have around 20 OU’s divided [...]
Categories: APPS Blogs

MOAC : Technical Insight

OracleApps Epicenter - 6 min 24 sec ago
As we know in R12 , the existing Multiorg architecture includes a new feature Multiple Organizations Access Control (MOAC). Lot of queries and question were asked by my readers, therefore this post completely focus on some of technical Insight because of architectural change.The minimum you should suppose to know is that Access Control feature has [...]
Categories: APPS Blogs

Oracle EBS Report Manager

OracleApps Epicenter - 6 min 24 sec ago
What is Report Manager? In Oracle EBS “report manager” is a product that has been offered to manage your reporting needs. Report Manager is basically a secure point-in-time report repository offering centralized management and distribution of reports. There are different levels of access that you can assign to reports that are generated by the Report Manager. You can [...]
Categories: APPS Blogs

Extending and managing Web ADI (Integrator Layout) - Part II

OracleApps Epicenter - 6 min 24 sec ago
This is yet another extension of previous post, will discuss how to manage and define layout of the WebADI integrator. Managing/Defining Layout You can also manage /Define layouts, means you can build the spreadsheet by modifying the Layouts. You must be in responsibility with access to the integrator to define the layout. Responsibility: Desk Integration Menu Options : [...]
Categories: APPS Blogs

Extending and managing Web ADI (Integrator) - Part I

OracleApps Epicenter - 6 min 24 sec ago
As mention in earlier post (#1,#2,#3 ) , WebAdi is tool that can be used to load many different types of data from spreadsheet based excel application into various application of Oracle APPS. There are number of Seeded Integrator comes with Oracle, but still Oracle provides the capability to its expandability. Various Integrators to [...]
Categories: APPS Blogs

R12 : Uploading a Journal using Web ADI : Step by Step

OracleApps Epicenter - 6 min 24 sec ago
In last two post we have seen , Web ADI is a Browser based application, which enables users to log into the Oracle database and upload ADI spreadsheets, without having the ADI application installed onto the users machine.We have already seen step by step setup in 11i , now this post is extension of previous [...]
Categories: APPS Blogs

11i Uploading a Journal using Web ADI : Step by Step

OracleApps Epicenter - 6 min 24 sec ago
This post will briefly Let you take quick step by step guide for uploading Journal through WebADI in 11i . Uploading a Journal using Web ADI The Web ADI screens are viewed in sequence, each one selecting an aspect of Journal to be uploaded. It start with selection of the ‘Viewer’ the Excel version to be used [...]
Categories: APPS Blogs

R12 Oracle Subledger Accounting :Oracle White Paper

OracleApps Epicenter - 6 min 24 sec ago
There is one white papers from Oracle in area R12 Oracle Subledger Accounting. This was released sometime in last year Sept 2007, seems this is updated with latest version of April 2008. The Business Benefits of Oracle Subledger Accounting An Oracle White Paper September 2007 (latest version is of April 2008 ) Subledger & General Ledger Those who are [...]
Categories: APPS Blogs

WebAdi : Desktop Integration makes life easier

OracleApps Epicenter - 1 hour 21 min ago
Lets take about one of the great office productive tool based application which is called “Web ADI” that being used within the E-Business Suite to provide end-users with a familiar user interface.Key end users are highly accepted this productive tool , because of there own advantages and great office capability. ADI & Web ADI… ADI stands [...]
Categories: APPS Blogs

Register of Interest

Antony Reynolds - 1 hour 35 min ago
Registering InterestI have been involved in some interesting discussions recently on the use of a service registry.  Oracle SOA Suite ships with a limited use license for a service registry and there is the option to upgrade it to a full use license and so the question comes up, Antony why would we want to use a registry and can we use it for all our service lookups.
Lets start by looking at what a registry is.
Glorified Yellow PagesUncharitably a registry may be described as a glorified yellow pages.  It allows artifacts such as XML schema and service WSDLs to be stored in a searchable, categorized archive.  Artifacts are stored under different categories and may have keywords associated with them to assist in searching.  So at the end of the day the registry is just a repository of meta-data about artifacts.  In the same way a car is just a large amount of beaten metal with a power unit that drives wheels.  Calling it a repository of meta-data does not actually explain what it does or how it may be used.
Registry use CasesLet me suggest a few registry use cases
  • Design Time Service Discovery
    A registry can be used to catalogue existing services and associated artifacts.  This encourages re-use by making it easier to discover existing services.  The ability to promote items between registries also makes it possible to put in place a service approval process that vets new services before making them available to developers.  This again promotes re-use and generalisation of existing services.
  • Run Time Service Discovery
    A registry can also be used at runtime to provide the physical endpoint for a service.  This makes it easy to change the physical provider of a particular service.  This also simplifies migration of services between development test and production environments as outlined in the next use case.
  • Service Migration Mechanism
    The use of multiple registries provided a managed path for services to be promoted between environments, either from a development perspective or from a runtime perspective.
Design Time ConsiderationsUse of a registry at design time is generally a good idea but it does a require a certain amount of discipline in its use otherwise it becomes yet another dumping ground for all design decisions, good and bad!  However individual develpoment team can maintain their own local registry that has a well defined promotion process to a central registry, allowing teams to work on their development services which may later be migrated to a corporate registry.  In my experience most customers are not making use of a registry even in their design time environments and this is probably the best place to start using a registry.
Run Time ConsiderationsUsing a registry in a runtime environment promises a greater degree of de-coupling.  However a similar amount of decoupling may be achieved through the use of an ESB alone.  If a registry is used to look up an ESB endpoint then there is a potential cost to be paid in terms of an additional lookup.  If an ESB endpoint is not looked up then there is the risk of coupling the data formats of unrelated services together, losing the use of an ESB to provide message transformation to/from canonical form.  Some informal tests I ran indicated that the additional overhead of a registry lookup does not add much to the service invocation, but in high volume environments it may be the straw that breaks the camels back.
A good policy may be to begin using a service registry in design time, later trying it out in non-high volume environments.  Using an ESB can make this migration to registry use easier, if less pure by having the ESB perform the registry lookup.
Using a Registry with Oracle BPEL PMThe current production release of Oracle BPEL PM has built in support for use of a registry.  Al that is required to make a service lookup occur through a registry is to perform the following.
  1. In the BPEL Console, go to the "Manage BPEL Domain" and set the following properties
    • uddiLocation - the inquiry address of the registry
    • uddiUsername - if it is a secured registry set it to a username for performing lookups, if not set it to urn:unknown
    • uddiPassword - if it is a secured registry set it to a password for performing lookups, if not set it to urn:unknown
  2. In a BPEL process for each service endpoint (partner link) that you want to go through a UDDI lookup
    • Add a property "registryServiceKey" to the partner link with the "Entity Key" value assigned in the UDDI repository
For more on potential performance impacts of registry lookup see Chintan Shahs blog entry. Note that I haven't seen such a bad degradation as he reports, but I could believe it for a complex WSDL and high system load, meaning unresponsive threading, particularly in a Windows environment.
An Example of Dynamic LookupTo give a feel for dynamic lookup I have uploaded 3 JDeveloper Projects in the this file.
  • JavaWS includes a simple Java web service (GreetingWS) that can be registered in a service registry.  When registering it in the registry you will need to note the service key and copy it into the partner link property in Dynamic BPEL.
  • DynamicBPEL is a BPEL process that looks up the web service (GreetingWS) and invokes it in three different ways
    1. Static, it uses the endpoint defined in a WSDL file
    2. Dynamic, it sets the endpoint explicitly (passed in as a parameter to the process), showing how you can be very dynamic in the endpoint you invoke.
    3. UDDI, it uses the UDDI repository to lookup the endpoint, showing how unintrusive it is on the rest of the process.
  • TestDynamic is a BPEL process that you invoke to test the DynamicBPEL process.  It iterates over all three methods and calculates how long each method takes to complete the given number of iterations.  The first invocation is not counted to allow the system to "warm up" for each call.

blog.thecheapdba.com has moved

Cheap DBA - 3 hours 4 min ago

Please visit my personal blog at blog.jameskoopmann.com.

New ActivePerl 5.10.0.1003 includes DBD::Oracle 1.21

Christopher Jones - 4 hours 21 min ago
Jan Dubois of ActiveState dropped me an email  today about the DBD::Oracle 1.21 release. He says:

"We have released ActivePerl 5.10.0.1003 today, which included the latest DBD-Oracle module for 32-bit Windows and Linux builds."

Stuff That Just Works

Oracle AppsLab - 4 hours 44 min ago

I’ve been so very busy lately, but not with bloggable activity. This week has been slow on Mix news; ENTP is putting the finishing touches on a big feature, and we did deploy a few bug fixes.

I did finally catch up on feed reading from a month ago, and a post from friend of the ‘Lab Jeff Nolan about TwitterFone caught my eye.

TwitterFone allows you to tweet by phone.

TwitterFone

After you sign up for the invite-only service and verify your phone by SMS, all you need to do is call the TwitterFone number and speak your tweet.

Presto, minutes later, out comes your tweet into your tweetstream. The voice to text is pretty good, and they add a TinyURL to your tweet pointing to the recorded version, just in case you don’t enunciate properly. Case in point is my tweet about Beer and Blog. Yes, it’s a real thing we do here in PDX.

Wow Factor
A few things jump to mind here. First off, Jeff is right about the Wow Factor. This puppy just works, exactly as advertised, no additional setup required. Reminds me of TripIt, another Wow Factor Hall of Fame member. I hear Sandy is also that way, but I’ve yet to get that configured. Also noteworthy is Jott, which I’m told has the same capabilities as TwitterFone, plus more, for happy people in the US and Canada. Again, Jott is on my short list to try.

I am enamored with services that just work, especially if they work with other services I use all the time like email and phone. Simplicity is refreshing.

Here come the groans. Yet another way to tweet. W00t! TwitterFone opens the door to all manner of tweets; the first that came to mind was tweeting my annoyance with other drivers, as I was unceremoniously cut off in traffic. That stuff matters here in Portland, where we still have driving manners.

Beyond tweeting my road rage, I can imagine practical uses for TwitterFone. For example, it allows an even faster way to report events, e.g. the recent earthquake in China, as reported by our very own Dean Tan. Word has it Twitter reported that 3 minutes before the USGS did.

I have trouble tweeting with my iPhone because typing kills the immediacy of the moment. TwitterFone removes that barrier. So you can report news or other noteworthy events faster. Maybe you see a hit and run and tweet the license number and accident location using TwitterFone. Maybe you hear on the radio they’re giving away free gas and you want to share the love with your tweeple.

TwitterFone closes that news reporting gap very nicely.

Pat Phelan (@patphelan), who generously provided me with a few invites, tells me that although TwitterFone does not currently support direct messaging and @ replies, these are planned. I can’t wait. I frequently fill up my integrated messaging inbox with voicemail reminders, which are easy to leave when I think of stuff while I’m driving. I could use Twitter for short notes, which is a much lighter weight solution.

So I’m very pleased with TwitterFone so far and plan to use it a lot, especially with a conference coming up next week. Live blogging will be much easier by voice.

All Twitter, All the Time
I blab about Twitter a lot. It’s not for everyone, but more and more people are finding real value beyond sharing horribly mundane details about their lives.

Twitter’s ecosystem and API are why it matters (via WWD). Twitter’s API allows all manner of client apps and bots to use it and even monetize it (e.g. Twhirl), when Twitter itself has no public business model. The API has led to viral spread and (possibly) unintended uses like bots (e.g. Firebot, Timer).  Bots create a command-line widget, perfect for targeted tasks and accessible from all manner of clients, thanks again to the Twitter API.

Venkataramanan S sent me an extreme example of what Twitter can do, Twitter + Bash, which I had to have explained to me (I know, shell fail).

Twitter is an essential tool for a distributed workforce too. I went to an informal tweetup yesterday, and everyone there had a flexible work environment, i.e. worked from home or from wherever. For those of us who don’t have a water cooler, Twitter serves this purpose.

Mobile New Web
TwitterFone joins Brightkite and Evernote as recent mobile New Web sites I’ve joined. Then I joined Jott, just for fun. I’m intrigued by the use of SMS commands to manipulate these web apps. I haven’t yet decided if they’ll stick for me, since I’m a bit of luddite when it comes to mobile web.

The main reason I bought an iPhone was to take Interwebs with me though, so I’m going to condition myself to use these services.

On its surface, mobile web seems like a huge are for opportunity, so I expect new apps will sprout up often.

Big thanks to Pat again for the invites, which I quickly dispatched.

Why Oracle is the most interesting technology space for EMC

Jeff Browning - 6 hours 3 min ago
I read Jason Kotsaftis's recent blog post with interest, since I too am very biased. Rather than commenting on Jason's post (everyone knows comments very seldom get read), I thought I would wade in with my own take on this... Jeff Browning

Master with Two Details on the Same Page

Shay Shmeltzer - 6 hours 9 min ago
ADF makes it very easy to create a master detail page with one drag and drop operation from the data control palette onto the page. But what if you want a master with 2 details on one page?

It's actually quite simple to achieve this - but I got asked this a couple of times last week so here goes...

All you need to do is drag the first detail over and drop it as a master->detail.

Then drag the second detail over and drop it as a table or a form - and now you have the three tables on the page and you are almost done.
But if you'll run your page now you'll find that your second detail is not refreshing when you are switching between the master records the way that your first detail does. ADF did this synchronization part automatically for the first master-detail you dropped. All you are missing is a partial page rendering setting on your second detail. See the difference between the two detail tables here:


So let's set it up - all you need to do is go to the form or table that contains your second detail and set its partialTrigger property to point to the master component. (You can look at the setting for your first detail component and copy them).

Categories: Development

Recent Changes to Oracle SE Licensing Rules: Higher Price?

Pythian Group - 7 hours 6 min ago

Recently, while answering a question, I came across what appeared to be a change to the rules for licensing Oracle Standard Edition — a change that appears to be subtle on the surface, but one that could have significant and surprising repercussions.

It was with considerable fanfare that Oracle announced, several years ago, the last major change to the licensing rules for Standard Edition — that multi-core processors would be counted as a single CPU for the purposes of licensing Standard Edition products. (For Enterprise Edition, Oracle continued to count each core as a separate “processor”, but then provided price discounts, presumably in recognition that a 2- 4- or 8-core CPU rarely provides equivalent performance to an equivalent number of single-core processors running at the same clock rate).

The revised licensing rule went like this (I have highlighted the relevant text in bold):

Processor: shall be defined as all processors where the Oracle programs are installed and/or running. Programs licensed on a processor basis may be accessed by your internal users (including agents and contractors) and by your third party users. For the purpose of counting the number of processors which require licensing for a Sun UltraSPARC T1 processor with 4, 6 or 8 cores at 1.0 gigahertz or 8 cores at 1.2 gigahertz for only those servers specified on the Sun Server Table which can be accessed at http://oracle.com/contracts , “n” cores shall be determined by multiplying the total number of cores by a factor of .25. For the purposes of counting the number of processors which require licensing for AMD and Intel multicore chips, “n” cores shall be determined by multiplying the total number of cores by a factor of .50. For the purposes of counting the number of processors which require licensing for all hardware platforms not otherwise specified in this section, a multicore chip with “n” cores shall be determined by multiplying “n” cores by a factor of .75. All cores on all multicore chips for each licensed program for each factor listed below are to be aggregated before multiplying by the appropriate factor and all fractions of a number are to be rounded up to the next whole number. When licensing Oracle programs with Standard Edition One or Standard Edition in the product name, a processor is counted equivalent to a socket.

This is exactly the definition you will find today today in Oracle’s online store, for example here.1 In fact, being lazy and not having access to a two-year-old copy of the OLSA, that is exactly where I got the text above.

Now, that little bit of bold text was a pretty big deal. As I understood it, and everybody I could find seemed to agree, this affected both the licensing cost and the eligibility rules. These 23 simple words now meant that Oracle Standard Edition was limited to computers with a maximum capacity of four (4) CPU sockets, not four processor cores. Although multi-core processors were — at the time, several years ago — relatively new, at least in the “commodity hardware” space, we all new that Intel and AMD had near-term plans for 4-core and eventually event 6- and 8-core processors. Suddenly, we could build an Oracle database server with 16 processors (cores) and 16GB of RAM or more, for less than $200,000. (Prior to this change, you would pay $640,000 — list price — just for the Enterprise Edition database licenses.)

But now, it seems, all of this is changing again, only this time, not for the better.

So what exactly has changed? (more…)

Categories: DBA Blogs

Howard's DORIS script is available again - some security comments from me

Pete Finnigan - 7 hours 35 min ago

I noticed today that Howard's Dizwell-Oracle Reliable Installation Script (DORIS) version 1.0a shell script is available again for download. This is a useful script and great for installing Oracle on Linux without resorting to reading loads of "how-to" sites. Howard....[Read More]

Posted by Pete On 16/05/08 At 07:50 PM

Categories: Security Blogs

License Plate scanners and SQL Injection

Pete Finnigan - 7 hours 35 min ago

I posted a couple of days ago a link to an almost certain hoax of a license plate of a red mini that had been altered to include SQL Injection. This was in a post titled License Plate SQL Injection....[Read More]

Posted by Pete On 15/05/08 At 09:02 PM

Categories: Security Blogs