Daniel Borgstrom talking about Oracle

Now all presentations are available for download at this LINK .

If I should summarize this years conference in one word it will be CLOUD . They already talked about cloud last year but this year it was mentioned in all the sessions and key notes I attended. Other observations: Fusion Applications is really coming and it looks really good. Based on the latest technology and standards with the user experience in focus this looks like a fantastic product. Exadata version 3 - this machine, packed with hardware and software from Oracle (the Red Stack) takes Exadata to the next level with 26 TB of  fast memory.  New database version 12c - optimized to run in the cloud and have the new "pluggable" concept. Big Data - term that popped up here and there. Big data is all the unstructured data found in social media. If we can collect and process this data we will find better opportunities and have a stronger posistion in the market place.

Personalize and extend eBusiness Suite with Rich Mashups In this session the presenter described different ways to extend eBusiness Suite in a supported manner. BC4J-substitution to external business logic. OAF to build new components. Web ADI to build custom integrators (included in the standard license). Oracle Forms to build new extensions and applications. ADF to build new extensions and applications (use EBS SDK to use specific EBS methods). APEX to build new extensions and applications. mod_plsql to build new extensions and applications (not recommended, does not work in R12) Possible to plug in Endeca in 12.1.3 (license for Endeca needed). Coming in 0-12 months Model Personalizations: make it possible to create view objects (VO) within personalization Support for undo personalization: today we need to delete them manually from the database using scripts Support for copy personalization: make it possible to deploy the changes to other environment, today it needs...

Fusion Applications: Functional Deep Dive In this session the presenter talked about the highlights of Fusion Apps in the functional areas. - FND_USER is no longer used; all security related actions will be performed in Oracle Identity Management. - Business Groups are replaced by the new object Enterprise. - Operating Units does not exist anymore; the new term is Business Unit. Some setup data that were before connected to the Operating Unit are now decoupled and no redundant set up is needed. One example is payment terms that are set up once and then copied to where it’s needed. - Legal Entity Timezone; auto adjust the date to the correct timezone. - Chart of Account: - Separate the CoA structure from the value set. - Using trees to separate hierarchies from value sets. - Allow range of accounts to be specified using a node in a hierarchy. - Date effectively: - Allow users to change attributes of an object and store an older object version of that object - Applica...

Optimize and Extend Oracle Applications: the path to Fusion Apps In this session it was discussed what customers could do to make the transformation to Fusion as smoth as posssible. Three key areas where mentioned: - keep you applications on the latest version - optimize tools and technologies - coexistence If you follow the upgrade path and stays on the latest versions it will be much easier to upgrade. For example, in R12 the Financial architecture (with subbledger accouting etc) is the same as in Fusion. What you also can do to make the road to Fusion less bumpy is to start use some of the tools and technologies already today. Example of this are Oracle Identity Management (OID, used in Fusion Apps for security), Oracle BI Apps and Oracle BI Publisher. It’s possible to use all of these tools already today in your R12 environment. One other possibility to get ready for Fusion is to implement new modules using Fusion Apps. If you want to start use the HR module it’s recomm...

Today the conference was in full swing with 100s of sessions. Below you will find what I attended. Keynote: Shift Complexity On Mondays keynote they started to state that OOW is celebrating its 35th anniversary. The conference has 50.000 attendants and about 1 million views online, impressive. In this keynote Mike Hurd talked about simplify IT, Oracle offers complete stack and complete choice - the Red Stack. You can now run on servers from Oracle, Database from Oracle, Middleware from Oracle and Applications from Oracle, the complete red stack. With Oracle Engineered System you will get all the benefits of software and hardware. It made me think, isn’t this exactly what Apple is doing? There target consumers are completely different but they also offer hardware and software in their products. When you can control both hardware and software you will have a better optimized product. As simple as that. Oracle Fusion Applications: Overview, Strategy and Roadmap Today 400 customer...

Today the conference started with alot of special interest group meetings and the welcome keynote. The welcome keyknote was devided by some bigshot from Fujitsu and Larry Elison. I would guess that about 99% of the people were there to listen to Larry. The Japanese Fujitsu guy had a long uninspired talk about big data (all unstructured data from social media) and how there new chip Athena would be great to do all this processing. Oracle is working together with Fujitsu to optimize the usage of their technology. Then Larry came on. Larry hade 4 announcements. Announcement 1 Oracle will start to sell infrastructure as service (IaaS). IaaS is VM, OS Services etc. This together with what they already have, SaaS and PaaS will make them complete in the cloud business. Announcement 2 Oracle Private Cloud. I think he talked about this last year so I was a little surprised that it came up again. With Orcale Private Cloud you can run the cloud behind your firewall with the same service...

After a 22 hour trip we finally reach our hotel in San Francisco last night. As expected we woke up early and went out to explore the city. Open World starts first on Sunday but you can register and make yourself ready for the conferance already today. We pickuped our badge at Hilton Hotel in downtown SF. Tomorrow the fun will begin! View of downtown San Francisco Oracle is taking over the city This years welcome pack

If you have a lot of events and other logic that triggers the use of the que WF_DEFERRED there could be a need of create an additional index on the que table. When you have many rows in WF_DEFERRED the deque process is so slow that it blocks other incoming messages. Follow note CPU Intensive Querries Due To FTS on WF_DEFERRED [ID 463242.1] . Our scenario: We had about 3.5 million rows in WF_DEFERRED that where dequeuing very slowly, about 2 per minute. After creation of the index all records where dequed in about 30 minutes.

To show a message dialog in Oracle Forms (in EBS) use fnd_message.debug('your message here') By using this built-in there is no need to create your own alerts.

In R12 the AP payments are completely redone. The logic is now using java to create a XML-file and XML Publisher to create the specific payment file which you send to the bank. Some key information: The table IBY_TRXN_DOCUMENTS includes the created XML in the column DOCUMENT . Use the responsibility Payments Setup Administrator to setup the payments. If you want to add XML tags to the standard XML file this could be done by using the package IBY_FD_EXTRACT_EXT_PUB (more info can be found at  http://imdjkoch.wordpress.com/ tag/iby_fd_extract_ext_pub/ ).

Using FNDLOAD is possible to transfer a lot of objects between instances. It's also possible to transfer Business Events but not with FNDLOAD, to accomplish this we need to use a java program called WFXLoad. Download - Event java oracle.apps.fnd.wf.WFXLoad -d apps appspwd host:port:sid thin US download_file .wfx EVENTS event_name Example java oracle.apps.fnd.wf.WFXLoad -d apps password bigboy:1521:demo thin US xx_demo_EVENT.wfx EVENTS xx.oracle.apps.demo Download - Subscription java oracle.apps.fnd.wf.WFXLoad -d apps appspwd host:port:sid thin US download_file .wfx SUBSCRIPTIONS event_name Example java oracle.apps.fnd.wf.WFXLoad -d apps password bigboy:1521:demo thin US xx_demo_SUBSR.wfx SUBSCRIPTIONS xx.oracle.apps.demo Upload - Event java oracle.apps.fnd.wf.WFXLoad -u apps appspwd host:port:sid thin US upload_file .wfx Example java oracle.apps.fnd.wf.WFXLoad -u apps password bigboy:1521:demo thin US xx_demo_EVENT.wfx Upload - Subscription java oracle.app...

If the database and apps.server are not installed on the same machine the first proposed solution may not work. The database user will not be able to read concurrent request output files if they are not located in a common directory which can be reached from both the servers. In my case no such common directory existed. There was one common directory which could be reached from both machines and the code below takes advantage by that. The code is a SQL-script which is fired by a concurrent request. --+=======================================================================+ --| FILENAME | --| XXXFND_SUBMIT_AND_EMAIL.sql | --| | --| VERSION | --| 1.0 | --| ...