Feed aggregator

oow 2010 presentation slides

Christian Bilien - Tue, 2010-09-21 09:06
Here are the slides of the presentation I did yesterday: OOW2010 Christian Bilien. The room was full and I noticed a number of people were standing at the back of the room, hope the awful sound did not add too much to the pain.
Categories: DBA Blogs

OWSM optimized for Oracle SPARC T3 server

Vikas Jain - Tue, 2010-09-21 02:20
Oracle's Executive VP John Fowler in his keynote at Oracle OpenWorld conference, announced release of Oracle SPARC T3 server.
The SPARC T3 processors pack 16 cores and 16 on-chip CMT crypto accelerators in a single socket.

OWSM has been optimized to take full advantage of such hardware acceleration by integrating with Solaris Cryptographic Framework that provides crypto acceleration passthrough into the hardware for both SPARC and Intel processors.

See integration whitepaper: High Performance Security for SOA and XML Web Services using Oracle Web Services Manager and Oracle SPARC Enterprise T-Series Servers

OWSM indeed is delivering the promise of Hardware and software engineered to work together.

Oracle Exalogic Elastic Cloud

Peeyush Tugnawat - Mon, 2010-09-20 15:46

Interesting announcement from Oracle about Oracle Exalogic Elastic Cloud



Exalogic Introduction


Oracle Exalogic Elastic Cloud

Peeyush Tugnawat - Mon, 2010-09-20 15:46

Interesting announcement from Oracle about Oracle Exalogic Elastic Cloud



Exalogic Introduction


Oracle EBS Release 12.1 Released: Top 8 New ATG Features

Gareth Roberts - Mon, 2010-09-20 12:56

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, Java 6, Application Server (Java/OAF)/JDeveloper Runtime, Application Server (Forms/Reports)
  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

Discoverer with EBS R12 - Sheet contains no data for custom Oracle eBusiness Suite Responsibility

Gareth Roberts - Mon, 2010-09-20 12:56

So you're working with Discoverer 10g integrated with the Oracle eBusiness Suite on Release 12. You've installed and set everything up per Metalink/MOS Note 373634.1 "Using Discoverer 10.1.2 with Oracle E-Business Suite Release 12" plus created a custom application and responsibility to have it's own menu items corresponding to your Discoverer Workbooks/Worksheets.

You login to your new responsibility and click on your new menu entry that you created per Metalink/MOS Note "How to Create a Link to a Discoverer Workbook in Apps R12" and what do you get when you query subledger data such as Payables Invoices, or secured General Ledger data?

This sheet currently contains no data.

Well, its a quick fix. Simply save the following value in the "Initialization SQL Statement - Custom" profile option at Responsibility level for your new Responsibility.

begin gl_security_pkg.init; mo_global.init('M'); end;

Note: this may depend on your setup of the following profile options:

  • GL Ledger Name
  • GL: Data Access Set
  • MO: Operating Unit
  • MO: Security Profile

All sorted!


Related Posts

OpenWorld 2009 done - back to Windy Wellington

Gareth Roberts - Mon, 2010-09-20 12:55

With OpenWorld 2009 all done plus a few highly enjoyable days in the Valley I'm now back at home. I had a fantastic time once again, second time around was much less daunting - I went for less sessions, more unconference and more shopping!

The first couple of days of OpenWorld this year seemed very light on attendees, but with a flurry of activity in the last few days and a fantastic appreciation event - an awesome performance from Aerosmith - things really picked up. Very few product announcements of essence from the Oracle team so the real highlights for me were catching up with a variety of people/groups at a number of events:

  • Australia/New Zealand Dinner
  • Rittman Mead BI Meetup
  • Bloggers Meetup
  • Oracle APEX Meetup
  • Catching up with the BI Publisher crew and meeting Ike
  • Hanging out with Michael, Greg and Mike - cheers guys.

A huge thanks to all the above for the hospitality.

So only a few notes this year that took my interest to note them down. It seems a bit light especially on the eBusiness Suite side so if I have missed anything major, please post a comment.

Larry's Keynote Announcements:

  • Linux update - survey (was it by HP?) reported 65% of Oracle Database customers run Oracle Enterprise Linux beneath the database. Interestingly high percentage.
  • Review of Exadata "v2" (Sun Oracle Database Machine) with statistics showing results twice as fast as "v1".
  • Product Support System in the works including on site data mining for analyzing system configuration and auto-advising bugs/patches needing to be addressed.
  • Fusion Applications related:
    • Commitment for support of, and new functionality in eBusiness Suite, Peoplesoft, JD Edwards and Siebel applications for the next decade in addition to Fusion Applications
    • "Version 1" of Fusion Applications in Testing.
    • Fusion Applications are "SaaS ready" and deployed on SOA, BI standards based middleware.

Just the one product release announcement related to my areas of work:

  • Business Intelligence Applications OBIA Release available

A number of interesting things up and coming, but most set for calendar year 2010.

OBI 11g - yet to be released, but demo'd, with my notes:

  • Common UI Components across the BI and Fusion product suites
  • Online BI Publisher Template Builder
  • A variety of excellent new features addons such as Answers Groups, Selection Steps, Visualizations
  • Extensions to current fuctionality such as Action Framework
  • Additional features such as Scorecards

Oracle APEX 4.0

  • The whole APEX community is getting ready and excited about the APEX 4.0 release due 2010.
  • It's great to see the new APEX Listener pre-production release out and getting plenty of feedback.

E-Business Suite:

  • 12.1.1 to include a new hompage / navigator + Web 2.0 style components therein
  • 12.1.1+ Integrated SOA Gateway (as an alternative to the EBS Adaptor which is part of SOA Suite).
  • Enterprise Manager pack addons for Health checks including online Patch and technology component Version comparison and recommendation tools.

Some other interesting tidbits that I noted:

  • Trial Usage of Advanced Compression on Oracle internal E-Business Suite top 100 objects reduced space usage on average by 3 times. Gotta see how Vision instances go with compression.
  • BI Publisher Data Template builder in the works (still), along with the demo'd BI Publisher Online Layout Template editor (demo'd as noted above).


So another excellent OpenWorld over - thanks to Oracle for putting on another flawless event and appreciate the Bloggers Pass. Even the weather made me feel at home ;-)

Next major event on my calendar is the NZOUG Conference 2010, Rotorua, New Zealand, March 15-16 2010 - looking forward to it. Hope to see some of you there!

PS. On a side note, from a New Zealand perspective, interesting that an IBM data center should fail around OpenWorld given Larry's consistent reiteration about the redundancies in the Oracle Database Machine and lack thereof in IBM's ex TPC-C beating solution! Even more than a week later seems like things are not quite back to the usual high Air New Zealand standards - following pic snapped 20-Oct-09.

Related Posts


BI / XML Publisher 5.4pt start-indent problems in XSL-FO blocks on EBS Check Format recursive template

Gareth Roberts - Mon, 2010-09-20 12:54
So you've just finished the first cut of your funky BI Publisher Check (Cheque) format template, and you feel pretty accomplished:
  • Logos, tables, non-preprinted stationary: Yes
  • Magnetic ink on printer loaded and ready to go: Yes
  • MICR font: Yes
  • Conditional signatures: Yes
  • Void check handling: Yes
  • Fixed Row Enumeration filler in tables via recursive templates: Yes

And then it all goes pear shaped … Doh!
Your filler recursive template does a dance to the right, indenting 5.4pt at a time.

With the cause in the XSL-FO template something like this: start-ident="5.4pt"

Well, you aren't the first person, or second to hit this, thanks theFurryOne for prompting this post. There is a workaround ... or two. You could edit the XSL-FO and replace the 5.4pt text with 0.0pt, but then you'd need to work with XSL-FO templates rather than RTF.

Alternatively you could put the following magic in the first cell of the filler recursive template:


And a bit of a re-jig on the recurvsive sub template alignment. For example:

And we're rockin and rolling - no XSL-FO template needed, "pure" RTF:

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

EBS Bursting: Filter on XML Elements using XPATH in Bursting Control File

Gareth Roberts - Mon, 2010-09-20 12:54

Just a quick post to give an example of a bursting control file that has multiple emails, with a filter based on XML Element in the data to select which email to send.

Oracle EBusiness Suite XML / BI Publisher Bursting Control File Example - Multiple Email Filter

Here it is:

<?xml version="1.0" encoding="UTF-8"?>
<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi">
<xapi:globalData location="stream"/>
<xapi:email server="${XXX_SMTP}" port="25" from="${XXX_SEND_FROM}" reply-to ="${XXX_REPLY_TO}">
<xapi:message id="email1" to="${XXX_CUST_EMAIL}" cc="${XXX_ARCHIVE_EMAIL}" attachment="true" content-type="html/text" subject="Statement from ${ORG_NAME} - ${STATEMENT_DATE}">Hello,
Please find attached the Statement for period to ${STATEMENT_DATE}.
Internal Ref: Customer Email
<xapi:email server="${XXX_SMTP}" port="25" from="${XXX_SEND_FROM}" reply-to ="${XXX_REPLY_TO}">
<xapi:message id="email2" to="${XXX_AGENT_EMAIL}" cc="${XXX_ARCHIVE_EMAIL}" attachment="true" content-type="html/text" subject="Statement from ${ORG_NAME} - ${STATEMENT_DATE}">Hello,
Please find attached the Statement for period to ${STATEMENT_DATE}.
Internal Ref: Agent Email
<xapi:document key="${CUSTOMER_ID}_1" output="${XXX_SHORTNAME}_Statement_${STATEMENT_DATE}" output-type="pdf" delivery="email1">
<xapi:template type="rtf" location="xdo://AR.XXX_STATEMENT_PRINT.en.00/?getSource=true" filter="/ARXSGPO_CPG/LIST_G_SETUP/G_SETUP/LIST_G_STATEMENT/G_STATEMENT[XXX_CUST_MODE='Email']"/>
<xapi:document key="${CUSTOMER_ID}_2" output="${XXX_SHORTNAME}_Statement_${STATEMENT_DATE}_Agent" output-type="pdf" delivery="email2">
<xapi:template type="rtf" location="xdo://AR.XXX_STATEMENT_PRINT.en.00/?getSource=true" filter="/ARXSGPO_CPG/LIST_G_SETUP/G_SETUP/LIST_G_STATEMENT/G_STATEMENT[XXX_AGENT_MODE='Email']"/>

Catch ya!

This is a post from Gareth's blog at http://garethroberts.blogspot.com
References Related Posts

Concurrent Program parameters in XML / BI Publisher Template - eBusiness Suite

Gareth Roberts - Mon, 2010-09-20 12:52

Just a short post with a note of how to get Oracle eBusiness Suite Concurrent Program Parameters into the output on an XML Publisher RTF Template.

There are two simple options, given an example parameter with token P_ORG_ID:

1. Add the concurrent program parameter as a field in the XML - this may be easier / necessary when you get to bursting or similar. Refer to the parameter using the usual <?P_ORG_ID?> RTF syntax.

2. Add the parameter using the param@begin syntax at the top of your RTF file:


And then refer the the value using dollar notation:


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

Related Posts

HTML Formatting issues in EBS R12 XML Publisher Remittance Advice Emails aka. Use Inline CSS Styles in BIP

Gareth Roberts - Mon, 2010-09-20 12:52

Apologies for the cryptic title on this one. The issue is a simple but subtle one ... and if you're not an eBusiness Suite customer, but interested in the BIP HTML formatting part, please read on as the discussion may be relevant.

In the Oracle eBusiness Suite Release 12 there is an out-of-the-box solution for sending Payables Remitttance Advice notices via Email. The program is "Send Separate Remittance Advices" and is integrated into the Payments Process. The standard solution utilizes XML Publisher under the covers, but (at the time of writing) has been coded to force HTML output for the Email content and uses its own delivery mechanism, rather than a more flexible bursting one that could attach PDFs to emails. Now, this means there are a couple of limitations with the output format for these Remittance Advice notices:

  1. The out-of-the-box HTML generated by XML / BI Publisher uses CSS Stylesheets as opposed to Inline CSS. This causes formatting issues with some specific Email Clients (such as GMail) as described by this "old" but still relevent post. This is the main focus of this article and I'll give details of a workaround.
  2. The use of HTML means from a document printing perspective a pixel-perfect format is tough to achieve.
  3. Images e.g. Company Logos, need to be referenced in the HTML and hence need to be publicly accessible on a web server. This also means that when Supplier's receive the Remittance Advice emails will probably not have the images displayed by default and they'll get the "some pictures have been blocked to help prevent the sender from identifying your computer ... click here to download images" or similar spam/tracking warnings.

So the out-of-the-box solution has these gotcha's until such time as it uses a "fixed-format", "all content embedded in email" delivery method such as attaching a PDF to the email with the advice details...

BUT WAIT, there may be workarounds.

For Issue 1. we can tell XML / BI Publisher to embed Inline CSS rather than CSS Stylesheets using the following undocumented XML Publisher configuration. Place the following configuration in the xdo.cfg file and put it in eBusiness Suite $XDO_TOP/resource directory. Usual caveats apply; please test this before rolling to Production. Also be aware that this may affect all HTML output, with output file sizes likely to increase.

<config version="1.0.0"  xmlns="http://xmlns.oracle.com/oxp/config/">
    <!-- html-css-embedding valid values  embed-to-element | embed-to-header | externalize -->
       <property  name="html-css-embedding">embed-to-element</property>

For Issue 2. one trick is to place your formatting inside a Table and fix the width / height to that which you require. This may take a smidgen of tweaking, but at least you can get something that looks and prints nicely.

For Issue 3 ... well, I'm still working that one - no workaround from Support yet to embed the images in the HTML. Will keep you posted. UPDATE: Enhancement request (ER) Bug 9834226 has been raised for the issue of inability to embed images in Remittance Advice.

Hope this helps.

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

References Related Posts

Environment Variables from database table - Oracle E-Business Suite

Gareth Roberts - Mon, 2010-09-20 12:51

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 );


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;

--------------- ----------------------------------------------------------------
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 );


NB: These queries assume your concurrent managers are running!

Catch ya!
This is a post from Gareth's blog at http://garethroberts.blogspot.com
References Update - Added example output and $APPLTMP output.

Stupid Yahoo Mail

David Aldridge - Mon, 2010-09-20 07:52
I just browsed my Yahoo spam folder and found an email purporting to be from an ex-work colleague. It was sent to a bunch of other ex-colleagues as well and contained a link to what looked like a site for selling fake ED pills. I replied to the colleague to say, “Hey looks like you’ve […]
Categories: BI & Warehousing

A Cause of ORA-38435 in Evaluate()

David Aldridge - Mon, 2010-09-20 07:40
I’m part way through an implementation of some ELT code that uses expression filters to parse records and assign zero-to-many “inboxes” to each row, and as is often the case with the less well-explored parts of the system it often feels like I’m hacking through the undergrowth in unknown territory. Under such conditions it’s not […]
Categories: BI & Warehousing

The Oracle Unbreakable Enterprise Kernel is Out!

Sergio's Blog - Mon, 2010-09-20 00:46
Last night, Larry Ellison announced that we have a new kernel for Oracle Linux called Unbreakable Enterprise Kernel. Read the news and see what our partners are saying.
Categories: DBA Blogs

Simba Technologies and Vlamis Software Solutions hosting special reception at OpenWorld 2010

Keith Laker - Sat, 2010-09-18 12:16

Please join Simba Technologies and Vlamis Software Solutions at a special OpenWorld 2010 reception for current and prospective Oracle OLAP users.

Cocktails and hors d’oeuvres will be served.

Time: Tuesday, September 21st, 2010 - 5pm – 7pm
Location: walking distance from Moscone Center. Please RSVP for location.

By Invitation Only. RSVP to events@simba.com

Categories: BI & Warehousing

OOW 2010: my room is changed

Christian Bilien - Sat, 2010-09-18 00:35
I was informed this morning (well in my morning) that Oracle Content moved me to Room 252: ID#: S314649 Title: Large-Scale Oracle RAC (and Sun Oracle Database Machine) Scalability Design Track: Database Date: 20-SEP-10 Time: 14:00 – 15:00 Venue: Moscone South Room: Rm 252
Categories: DBA Blogs

Oracle Open World 2010

Christian Bilien - Fri, 2010-09-17 14:46
I just took a look at the OOW Oracle Content Manager: looks like my room is almost full. I suspect the Exadata has something to do with it.  My session details are: S314649 Large-Scale Oracle RAC (and Sun Oracle Database Machine) Scalability Design Date: 20-SEP-10 Time: 14:00-15:00 Venue: Moscone South Room: Rm 236 My presentation […]
Categories: DBA Blogs

Special OpenWorld 2010 Cocktail Reception

Keith Laker - Fri, 2010-09-17 10:35
Join us! Simba Technologies and Vlamis Software Solutions are celebrating Oracle OLAP with a reception for current and prospective users. Please contact events@simba.com for exact location. Tuesday September 21, 2010 from 5-7PM. Walking distance from Moscone.

Simba product managers will also be available at the Oracle OLAP pod in Moscone West to answer questions you might have about Excel Pivot Tables and the MDX Provider for Oracle OLAP.
Categories: BI & Warehousing

OWSM at Oracle OpenWorld and JavaOne 2010

Vikas Jain - Wed, 2010-09-15 02:08

Oracle OpenWorld and JavaOne 2010 is coming up next week.
Listed below is OWSM's presence at the conference.

Demo Pod:

Title: SOA Security

Demo Area: Middleware
Pod #: W-177

ID#: S317146

Title: Securing Web Services: Solutions, Best Practices, and More

Track: OpenWorld: Middleware: Identity Management

Date: Tue, 21-Sep-10

Time: 12:30-13:30

Venue: Moscone South, Room: 309


Title: Security Threats and Countermeasures for REST and Cloud Services

Track: JavaOne: Enterprise Service Architectures and the Cloud

Date: Wed, 22-Sep-10

Time: 10:00-11:00

Venue: Parc 55

Room: Cyril Magnin II

ID#: S316710
Title: Analysis of Security & Compliance on Sun SPARC Enterprise T-Series Servers
Track: Sun SPARC Servers
Date: Thu, 23-SEP-10
Time: 12:00 - 13:00
Venue: Moscone South, Room: 252


ID# S314098

Title: Securing Web Services

Track: Java One: Java EE Web Profile and Platform Technologies

Date: Wed, 22-Sep-10

Time: 12:30-14:30

Venue: Hilton San Francisco, Room: Plaza A

Focus On documents:

Highly recommended to navigate through the maze

Identity Management


Service Oriented Architecture
Central link to all focus on documents

Hope to see you there.


Subscribe to Oracle FAQ aggregator