Notes from 30 years of Oracle.
Notes on Oracle — PL/SQL, APEX, E-Business Suite and integrations. Mostly written for my future self — problems I ran into on projects and how I solved them.
2025 · 1 post
Process and read xlsx from PL/SQL
To read a XLSX-file from PL/SQL can be a bit challenging. One option is to rename the file to .ZIP and then process it from from there. An XLSX-file…
2012 · 13 posts
Oracle Open World - Presentations
Now all presentations are available for download at this…
Oracle Open World - Conclusions
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…
Oracle Open World day 5
Personalize and extend eBusiness Suite with Rich Mashups In this session the presenter described different ways to extend eBusiness Suite in a…
Oracle Open World day 4
Fusion Applications: Functional Deep Dive In this session the presenter talked about the highlights of Fusion Apps in the functional areas. -…
Oracle Open World day 3
Optimize and Extend Oracle Applications: the path to Fusion Apps In this session it was discussed what customers could do to make the transformation…
Oracle Open World day 2
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…
Oracle Open World day 1
Today the conference started with alot of special interest group meetings and the welcome keynote. The welcome keyknote was devided by some bigshot…
Oracle Open World day 0
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…
Index on WF_DEFERRED
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…
Show message dialog
To show a message dialog in Oracle Forms (in EBS) use By using this built-in there is no need to create your own alerts.
R12 AP Payments
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…
Business Event - download/upload
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…
Sending concurrent request output by e-mail - part II
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…
2011 · 27 posts
Sending concurrent request output by e-mail
This post describes how to send a request output using e-mail. First, create two directories. The first one should point to the output directory. The…
FNDLOAD
This post describes how to down- and upload different components using FNDLOAD. Value set Download FNDLOAD apps/appspwd O Y DOWNLOAD…
Diagnostics -> Examine
To be able to use the menu Help - Diagnostics - Examine you have to set the profile value Utilities:Diagnostics to Yes.
Remove OAF Customization
First, list your customization to get the exact path: Then, remove it:
Compiling Form in R12 env
1. FTP your form to $AU_TOP/forms/US 2. Compile using: 3. Move the fmx to the correct folder, ex 4. Done
DBMS_SCHEDULER
When you back in the day wanted to schedule or run something in the backgound you used DBMS_JOB. With the beginning of release 10g of the database…
Contract line -> Inventory Item
Useful query which will fetch your inventory items from contract lines. Service Products: Covered Products: References - Note 467334.1: 11i: How to…
List Forms Personalization and XX-Forms
In a R12 upgrade project it can be a good idea to read some information from the database regarding the customizations. List Forms Personalization…
Set completion status of Concurrent Request (Host)
If you have a concurrent request executable of type host (shell script on unix) and you want to set the status of the request to Warning or Error…
Concurrent request output directory
In most cases the output files will be written to $COMMON_TOP/admin/out/_<ENV.NAME _. If you don't find anything there investgate the environment…
Internet Exploring crashing when starting EBS (jInitiator)
Internet Exploring is crashing when starting EBS (jInitiator). You have installed jInitiator ver 1.3.1.21 without any problem but when you are trying…
List profile options and their values
This select will give you all the values for a specific profile option. Tested with 11i.
Status of a customer
One of my clients who run the Finance modules (AR, ARP, GL etc), Service Contracts and Field Service in E-Business Suite R12 had some issues with…
DBMS_JOB
Submitted/scheduled job can be found in: Running jobs can be found in: Remove a job: DBMS_JOB have been deprecated and replaced by DBMS_SCHEDULER…
Automatic deqeuing with multi level XML (Advanced Queing)
Using Advanced Queing is a good idea when you have some integration or other stuff you want to execute asynchronous. With Advanced Queing it's also…
Disable Forms Personalization
Sometimes when you are developing a Forms Personalization it will error out before the form is opened. When this happens you cannot disable custom…
Native XML (BI) Publisher Report
This post describes how to create a report using XML Publisher in Oracle E-Business Suite. Traditionally when a XML Publisher report has been created…
Get your ORGs...
To list your organizations in EBS run
Set MOAC context (R12)
To set the MOAC (Multiorg Access Control) context in your database session (SQL PLUS, TOAD, SQL Developer etc) use: When policy context is set to M…
Clear buffer cache
When you are working with performance issues you need to have an empty database cache to get a "real" result from your query. If you run a query…
Creating a PL/SQL based webservice with a XMLType in/out parameter (EBS 12.1.1)
Out of the box can we not create a webservice that have a parameter (in or out) of type XMLType using SOA Gateway. When the service is called you…
Fix for "Each row in the Query Result Columns..." when extending VO
When you are extending a VO you can quite often run in to the error " Each row in the Query Result Columns must be mapped to a unique query attribute…
Fix for java.sql.SQLException: Invalid column type when extending a VO
When you are extending a view object (VO) in OA Framework it's possible that you will run in to the problem java.sql.SQLException: Invalid column…
Increase timeout settings for Apache in EBS R12
You may need to increase the timeout setting for the Apache server if you have long running webservices. Our test server was extremly slow so we…
Increase java heap space for SOA Gateway
One problem you can face when you are working with a webservice that returns thousands of rows is that you will get memory problems. In the…
How to create a custom integration interface in SOA Gateway
This example will illustrate on how to develop a simple interface using PL/SQL. The Integration Repository will recognize integrations through…
Getting started with Integrated SOA Gateway
The Integrated SOA Gateway is a product released with Oracle E-Business Suite version 12. SOA Gateway is built on top of Oracle Fusion Middleware and…