Environment Variables from database table - Oracle E-Business Suite

Are you running Oracle E-Business Suite (EBS) / Applications and want to get an operating system level environment variable value from a database table, for example for use in PL/SQL? Or perhaps to default a concurrent program parameter? Didn't think environment variables were stored in the database?

Try out out this query that shows you $FND_TOP:

select value
from   fnd_env_context
where  variable_name = 'FND_TOP'
and    concurrent_process_id = 
      ( select max(concurrent_process_id) from fnd_env_context );

VALUE
--------------------------------------------------------------------------------
/d01/oracle/VIS/apps/apps_st/appl/fnd/12.0.0

Or did you want to find out the Product "TOP" directories e.g the full directory path values from fnd_appl_tops under APPL_TOP?

col variable_name format a15
col value format a64
select variable_name, value
from   fnd_env_context
where  variable_name like '%\_TOP' escape '\'
and    concurrent_process_id = 
     ( select max(concurrent_process_id) from fnd_env_context )
order by 1;

VARIABLE_NAME   VALUE
--------------- ----------------------------------------------------------------
AD_TOP          /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0
AF_JRE_TOP      /d01/oracle/VIS/apps/tech_st/10.1.3/appsutil/jdk/jre
AHL_TOP         /d01/oracle/VIS/apps/apps_st/appl/ahl/12.0.0
AK_TOP          /d01/oracle/VIS/apps/apps_st/appl/ak/12.0.0
ALR_TOP         /d01/oracle/VIS/apps/apps_st/appl/alr/12.0.0
AME_TOP         /d01/oracle/VIS/apps/apps_st/appl/ame/12.0.0
AMS_TOP         /d01/oracle/VIS/apps/apps_st/appl/ams/12.0.0
AMV_TOP         /d01/oracle/VIS/apps/apps_st/appl/amv/12.0.0
AMW_TOP         /d01/oracle/VIS/apps/apps_st/appl/amw/12.0.0
APPL_TOP        /d01/oracle/VIS/apps/apps_st/appl
AP_TOP          /d01/oracle/VIS/apps/apps_st/appl/ap/12.0.0
AR_TOP          /d01/oracle/VIS/apps/apps_st/appl/ar/12.0.0
...

Or perhaps the full directory path to $APPLTMP?

select value
from   fnd_env_context
where  variable_name = 'APPLTMP'
and    concurrent_process_id = 
      ( select max(concurrent_process_id) from fnd_env_context );

VALUE
--------------------------------------------------------------------------------
/d01/oracle/VIS/inst/apps/VIS_demo/appltmp

NB: These queries assume your concurrent managers are running!

Catch ya!
Gareth
This is a post from Gareth's blog at http://garethroberts.blogspot.com

References

• Oracle Forums Thread

Update - Added example output and $APPLTMP output.

Oracle EBS Release 12.1 Released: Top 8 New ATG Features

Oracle has announced the availability of Release 12.1, plenty of buzz around on this and Beehive updates.

Update: Oracle Application Management / Change Management Pack 3.0 also released! See Patch 8333939

Let's take a look at the Top Eight R12.1 new ATG (Applications Technology) features from my perspective.

1. Out of the box Techstack Upgrades. New R12.1.1 installations are Database 11.1.0.7, Java 6, Application Server (Java/OAF)/JDeveloper Runtime 10.1.3.4, Application Server (Forms/Reports) 10.1.2.3.
2. OAF: Record History. R12.1.1 OAF allows viewing Row/Blame or Row/Who information similar to that available in Forms interface (who remembers Release 9 character mode key sequences ;-)
3. OAF: BI Publisher Integration. R12.1.1 provides a personalizable "Print" button for OAF pages. Very Nice.
4. OAF: Flexfield References support. R12.1.1 gives the same functionality as Forms UI for referencing other fields as part of flexfields.
5. Attachments APIs. Bulk upload and web services/API for Document Attachments. Sounds great!
6. Integration / SOA. A bunch of new functionality including Web Services Invocation Framework (WSIF), a step towards easier integration.
7. Diagnostics upgrades. A variety of changes/functionality to Oracle Diagnostics including BI Publisher enablement for new diagnostics. Oracle Diagnostics is an excellent source of EBS information for techie types!
8. Autoconfig: Share Applications Tier between environments. R12.1 introduces the ability to share applications executables between instances, like Production and Test. Probably not what you'd want for your typical PROD/DEV/TEST setup, but for a "Production" / "Production Support" mirror setup this is very tempting.

Plenty of other candidates, but those are the ones that took my fancy from the ATG bag of tricks!

So how am I doing against my Chinese New Year predictions?

1. Release 12.1: AVAILABLE
2. Patch 5612820 for EBS Release 11i: AVAILABLE
3. Native Excel Templates for XML / BI Publisher: Still waiting for them!
4. Further emergence of OBIA with EBS: Release 12.1.1 has specific mention of further integration with Business Intelligence Applications (OBIA), needs a closer look.
5. Change Management Pack for the eBusiness Suite: AVAILABLE: Patch 8333939.
6. New Oracle Application Express (APEX) components to allow APEX/EBS Integration/support: Still waiting, but I'm currently looking at alternatives for APEX/Apps integration for R12.x.
7. Oracle Fusion Applications: As expected delayed until at least 2010.

Disclaimer: The words, ideas and opinions here are my own. Please don't assume they represent the opinion of any other person or organization. This information is based on various sources, so it may not match the actual functionality delivered!

Related Posts

• OpenWorld 2008 Final Post: Fusion Applications, X, R12 - Change Pack & Payment Manager plus SES
• Openworld Update: XML/BI Publisher & R12, 11g PL/SQL, ADFdi and more
• R12 Patch 5612820 Available: Changing the default layout format between RTF/PDF/Excel when submitting XML / BI Publisher Concurrent Request
• Changing the default layout format from PDF to Excel using Profile Option and FNDRSRUN Form Modification - Submitting BI Publisher Report Request
• Revisited: Why is mod_plsql not supported with the Oracle eBusiness Suite Release 12? Fusion Crossroads #1

A Look Ahead to 2009 - Oracle eBusiness Suite and Happy New Year!

Gong Xi Fa Cai
Happy Chinese New Year - for January the 26th!

2008 has been and gone, and we're well into 2009. Let's look at some of potential up and coming tidbits for the Oracle eBusiness Suite.

1. Release 12.1: I was expecting this late last year, but we saw 12.0.6 instead. Release 12.1 promises to deliver a number of things, the main one for me will be a whole swag of XML / BI Publisher layouts for standard reports. A couple of Metalink oops My Oracle Support Notes indicate R12.1 is in controlled release. Haven't had a chance to track down the patch number .. anyone have it? For documentation on R12.1 see the Release Content Documentation.

2. Patch 5612820 for EBS Release 11i: This minor piece of functionality to default the Layout Format for BI Publisher based concurrent requests has been nagging me. Its out for R12, and actually its already out for R11i (9-Jan-2009) however ... the Default Layout on the XMLP side is there but the critical concurrent processing portion to default the layout on a concurrent request was missing so its back with Development. I'll keep you posted.

3. Native Excel Templates for XML / BI Publisher: This one may be subtle but for me its a biggie. Release 12 FSGs with native Excel Templates I believe are in controlled release. RTF templates have their moments, but I know a number people are looking for Excel templates. Excel and Accounting live together, and its high time they were standard for XML Publisher with eBusiness Suite. Here's hoping for more than just FSG native Excel templates.

4. Further emergence of OBIA with EBS: I've spent quite a bit of time with the Business Intelligence products lately, and the Oracle Business Intelligence Applications (OBIA) stack is a formidible beast. Albeit complex, there is plenty of sense and underlying power. I think only a handful of people have tapped into this and I'm keen to see how it plays out this year.

5. Change Management Pack for the eBusiness Suite: I'll be watching this closely too - the important parts from my perspective will be automated patching, and the ability to cut your own custom patches for applying using adpatch - nice, but of course I'm assuming you'll need front up with a few $$ too. Watch this space.

6. New Oracle Application Express (APEX) listener: Apparently due in APEX v4, the new listener will hopefully once again push APEX squarely back into the realm of the EBS after mod_plsql's support was tragically cast aside, only to resurface after clarification from Oracle :-) Any update on this David?

7. Oracle Fusion Applications: I wasn't sure whether to put this in, but I think its worth a mention. Perhaps shouldn't include it here with the emphasis on 2009 as my gut feel is that we'll be waiting a tad longer than that. However, if you've heard anything let us know!

8. What's happening for me in 2009? Well, fingers crossed I'll get stuck into a couple of projects that should have seen the light in 2008!

Do you have any hopes/requests/tidbits for Oracle eBusiness Suite action in 2009? Post a comment.

What happened in 2008?

In my neck of the woods a whole lot went on in 2008 including Website launches, Virtuate contract wins, Product demos, a GreaseMonkey Script release, attending OpenWorld for the first time, joining the NZOUG committee and helping to organize the NZOUG Conference, a new phone (Nokia E71 - nice), a new laptop (Toshiba A300 Y01 running Vista 64 ouch) and a ton more. Despite the gloomy economic outlook I'm hugely looking forward to 2009, the year of the Ox.

Disclaimer: The words, ideas and opinions here are my own. Please don't assume they represent the opinion of any other person or organization.

Related Posts

• OpenWorld 2008 Final Post: Fusion Applications, X, R12 - Change Pack & Payment Manager plus SES
• Openworld Update: XML/BI Publisher & R12, 11g PL/SQL, ADFdi and more
• R12 Patch 5612820 Available: Changing the default layout format between RTF/PDF/Excel when submitting XML / BI Publisher Concurrent Request
• Changing the default layout format from PDF to Excel using Profile Option and FNDRSRUN Form Modification - Submitting BI Publisher Report Request
• Revisited: Why is mod_plsql not supported with the Oracle eBusiness Suite Release 12? Fusion Crossroads #1
• Would the REAL Excel please stand up?!
• Enhancing the Oracle eBusiness Suite 11i/12 Homepage Menu via Firefox, Greasemonkey, XPath, Javascript & DOM: aka Foxiness Menus
• Photo Credit: Flickr: tanakawho

Discoverer Plus 10g: contact with Server lost: DiscoApplet Error DiscoNetworkException CORBA.COMM_FAILURE. ICX Territory!

An interesting one today; a Discoverer Plus Workbook called via an eBusiness Suite Menu errored out with:

OracleBI Discoverer: "Contact with the Discoverer Server has been lost. To continue your work, please restart Discoverer Plus. If this problem persists, please contact your Oracle Application Server administrator."

Doh! Who's that Application Server administrator ... oh! me :-(

Attempting to expand the workbook, after going directly into Discoverer Plus errors with:

"This workbook cannot be expanded".

 

Hmm, okay, let's look at the Java Console:

Reading bytes from input stream
   Unmarshalling response
   Session ID:2008111408252618857
   BI Beans Graph version [3.2.3.0.37]
   DiscoApplet[0]: Error received by GlobalStatusListener.workerFailed() in SessionUI.java
   DiscoNetworkException  - Nested exception: org.omg.CORBA.COMM_FAILURE:   vmcid: SUN  minor code: 208 completed: Maybe
   DiscoNetworkException  - Nested exception: org.omg.CORBA.COMM_FAILURE:   vmcid: SUN  minor code: 208 completed: Maybe
   org.omg.CORBA.COMM_FAILURE:   vmcid: SUN  minor code: 208 completed: Maybe
 at com.sun.corba.se.internal.iiop.IIOPConnection.purge_calls(IIOPConnection.java:438)
 at com.sun.corba.se.internal.iiop.ReaderThread.run(ReaderThread.java:70)
 at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(Unknown Source)
 at sun.rmi.transport.StreamRemoteCall.executeCall(Unknown Source)
 at sun.rmi.server.UnicastRef.invoke(Unknown Source)
 at oracle.disco.remote.rmi.serverbase.RMISessionBase_Stub.sendRecieveData(Unknown Source)
 at oracle.disco.model.corbaserver.ModelInterface.sendRecieveData(Unknown Source)
 at oracle.disco.model.corbaserver.ModelInterface.SendReceiveData(Unknown Source)
 at oracle.disco.model.corbaserver.serverrequest.DsrOpenWorkbook.xmlUpdateServer(Unknown Source)
 at oracle.disco.model.corbaserver.serverrequest.DsrCorbaXML.corbaUpdateServer(Unknown Source)
 at oracle.disco.model.corbaserver.serverrequest.DsrGeneralCorbaXML.updateServer(Unknown Source)
 

Ouch! Sounds like it hurts!

A quick blast through Metalink (oops MOS - My Oracle Support) and a bunch of old bugs later, not looking promising, however there's one major clue - the problem is only occurring for some Users. Okay, lets do a side by side comparison of Profile Options as a first guess:

User Level Profile Option Value Comparison Side by Side

select *
   from (
 with
 prof_di as
 ( select 'USER' level_name, 
 fu.user_name level_value, 
 fpo.profile_option_id,
 fpot.user_profile_option_name,
 fpo.profile_option_name,
 fpov.profile_option_value
 from   fnd_user fu, 
 fnd_profile_options fpo,
 fnd_profile_option_values fpov,
 fnd_profile_options_tl fpot
 where  fu.user_id = fpov.level_value
 and    fpo.profile_option_id = fpov.profile_option_id
 and    fpo.profile_option_name = fpot.profile_option_name
 and    fpot.language = 'US'
 and    fpov.level_id = 10004
 and    fu.user_name = 'SYSADMIN'
 ),
 prof_gr as
 (
 select 'USER' level_name, 
 fu.user_name level_value, 
 fpo.profile_option_id,
 fpot.user_profile_option_name,
 fpo.profile_option_name,
 fpov.profile_option_value
 from   fnd_user fu, 
 fnd_profile_options fpo,
 fnd_profile_option_values fpov,
 fnd_profile_options_tl fpot
 where  fu.user_id = fpov.level_value
 and    fpo.profile_option_id = fpov.profile_option_id
 and    fpo.profile_option_name = fpot.profile_option_name
 and    fpot.language = 'US'
 and    fpov.level_id = 10004
 and    fu.user_name = 'ROBERTSG'
 )
 select pd.profile_option_id
 ,      pd.user_profile_option_name
 ,      pd.profile_option_name
 ,      pd.profile_option_value d_value
 ,      pg.profile_option_value g_value
 ,      decode(pd.profile_option_value,pg.profile_option_value,'EQUAL','DIFF') status
 from   prof_di pd
 ,      prof_gr pg
 where  pd.profile_option_name = pg.profile_option_name (+)
 union
 select pg.profile_option_id
 ,      pg.user_profile_option_name
 ,      pg.profile_option_name
 ,      pd.profile_option_value d_value
 ,      pg.profile_option_value g_value
 ,      decode(pg.profile_option_value,pd.profile_option_value,'EQUAL','DIFF') status
 from   prof_di pd
 ,      prof_gr pg
 where  pg.profile_option_name = pd.profile_option_name (+)
 )
 where status != 'EQUAL';  

The query gets output that includes the following:

USER_PROFILE_OPTION_NAME PROFILE_OPTION_NAME D_VALUE     G_VALUE STATUS
------------------------ ------------------- ----------- ------- ------
ICX: Territory           ICX_TERRITORY       NEW ZEALAND AMERICA DIFF
 

Whenever I see anything related to "NLS_LANG" or "Territory" the alarm bells start ringing, and sure enough - for the problem User, just a quick navigate to the "Preferences" responsibility, General Preferences and change the Territory from New Zealand to United States and we're off and laughing again! Alternatively could have looked at the ICX: Territory profile option.

 

What was the real underlying problem? My guess is a clash on date formats for default parameter values ... but that's left for another day.

 

Firefox with eBusiness Suite: Oracle JInitiator Plugin does not start - always get "must install plugin", Vista, Patch 5397653

This problem has bothered me for a while in a couple of scenarios, so time for another post ... after quite an absence I must admit. I'm well over my post Conference 1 & 2 catchup now. On with the enthusiasm!

Update: Firefox 3.x is now certified with EBS. See Steven's post for details.

So you're working with your favourite Firefox 2.x, because Firefox 3 hasn't quite been certified yet. You try to fire up Oracle Applications Forms via JInitiator 1.3.x (or even 1.1.8.x) and get the dreaded "you must install the Oracle JInitiator Plugin" box.

Well, chances are one of the following quick fixes will solve your problem:

1. If you have multiple JVM's installed or multiple versions of JInitiator

In this case you'll need to apply Patch 5397653: Firefox does not work with multiple java plugin versions. Its just a quick patch, no prereqs, go for it!

2. If you are using Microsoft Windows Vista

In this case I'll feel very sorry for as well as suggesting you copy jvm.dll from a Sun JRE 6.0 Update 1 (or higher) installation. This is as per Bug 6074498.

3. If you still have problems after the above.

Make sure you have switched off the Enable Java option in Firefox, per Note 285218.1.

• Tools -> Options -> Content
• Uncheck the 'Enable Java' option so that the Sun JRE plug-in is not enabled (this ensures that the Jinitiator plug-in is used instead).

If you have any other scenarios or issues with Firefox and JInitiator / Sun JRE Plugin, please post a comment here!

Reference

• Patch 5397653: Firefox does not work with multiple java plugin versions
• Note 285218.1: Recommended Browsers for Oracle E-Business Suite 11i
• Bug 6074498: Unable To Connect To E-Business Suite On Vista

Related Posts

• Internet Explorer 7 crash on jvm.dll with Oracle JInitiator - Applications Forms - Windows Live Sign-In Helper

 

 

XML / BI Publisher concurrent request fails with no error message? Check Output Post Processor (OPP) logfile for errors like: invalid char in text

So your Oracle Reports based concurrent request completed with warning and your concurrent request log file looks like this:

+------------- 1) PUBLISH -------------+
Beginning post-processing of request 1294502 on node XXXX01 at 02-SEP-2008 12:53:28.
Post-processing of request 1294502 failed at 02-SEP-2008 12:53:33 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
+--------------------------------------+

And if you go to System Administrator, Concurrent > Manager > Administer, Query up "Output Post Processor", click on Processes, View Manager Log, you see something like:

[9/2/08 10:44:34 AM] [198325:RT1294354]
Template code: XXGLXXXX
Template app:  XXV8
Language:      en
Territory:     US
Output type:   EXCEL
[9/2/08 10:44:49 AM] [UNEXPECTED] [198325:RT1294354] java.lang.reflect.InvocationTargetException
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:517)
 at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:224)
 at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:177)
 at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1044)
 at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:997)
 at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)
 at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1657)
 at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:967)
 at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5888)
 at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3438)
 at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3527)
 at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:247)
 at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:157)
Caused by: oracle.xdo.parser.v2.XMLParseException: Invalid char in text.
 at oracle.xdo.parser.v2.XMLError.flushErrors1(XMLError.java:324)
 at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:290)
 at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java:266)
 ... 17 more
[9/2/08 10:44:49 AM] [198325:RT1294354] Completed post-processing actions for request 1294354.

You look at your XML file via View Concurrent Requests, Diagnostics, View XML. Then how do you find the invalid character?

Try loading the XML Data in BI Publisher Desktop Word Plugin (Data > Load XML Data), and hopefully you'll see something like the following that gives the details of where the error is occurring (of course without the smudges ;-):

In this case the "invalid char" is indicated by the square box.

Throwing that into a hex editor (part of the highly recommended PSPad) we see character hex 05 followed by the two periods (hex 2E):

Looking at our ASCII table we see 05 is Enquiry - but this isn't a printing character and so will be causing the problem.

Okay, so now we know what's causing it, we can just update the data to remove the special character, and run the report again without hassles!

Or we could write a wrapper PL/SQL procedure to remove the control characters from the affected fields and add to the Report definition SQL.

Or those of you with more problems that just one occurrence of the control character could log an SR and see if something can be done other than that referred to in Note:155078.1!

BI / XML Publisher Bursting fails with InvalidPropertyValueException for IPP_HTTP_RESPONSE_CHECK_INTERVAL

If you are attempting bursting and hit an error that looks something like the following:

[082608_022234429][oracle.apps.xdo.batch.DeliveryHelper][EXCEPTION]
oracle.apps.xdo.delivery.InvalidPropertyValueException: Invalid String property  value for Integer. 
Property name :[IPP_HTTP_RESPONSE_CHECK_INTERVAL], 
Property  value :[O]

Check out Metalink Note 603424.1!

Solution:

A patch containing a later version of the DeliveryHelper.java must be installed in order to resolve the issue:

• Oracle E-Business Suite 11i The issue is encountered only when Patch 6470598 has been installed. This one-off patch has already been superseded by a new patch which included the fixed version of the DeliveryHelper.java. Patch 6470598 XML Bursting Reply-To Using From Instead resolves the issue.
• Oracle E-Business Suite Release 12 A one-off patch on top of the 12.0.4 code level is required to resolve the issue: Patch 6482024 Bursting Engine Does Not Resolve OA_MEDIA. This patch is released under the terms of 'By Support' which implies that the patch is queryable on Metalink, but downloads of this patch requires a password. Please contact Global Customer Support to receive a password to download the patch.

Discoverer Plus window not appearing or Jinitiator JVM conflicts on the Oracle eBusiness Suite: Java JRE EnableSecureStaticVersioning

If you find that Discoverer Plus won't start (or the Discoverer Plus windows doesn't appear) after downloading the Java Applet, or if you're having issues with JInitiator with Oracle Applications, then it could be that you have multiple versions of Java required. For your Oracle Discoverer Plus, Oracle JInitiator Java Plugin (JVM), or other Java based software multiple versions of Java can cause conflicts, so try the following steps. Actually I'd recommend any rollout of the Disco Plus or EBS client include the below steps!

1. Allow multiple concurrent versions of Java to run by enabling Secure Static Versioning.

Update or Create the following Windows registry entry on your desktop client as follows;

1.1 If the 'Java Deployment' and 'Policy' folders do not exist under your HKEY LOCAL MACHINE -> SOFTWARE -> JavaSoft entry in your registry you will first need to create these folders as follows;
1.2 Right mouse click on the JavaSoft folder in your registry and from the menu select 'New -> Key'. Name the new folder 'Java Deployment'. Open this folder and create another folder named 'Policy' underneath it, then follow the rest of the steps below.
1.3 Go to 'HKEY LOCAL MACHINE -> SOFTWARE -> JavaSoft -> Java Deployment -> Policy' in your Windows registry
1.4 Right mouse click on the Policy folder and from the menu select 'New -> DWORD Value'
1.5 Right click on the newly created value and rename it to - 'EnableSecureStaticVersioning'
1.6 The Data value should remain at the default of '0x00000000 (0)'

2. Switch off automatic updates of Java.

It is advisable to turn off the automatic upgrade facility for the desktop client JRE. This will ensure that newer versions of the JRE plug-in are not installed, and used with Oracle E-Business Suite / Oracle Discoverer unknowingly. This feature can be turned off as follows;

2.1 From the 'Start Menu', select 'ControlPanel'
2.2 Double click the 'Java' icon
2.3 Select the 'Update' tab
2.4 Uncheck the 'Check for Updates Automatically' box
2.5 Click the 'Never Check' button on the 'Java Update -Warning' pop up window
2.6 Click 'OK' to close the 'Java Control Panel'

If you are getting crashes that refer to jvm.dll see my other popular post on JVM crashes.

References:

• Sun Forum 1
• Sun Forum 2

Where do I get the XML file or request output file for my BI Publisher Report / Concurrent Request?

A quick post ... it's been a frenetic few months, so blog posts a bit thin lately but plenty of good stuff in the pipeline!

Generally when I'm designing a BI Publisher/XML Publisher report I'll create a concurrent program that generates XML, I'll follow the usual steps:

1. Setup the concurrent program to output Text
2. Run it to ensure its working
3. Switch the concurrent program to output XML
4. Run the concurrent program to output XML
5. SFTP/copy the o*.out XML file from $APPLCSF/$APPLOUT
6. Load it into Word via the BI Publisher Desktop plugin and design the layout "on the run".
7. Setup the BI Publisher Data Definition/Template
8. Perform system/unit tests

Is there an easier way to get the XML file from a concurrent request? Sure is - nice and easy through the front end.

Get the XML File from a BI Publisher based concurrent request/report:

1. View->Requests
2. Find the request you're interested in
3. Click on Diagnostics button
4. Click the View XML
   
5. Save the file to your PC by doing File->Save As, *.xml

But where does the XML file live?

Well, by default it is $APPLCSF/$APPLOUT/o{REQUEST_ID}.out.

But if that's the XML file, then where does the actual output file reside as the location of the XML file is where normal request output resides?

Get the Request Output File for a BI Publisher based concurrent request/report:

The output is $APPLCSF/$APPLOUT/{REPORTNAME}_{REQUEST_ID}_{COUNT}.PDF|RTF|EXCEL|HTML

Where

• REPORTNAME is the concurrent program short name,
• REQUEST_ID is the concurrent request ID
• COUNT is a counter based on the number of times a request has been re-published.
• One of PDF, RTF, EXCEL, HTML is the file extension/type dependent on the output formats chosen.

An example is: XXXX_FNDSCURS_2803880_1.EXCEL

Output file location courtesy of Tim's post here.

Cool, file locations identified!

 

Find JDeveloper with OAF / OA Extension patch for Oracle eBusiness Suite Release 11i / Release 12

I've been working with Java more recently, and thought this might be a handy reference.

In order to find the right JDeveloper match up for extending the Oracle eBusiness Suite / Applications, point your web browser to http://host:port/OA_HTML/OAInfo.jsp, then choose the matched JDeveloper patch.

Release 11i

OA Framework 5.10 patch	JDeveloper 9i Patch
ATG.PF.H (patch 3438354 or Oracle Applications 11.5.10) or 11.5.10K	Patch 4045639 9IJDEVELOPER WITH OA EXTENSION ARU FOR FWK.H
ATG PF CU1 (patch 4017300) or 11.5.101CU	Patch 4141787 9IJDEVELOPER WITH OA EXTENSION ARU FOR CU1
ATG PF CU2 (patch 4125550) or 11.5.102CU	Patch 4573517 Oracle9i JDeveloper with OA Extension for 11.5.10 CU2
11i.ATG_PF.H RUP3 (patch 4334965) or 11.5.103CU	Patch 4725670 9IJDEVELOPER WITH OA EXTENSION ARU FOR 11i10 RUP3
11i.ATG_PF.H RUP4 (patch 4676589)	Patch 5455514 9IJDEVELOPER WITH OA EXTENSION ARU FOR 11i10 RUP4
11i.ATG_PF.H RUP5 (patch 5473858)	Patch 6012619 9IJDeveloper With OA Extension ARU FOR 11i10 RUP5
11i.ATG_PF.H.RUP6 (patch 5903765)	Patch 6739235 9IJDeveloper With OA Extension ARU FOR 11i10 RUP6

Release 12

ATG Release 12 Version	JDeveloper 10g Patch
12.0.0	Patch 5856648 10g Jdev with OA Extension
12.0.1 (patch 5907545)	Patch 5856648 10g Jdev with OA Extension
12.0.2 (patch 5484000 or 5917344)	Patch 6491398 10g Jdev with OA Extension ARU for R12 RUP2 (replaces 6197418)
12.0.3 (patch 6141000 or 6077669)	Patch 6509325 10g Jdev with OA Extension ARU for R12 RUP3
12.0.4 (patch 6435000 or 6272680)	Patch 6908968 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12 RUP4
12.0.5 - no full 12.0.5 release planned only individual product suites like HRMS and Financials 12.0.5	n/a
12.0.6 (patch 6728000 or patch 7237006)	Patch 7523554 10G Jdeveloper With OA Extension ARU for R12 RUP6
12.1 (Controlled Release - only included for completeness)	Patch 7315332 10G Jdev with OA Extension ARU for R12.1 (Controlled Release)
12.1.1 (rapidInstall or patch 7303030)	Patch 8431482 10G Jdeveloper with OA Extension ARU for R12.1.1
12.1.2 (patch 7303033 or patch 7651091)	Patch 9172975 10G Jdeveloper with OA Extension ARU for R12.1.2
12.1.3 (patch 9239090 or patch 8919491)	Patch 9879989 10G Jdeveloper with OA Extension ARU for R12.1.3

For details latest details see Metalink Note:416708.1 or Note:330236.1

NZOUG Call for Papers - Conference 20-21 October 2008

Keen to head down-under? Check out this message from the New Zealand Oracle Users Group.

The New Zealand Oracle Users Group is pleased to announce… Call for Papers and Training for the 2008 Conference We only require your ABSTRACT of not more than 150 words at this stage. We invite all users and suppliers of Oracle technology and applications and related products to submit presentations, including Oracle Users with an interesting story, case study or any useful tips Oracle Partners playing a key role in the Oracle world Third party suppliers of products and services that will assist Oracle technology and application users Presentation topics may include but are not limited to Oracle Aplications such as eBS, JDE, Peoplesoft and Hyperion, and Oracle Development, Middleware and Database technologies. Everything is welcome for submission but delegates are especially interested in hearing case studies of real life scenarios and situations, lessons learnt and best practices. Both Technical and Business streams will run throughout the conference programme with presentations covering the implementation, use and support of the whole range of Oracle and associated third party products and services. If your paper is selected for presentation: You’ll be admitted to the conference free of charge upon submission of your full written paper, and Your paper will be published in the conference proceedings.
SUBMITTING AN ABSTRACT
How do I submit an abstract? Visit our submission website and complete the Call for Papers submission, by 20 June 2008 Also anyone can submit topics you are interested in, and we’ll try to source a presenter for the topic. We’ll post further information about this and for presenters on our website in due course. Remember to visit our website for all up to date information on regional events, the conference, and other news. We look forward to receiving your completed submissions by 20 June 2008
HOW DO I REGISTER FOR THE CONFERENCE?
We are not quite ready to open registration but watch this space (or keep an eye on our website) in the next few weeks for an announcement.
WHAT DISCOUNTS CAN WE GET?
There will be an early bird discount for all registrations before the 1st September 2008. Watch this space for these great rates.
VENUE AND DATES
Rotorua 20th and 21st October 2008 Novotel Rotorua Lakeside – Rotorua
NEED MORE INFORMATION?
Any questions please contact our conference management company, The Conference Company. By phone on +64 9 360 1240 or by email at nzoug@tcc.co.nz

Clearing Email Notifications and manually setting the Workflow/Java Notification Mailer Override/Test Address via SQL for the Oracle eBusiness Suite

Update: 14-Mar-2012 Added supported back-end method to update Workflow Notification Mailer attributes. Warning: This post also contains unsupported SQL updates, use at your own risk!

I think the Workflow Notification Mailer is excellent, but one of my pet hates is the setup process for a mailer. I never seem to be able to get it setup cleanly. One thing that really bugs me is that the Service Component Manager (Workflow Mailer Service) needs to be running before you can set the "Override Address". So when setting up a mailer you have to be very careful that the "Manual" startup option is set or your Mailer will start after configuration or when you startup the Workflow Mailer Service. Similarly caution is needed when cloning non-Prod environments from Prod when the Prod Override Address is not set, but Test/Dev etc need to be set.

Additionally, there's no button anywhere with a label like "Click me to update all Mail_Status pending Notifications as Sent" which is what the following accomplishes:

update WF_NOTIFICATIONS
set mail_status = 'SENT'
where mail_status = 'MAIL';

# Note: Change the apps_password in the following command
sqlplus apps @$FND_TOP/patch/115/sql/wfntfqup.sql APPS apps_password APPLSYS

Okay, so here's how you get the current Override Address via SQL on the backend:

select fscpv.parameter_value
from   fnd_svc_comp_params_tl fscpt
,      fnd_svc_comp_param_vals fscpv
where  fscpt.display_name = 'Test Address'
and    fscpt.parameter_id = fscpv.parameter_id; 

And now here's a very unsupported way to update the Override Address - please try this on a Test environment first to make sure it works for you! Note this will update all Mailers you have setup. Recommended to stop and start the mailers after making this change. Also make sure you change the email address to your Test Address and change the NONE to your current value (from previous SQL) if necessary:

update fnd_svc_comp_param_vals
set    parameter_value = 'MyTestAddress@MyCompany.com'
where  parameter_value = 'NONE'
and    parameter_id =
( select parameter_id
 from   fnd_svc_comp_params_tl
 where  display_name = 'Test Address'
);

commit;

Update: 14-Mar-2012 - There is a supported way to make back-end updates to Workflow Notification Mailer (and other service components). This is documented in Support Note 1399464.1. In short run the following and follow the prompts:

sqlplus apps @$FND_TOP/sql/afsvcpup.sql

PS. See Metalink Note 467229.1 if you get the dreaded "ORA-20000: Oracle Error = -20000 - ORA-20000: 330 Alert messages exist in WF_NOTIFICATION_OUT. Ensure these messages are processed before running wfntfqup.sql"

PPS. Anil has a nice post clear post where the Override Address (Test Address) lives these days here.

Recommended Patch Lists updated on Metalink - check before implementing/upgrading

Just took a look at the Recommended Patch Lists on Metalink, first time for a while, and if my memory serves me correct there are now more products listed.

Good to see BPEL represented as well as the core Oracle eBusiness Suite, Database and Application Server product suites. Whenever implementing, upgrading or just applying a new patchset, take a look at the recommended patch lists.

Now if only Oracle would get with the times and RSS feed the functionality there. For the EBS customers something official like the Patchsets Release 11i and Release 12 Feeds would be great!

 

Why is mod_plsql not supported with the Oracle eBusiness Suite Release 12? Fusion Crossroads #1

Update: As posted on Steven Chan's blog, the answers to my queries in this post are now well described in Metalink Note Note:726711.1

One of the well publicized and contentious considerations at the crossroads of Fusion relates to the "official" lack of support for the mod_plsql component in the Oracle eBusiness Suite Release 12.

I'm a keen battler on items of contention and I've been tracking this one for while. A high percentage of customers I've dealt with have invested in mod_plsql (mod PL/SQL) based solutions. With its reappearance on the forums recently and interest in R12 I thought it would be nice to take a step back to this.

First of all let's neglect the question a bit longer and look at a different statement, for reference, from here:

Although mod_plsql is no longer hosted as part of the standard Release 12 technology stack infrastructure, it's still possible to use it, in albeit a configuration that requires more diskspace. You can have a separate Oracle Application Server 10g installation, either in a separate ORACLE_HOME on an existing server, or on a physically separate machine.  You can use mod_plsql and other mod_plsql-based tools (such as Application Express) on that instance to access the E-Business Suite Release 12.

Hmm, so we know that we can use mod_plsql with Release 12. Just need to spin those propellors a bit and hey presto - there you go, working again. Or even just plug that Apache module back in.

If thats the case, then how does this all relate to support? Surely if the product can be used in a supported configuration, then it should be supported!? Using Apache (Oracle HTTP Server) and mod_plsql is one supported configuration of Oracle Application Express so I don't see the problem being with mod_plsql itself. If it was an inherent problem with mod_plsql then where would that leave Metalink?

Also, the quoted statement above conveniently fails to mention that inevitable L word - licenses. I'm no expert in the L word, so I venture no further and leave that to your own due diligence!

My current understanding - and I may be wrong so correct me if I am - is that:

1. the use of mod_plsql in combination with the APPS schema inherently raises security problems
2. mod_plsql is not on the roadmap to Fusion

With respect to 1, security problems generally can be fixed, for example, as they were for those issues in Security Alert #28.

With respect to 2, this is a technology decision in direction made by Oracle so my feeling is that it shouldn't affect support.

So where does that leave us?

Well, I leave you to form your own opinion, but I'd love Oracle to clarify further their position on the support of mod_plsql with Release 12.

PS. For more details on using mod_plsql with Release 12 open a Support Request (SR) on Metalink and ask for Note 435544.1.

Time for an Oracle eBusiness Suite Release 12 Upgrade? Eat your own dog food!

A number of years ago Oracle trumpeted the global implementation of its eBusiness Suite internally. In my view, this was a very important event for all eBusiness Suite customers. Why? Oracle was not only eating its own dogfood, but also giving customers a number of signals:

1. Oracle believes and relies on its own products.
2. Gaps/shortcomings in its own products become highly visible internally.
3. The readiness of major releases is signalled by Oracle's internal adoption of the release.

Release 12 has been generally available for over a year - since 1 Feb 2007, with key enhancements such as BI Publisher (XML Publisher), Integration Repository, Subledger Accounting and Multiple Organization Access (MOAC) being in the spotlight. Four Release Update Packs are available at the time of writing (to version 12.0.4). My understanding is that Oracle has upgraded its internal production instance and had a month or two to iron out the bugs, so to my mind Release 12 is ready for the primetime!

Now I can hear the echoes "but what about Fusion ... we can go directly from 11i10 (11.5.10.x) to Fusion?" ...

Well, I'm a fan of "big bang" implementations, but I also respect the path of least resistance and with what I know about Fusion my thinking is the path from Release 12 (which is based on Fusion Middleware) to Fusion will be smoother. I guess we'll see later this year when (hopefully) a number of Fusion Applications are released. I'm not fond of holding my breath for anticipated software releases!

In any case here are a few pointers to handy Release 12 Upgrade resources.

Note: for the presentations you may need Username: cboracle - Password: oraclec6

• Presentation: Upgrading to eBusiness Suite R12 - Best Practises
• Presentation: Upgrading to Oracle Fusion Applications: Planning Ahead
• Presentation: Upgrade with Oracle’s Maintenance Wizard
• Whitepaper: Best Practices for Upgrading Oracle E-Business Suite
• Metalink Note: Upgrading to Release 12
• Blog - Steven Chan: Apps Release 12.0.4 Release Update Pack Now Available
• Blog - Steven Chan: Top 5 Myths About Patching Apps Environments
• Forum: Oracle eBusiness Suite R12 Install/Upgrade
• Software: eDelivery
• Documentation: Oracle Financials Concepts Guide, Release 12
• Documentation: Oracle Financials and Oracle Procurement Functional Upgrade Guide: Release 11i to Release 12

With respect to technical considerations such as the desupport of mod_plsql, the impending demise of Oracle Reports and Workflow, if you'd like my view, leave me a comment or send an email!

Update: Added links to documents thanks to David (see comments)

Boost productivity, reduce user frustration: Speed startup of Oracle Applications concurrent requests

Apps Users: Do you recognize this key sequence?
alt-v r enter alt-r alt-r alt-r alt-r alt-r ...

That's me waiting for concurrent requests to complete ... or worse ... to start!

Are you, your Developers or Test Team constantly clicking the "Refresh" button on the View Concurrent Requests screen to no avail?

If this is you then read on ... or forward to your DBA ... it could be time to decrease the sleep time of your standard concurrent manager!

Does the following query return 30, 60 or higher for the "Standard" concurrent manager?

select fcq.concurrent_queue_id
,      fcq.concurrent_queue_name
,      fcqt.user_concurrent_queue_name
,      fcqs.sleep_seconds sleep_sec
,      fcqs.min_processes min_proc
from   fnd_concurrent_queues fcq
,      fnd_concurrent_queues_tl fcqt
,      fnd_concurrent_queue_size fcqs 
,      fnd_concurrent_processors fcpr
where  fcq.concurrent_queue_id = fcqs.concurrent_queue_id
and    fcq.concurrent_queue_id = fcqt.concurrent_queue_id
and    fcq.concurrent_processor_id = fcpr.concurrent_processor_id
and    fcqt.language = 'US'
and    fcpr.concurrent_processor_name = 'FNDLIBR'
order by decode(fcq.concurrent_queue_name, 'STANDARD',0,1)
,        fcqt.user_concurrent_queue_name;

Is your average wait (AVG_WAIT) time for concurrent requests starting above a second or two?

Caveat: the following query assumes the majority of requests are not scheduled, any wait over 2minutes is excluded, and request history is retained for at least 2 weeks.

PROMPT Concurrent Requests wait stats for the prior week
select trunc(sysdate-8) date_from
,      trunc(sysdate-1) date_to
,      count(1) num_requests
,      round(sum(actual_start_date - request_date),2) tot_wait
,      round(sum(actual_start_date - request_date) / count(1),2) avg_wait
from   fnd_concurrent_requests
where  actual_start_date is not null
and    actual_start_date - request_date < 120
and    request_date >= trunc(sysdate-8)
and    request_date <  trunc(sysdate-1);

Review your Workshift for your Standard (or similar) manager.

• System Administrator, Concurrent, Manager, Define
• Query up the Standard manager (or similar)
• Click on Workshifts
• Review what the Sleep Seconds and Processes are set to.

Set the sleep time low enough, say 10 seconds, and check that there are adequate processes.

Note of course that reducing sleep time or increasing processes will put more load on your hardware, but if you have the capacity try it and see how it goes!

 

Oracle eBusiness Suite Product and Acronym Listing

Couldn't find anything like this anywhere, so here we go!

Oracle eBusiness Suite / Applications Products with Acronyms and comparison of Release 11i and Release 12.

Acronym	Product	Release	Notes
ABM	Activity Based Management	R11i, R12	Obsolete R12
AD	Applications DBA	R11i, R12
ADS	Applications Demonstration Services	R11i, R12
ADS_DEV	ADS Development	R11i, R12
ADX	Rapid Install	n/a	Psuedo Product
AGIS	Advanced Global Intercompany System	R12	Sub-product of FUN
AHL	Complex Maintenance Repair and Overhaul	R11i, R12
AHM	Hosting Manager	R11i, R12	Obsolete R12
AK	Common Modules-AK	R11i, R12
ALR	Alert	R11i, R12
AME	Approvals Management	R11i, R12
AMF	Fulfillment Services	R11i, R12	Obsolete R12
AML	Leads Management	n/a	Psuedo Product
AMS	Marketing	R11i, R12
AMV	Marketing Encyclopedia System	R11i, R12
AMW	Internal Controls Manager	R11i, R12
AN	Sales Analysis	R11i, R12
APPLCSF	Applications Common Support/Script Files	R11i, R12	Acronym - not product or psuedo product.
AR	Receivables	R11i, R12
AS	Sales Foundation	R11i, R12
ASF	Sales Online	R11i, R12
ASG	CRM Gateway for Mobile Devices	R11i, R12
ASL	Sales Offline	R11i, R12
ASN	Sales	R11i, R12
ASO	Order Capture	R11i, R12
ASP	Oracle Sales for Handhelds	R11i, R12	Renamed from Field Sales/Palm Devices
AST	TeleSales	R11i, R12
ATG	Applications Technology	n/a	Psuedo Product
AU	Application Utilities	R11i, R12
AX	Global Accounting Engine	R11i, R12	Obsolete R12
AZ	Application Implementation	R11i, R12
BEN	Advanced Benefits	R11i, R12
BIC	Customer Intelligence	R11i, R12	Obsolete R12
BIE	eCommerce Intelligence	R11i, R12
BIL	Sales Intelligence	R11i, R12
BIM	Marketing Intelligence	R11i, R12
BIN	Communications Intelligence	R11i, R12
BIS	Applications BIS	R11i, R12	AKA Business Intelligence
BIV	Service Intelligence	R11i, R12
BIX	Interaction Center Intelligence	R11i, R12
BIY	Systems Intelligence	R11i, R12
BLC	Utility Billing	R11i, R12
BNE	Web Applications Desktop Integrator	R11i, R12
BOM	Bills of Material	R11i, R12
BPA	Bill Presentment Architecture	n/a	Psuedo Product
BSC	Balanced Scorecard	R11i, R12
CAC	Common Application Calendar	n/a	Psuedo Product
CC	Interaction Center	n/a	Psuedo Product
CCT	Telephony Manager	R11i, R12
CDR	Oracle Clinical Data Repository	R12	AKA Life Sciences Data Hub
CE	Cash Management	R11i, R12
CHV	Supplier Scheduling	R11i, R12
CLA	APAC Consulting Localizations	R12
CLE	EMEA Consulting Localizations	R12
CLJ	Japan Consulting Localizations	R12
CLL	LAD Consulting Localizations	R12
CLN	Supply Chain Trading Connector for RosettaNet	R11i, R12
CLR	Culinary Application	R11i, R12
CN	Incentive Compensation	R11i, R12
COM	Communications	n/a	Psuedo Product
CPGC	CPG - CDOA	R11i, R12
CRP	Capacity	R11i, R12
CS	Service	R11i, R12
CSC	Customer Care	R11i, R12
CSD	Depot Repair	R11i, R12
CSE	Asset Tracking	R11i, R12	Renamed from Enterprise Install Base
CSF	Field Service	R11i, R12
CSI	Install Base	R11i, R12
CSK	Knowledge Base	n/a	Psuedo Product
CSL	Field Service/Laptop	R11i, R12
CSM	Field Service/Palm	R11i, R12
CSN	Call Center	R12
CSP	Spares Management	R11i, R12
CSR	Scheduler	R11i, R12
CSS	Support	R11i, R12	Obsolete R12
CST	Cost Management	R11i, R12
CSZ	Customer Support	n/a	Psuedo Product
CTB	Clinical Transaction Base	R11i, R12
CUA	Capital Resource Logistics - Assets	R11i, R12
CUC	Revenue Accounting	R11i, R12
CUE	Billing Connect	R11i, R12	Obsolete R12
CUF	Capital Resource Logistics - Financials	R11i, R12
CUG	Citizen Interaction Center	R11i, R12
CUI	Network Logistics - Inventory	R11i, R12
CUN	Network Logistics - NATS	R11i, R12	Obsolete R12
CUP	Network Logistics - Purchasing	R11i, R12
CUR	Mass Market Receivables for Comms	R11i, R12
CUS	Network Logistics	R11i, R12
CUSTOM	Custom Development	R11i, R12
CZ	Configurator	R11i, R12
DDD	CADView-3D	R11i, R12
DDR	Demand Signal Repository	R12.1
DEM	Demo Order Entry (AOL Class)	R11i, R12
DEM01	Team 01 Order Entry Demo	R12
DMF	Discrete Manufacturing	n/a	Psuedo Product
DNA	Development	R11i, R12
DOM	Document Managment and Collaboration	R11i, R12
DPP	Price Protection	n/a	Psuedo Product
DT	DateTrack	R11i, R12
DUMMY_GMO	Obsolete Process Operations	R12
EAA	SEM Exchange	R11i, R12	Obsolete R12
EAM	Enterprise Asset Management	R11i, R12
EC	e-Commerce Gateway	R11i, R12
ECX	XML Gateway	R11i, R12
EDR	E-Records	R11i, R12
EDW	Enterprise Data Warehouse	n/a	Psuedo Product
EGO	Advanced Product Catalog	R11i, R12
EMS	Environment Management System	R11i, R12
ENG	Engineering	R11i, R12
ENI	Product Development Intelligence	R11i, R12
EVM	Value Based Management	R11i, R12
EWS	Enterprise Warehouse Source	n/a	Psuedo Product
EXCHG	Exchange	n/a	Psuedo Product
FEM	Enterprise Performance Foundation	R11i, R12	Renamed from Strategic Enterprise Management
FF	FastFormula	R11i, R12
FII	Financial Intelligence	R11i, R12
FIN	Financials	n/a	Psuedo Product
FLM	Flow Manufacturing	R11i, R12
FND	Application Object Library, FND=FouNDation	R11i, R12
FPA	Project Portfolio Analysis	R11i, R12	Renamed from Portfolio Analyzer
FPT	Banking Center	R11i, R12	Obsolete R12
FRM	Report Manager	R11i, R12
FTE	Transportation Execution	R11i, R12
FTP	Transfer Pricing	R11i, R12
FUN	Financials Common Modules	R12
FV	Federal Financials	R11i, R12
FWK	Applications Framework	n/a	Psuedo Product
GCS	Financial Consolidation Hub	R11i, R12	Renamed from Global Consolidation System
GIS	Global Intercompany System	R11i
GHR	US Federal Human Resources	R11i, R12
GMA	Process Manufacturing Systems	R11i, R12
GMD	Process Manufacturing Product Development	R11i, R12
GME	Process Manufacturing Process Execution	R11i, R12
GMF	Process Manufacturing Financials	R11i, R12
GMI	Process Manufacturing Inventory	R11i, R12
GML	Process Manufacturing Logistics	R11i, R12
GMO	Manufacturing Execution System for Process Manufacturing	R12
GMP	Process Manufacturing Process Planning	R11i, R12
GMS	Grants Accounting	R11i, R12
GMW	Process Manufacturing Portal	R11i, R12
GNI	Genealogy Intelligence	R11i, R12
GR	Process Manufacturing Regulatory Management	R11i, R12
HC	Healthcare	n/a	Psuedo Product
HCA	Healthcare	R11i, R12
HCC	iHCConnect	R11i, R12
HCN	iHCIntegrate	R11i, R12
HCP	Healthcare Intelligence	R11i, R12	Renamed from Healthcare Portal
HCT	Healthcare Terminology Server	R11i, R12
HR	Human Resources	n/a	Psuedo Product
HRI	Human Resources Intelligence	R11i, R12
HXC	Time and Labor Engine	R11i, R12
HXT	Time and Labor	R11i, R12
HZ	Trading Community	n/a	Psuedo Product
IA	iAssets	R11i, R12
IAM	Digital Asset Management	R11i, R12
IBA	iMarketing	R11i, R12	Obsolete R12
IBC	Content Manager	R11i, R12
IBE	iStore	R11i, R12
IBP	Bill Presentment & Payment	R11i, R12
IBT	iAuction	R11i, R12
IBU	iSupport	R11i, R12
IBW	Oracle Web Analytics	R12
IBY	Payments	R11i, R12	Renamed from iPayments
ICX	Oracle iProcurement	R11i, R12	Renamed from Self_Service Web Applications
IEB	Interaction Blending	R11i, R12
IEC	Advanced Outbound Telephony	R11i, R12
IEM	Email Center	R11i, R12
IEO	Interaction Center Technology	R11i, R12
IEP	Predictive	R11i, R12
IES	Scripting	R11i, R12
IET	Call Center Connectors	R11i, R12
IEU	Universal Work Queue	R11i, R12
IEV	IVR Integrator	R11i, R12
IEX	Collections	R11i, R12
IGC	Contract Commitment	R11i, R12
IGF	Financial Aid	R11i, R12
IGI	Public Sector Financials International	R11i, R12
IGP	Personal Portfolio	n/a	Psuedo Product
IGR	Student Recruiting	n/a	Psuedo Product
IGS	Student System	R11i, R12	Renamed from Student Systems
IGW	Grants Proposal	R11i, R12
IMC	Customers Online	R11i, R12
IMT	iMeeting	R11i, R12	Obsolete R12
INV	Inventory	R11i, R12
INL	Oracle Landed Cost Management	R12.1
IPA	Capital Resource Logistics - Projects	R11i, R12
IPATCH	Oracle.com iPatch	n/a	Psuedo Product
IPD	Product Development	R11i, R12	Obsolete R12
IPM	Oracle Imaging Process Management	R12
IRC	iRecruitment	R12
ISC	Supply Chain Intelligence	R11i, R12
ISX	iSettlement	R11i, R12
ITA	Information Technology Audit	R12
ITG	Internet Procurement Enterprise Connector	R11i, R12
ITM	Item Master	n/a	Psuedo Product
IZU	Diagnostics	n/a	Psuedo Product
JA	Asia/Pacific Localizations	R11i, R12
JAI	Financials for India	n/a	Psuedo Product
JE	European Localizations	R11i, R12
JG	Regional Localizations	R11i, R12
JL	Latin America Localizations	R11i, R12
JMF	Supply Chain Localizations	R12
JTA	CRM Applications Foundation	n/a	Psuedo Product
JTF	CRM Foundation	R11i, R12
JTH	Interaction History	n/a	Psuedo Product
JTM	Mobile Application Foundation	R11i, R12
JTO	One-to-one Fulfillment	n/a	Psuedo Product
JTS	CRM Self Service Administration	R11i, R12
JTT	CRM Technology Foundation	n/a	Psuedo Product
JTU	CRM Utilities	n/a	Psuedo Product
JTY	Territories	n/a	Psuedo Product
LNS	Loans	R11i, R12
MAS	Marketing and Sales	n/a	Psuedo Product
ME	Controlled Availability Product	R11i, R12	Obsolete R12
MFG	Manufacturing	R11i, R12
MIA	Mobile Applications for Inventory Management	R11i, R12
MIV	Media Interactive	R11i, R12
MKT	Marketing	n/a	Psuedo Product
MQA	Mobile Quality Applications	R11i, R12
MRP	Master Scheduling/MRP	R11i, R12
MSC	Advanced Supply Chain Planning	R11i, R12
MSD	Demand Planning	R11i, R12
MSE	Manufacturing Development Operations	n/a	Psuedo Product
MSO	Constraint Based Optimization	R11i, R12
MSR	Inventory Optimization	R11i, R12
MST	Transportation Planning	R11i, R12
MSX	Supply Chain Exchange	n/a	Psuedo Product
MTH	Manufacturing Development Operations	n/a	Psuedo Product
MWA	Mobile Applications	R11i, R12
OAM	Oracle Applications Manager	R11i, R12
OCM	Credit Management	n/a	Psuedo Product
ODQ	Data Query	R11i, R12
OE	Order Entry	R11i, R12
OFA	Assets	R11i, R12	AKA FA
OIE	iExpenses	n/a	Psuedo Product
OIR	iReceivables	n/a	Psuedo Product
OIT	Internet Time	n/a	Psuedo Product
OK	Contracts Suite	n/a	Psuedo Product
OKB	Contracts for Subscriptions	R11i, R12	Obsolete R12
OKC	Contracts Core	R11i, R12
OKE	Project Contracts	R11i, R12
OKI	Contracts Intelligence	R11i, R12
OKL	Lease Management	R11i, R12
OKO	Contracts for Sales	R11i, R12	Obsolete R12
OKP	Contracts for Procurement	R11i, R12	Obsolete R12
OKR	Contracts for Rights	R11i, R12	Obsolete R12
OKS	Service Contracts	R11i, R12
OKT	Royalty Management	R11i, R12
OKX	Contracts Integration	R11i, R12
OM	Order Management	n/a	Psuedo Product
ONT	Order Management	R11i, R12
OPI	Operations Intelligence	R11i, R12
OPM	Process Manufacturing	n/a	Psuedo Product
OTA	Learning Management	R11i, R12
OUC	University Curriculum	R12
OWF	Workflow	n/a	Psuedo Product
OZF	Trade Management	R11i, R12
OZP	Trade Planning	R11i, R12	Obsolete R12
OZS	iClaims	R11i, R12	Obsolete R12
PA	Projects	R11i, R12
PAY	Payroll	R11i, R12
PBR	Budgeting and Planning	R11i, R12
PER	Human Resources	R11i, R12
PFT	Oracle Profitability Manager	R11i, R12	Renamed from Performance Analyzer
PJ	Projects	n/a	Psuedo Product
PJB	Project Billing	R11i, R12	Psuedo Product
PJC	Project Costing	R11i, R12	Psuedo Product
PJF	Project Foundation	R11i, R12	Psuedo Product
PJI	Project Intelligence	R11i, R12
PJL	Project Collaboration	R11i, R12	Psuedo Product
PJM	Project Manufacturing	R11i, R12
PJR	Project Resource Management	R11i, R12	Psuedo Product
PJT	Project Management	R11i, R12	Psuedo Product
PLM	Product Lifecycle Management	n/a	Psuedo Product
PMI	Process Manufacturing Intelligence	R11i, R12
PN	Property Manager	R11i, R12
PO	Purchasing	R11i, R12
POA	Purchasing Intelligence	R11i, R12
POM	Exchange	R11i, R12
PON	Sourcing	R11i, R12
POS	iSupplier Portal	R11i, R12
POV	Exchange Marketplace - Core	n/a	Psuedo Product
PQH	Public Sector HR	R11i, R12
PQP	Public Sector Payroll	R11i, R12
PRC	Process Connect	n/a	Psuedo Product
PRGC	Progress Custom	R11i, R12
PRP	Proposals	R11i, R12
PSA	Public Sector Financials	R11i, R12
PSB	Public Sector Budgeting	R11i, R12
PSP	Labor Distribution	R11i, R12
PSR	Public Sector Receivables	R12
PTX	Patch Tracking System	R11i, R12
PV	Partner Management	R11i, R12
QA	Quality	R11i, R12
QOT	Quoting	R11i, R12
QP	Advanced Pricing	R11i, R12
QPR	Oracle Deal Management	R12.1
QRM	Risk Management	R11i, R12
RCI	Regulatory Compliance Intelligence	n/a	Psuedo Product
RCM	Regulatory Capital Manager	R11i, R12	Obsolete R12
RG	Application Report Generator	R11i, R12
RHX	Advanced Planning Foundation	R11i, R12	Obsolete R12
RLA	Release Management Integration Kit	R11i, R12	Obsolete R12
RLM	Release Management	R11i, R12
RMG	Risk Manager	R11i, R12
RRC	Retail Core	R12
RRS	Site Management	R12
SCM	Supply Chain Management	n/a	Psuedo Product
SCP	Advanced Planning	n/a	Psuedo Product
SEM	Financials Services Applications	n/a	Psuedo Product
SHT	Applications Shared Technology	R11i, R12
SLS	Sales Suite	n/a	Psuedo Product
SQLAP	Payables	R11i, R12	AKA AP
SQLGL	General Ledger	R11i, R12	AKA GL
SRV	Service Suite	n/a	Psuedo Product
SSP	HRMS (UK)	R11i, R12
SYSADMIN	System Administration	R11i, R12
TXK	Teckstack	n/a	Psuedo Product
UMX	User Management	n/a	Psuedo Product
UNV	Student System	n/a	Psuedo Product
VEA	Automotive	R11i, R12
VEH	Automotive Integration Kit	R11i, R12	Obsolete R12
WIP	Work in Process	R11i, R12
WMA	Manufacturing Mobile Applications	R11i, R12
WMS	Warehouse Management	R11i, R12
WPS	Manufacturing Scheduling	R11i, R12
WSH	Shipping Execution	R11i, R12
WSM	Shop Floor Management	R11i, R12
XBOL	Business Online	R11i, R12
XDO	XML Publisher / BI Publisher, XDO=eXtended Document Object	R11i, R12
XDP	Provisioning	R11i, R12
XLA	Subledger Accounting	R12
XLE	Legal Entity Configurator	R12
XNA	Service Assurance for Communications	R11i, R12
XNB	Oracle Telecommunications Billing Integrator	R11i, R12	Renamed from eBusiness Billing
XNC	Sales for Communications	R11i, R12	Obsolete R12
XNI	Install Base Intelligence	R11i, R12	Obsolete R12
XNM	Marketing for Communications	R11i, R12	Obsolete R12
XNP	Number Portability	R11i, R12
XNS	Service for Communications	R11i, R12	Obsolete R12
XNT	TeleBusiness for Telecom/Utilities	R11i, R12
XTR	Treasury	R11i, R12
XXV8	Virtuate	R11i, R12
ZFA	Financial Analyzer	R11i, R12
ZPB	Enterprise Planning and Budgeting	R11i, R12
ZSA	Sales Analyzer	R11i, R12
ZX	E-Business Tax	R12