Daniel Borgstrom talking about Oracle

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 | --| ...