EBS
28 posts
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…
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.
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
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…
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…