The company I work right now uses autoconfig. No problem off course, but they also have a lot off custom templates. Autoconfig uses templates to generate the configuration files so the EBS can work properly. When you want to add customizations the a template, you place that template in the […]
Oracle E-Business Suite
Oracle E-Business Suite aka Oracle Applications, PeopleSoft, Siebel, JD Edwards and Retek related articles.
Oracle e-Business Suite/Fusion Applications and SAP both hot pluggable … ?
For a long time Oracle e-Business Suite was 100% Oracle. Running Oracle e-Business Suite meant Oracle for the application, the middle tier and the database. In future releases this might be a little bit different. The hot-pluggable options of the Fusion-strategy enable customers to be more flexible in defining the configuration they desire. […]
Seeded XML Publisher Templates for Financial Reports in Oracle e-Business Suite version 11.5.10.2 and Release 12
According to Oracle Release 12 offers flexible, XML-based solutions for 70% of all reports in the Financial modules. Who cares, when it’s the alltime hottest sunday afternoon in the Netherlands (29 degrees in April) ? I admit.I “care” … , but only after enjoying the beautiful weather first. Does Oracle […]
Oracle Incentive Compensation (OIC)
Last year I’ve been working on the Oracle Incentive Compensation (OIC) module (version 11.5.10), the successor of Oracle Sales Compensation. For those who haven’t heard of the module before, OIC is an Oracle e-Business Suite module by which you can calculate and pay commissions for salespersons based on incoming transactions. […]
"Form Personalization" in Oracle e-Business Suite Release 12 still doesn't offer a workaround for suboptimal LOV-Queries
In Oracle E-Business Suite release 11.5.10.2 some list of values (LOV) are not implemented considering the full functionality of the e-Business Suite. The " Project LOV’s" in Payables Invoices (f.e.) always shows all project tasks and expenditure types. Tasks and/or expenditure types, excluded for charges, are shown also. "Charge Allowed […]
Oracle E-Business Suite R12 with OEM10G
After configuring the Oracle EBS 11.5.10 environment in OEM10G, it was time to also configure the new Oracle EBS R12 environment in OEM10G. Before I could configure R12 in OEM10G, I first had to upgrade the Oracle Applications plugin for EM10GR3. I downloaded the patches p5489352_R12_LINUX.zip and installed this patch […]
EBS Release 12 "SWAN" User Interface
Last week AMIS organized an " E-Business Suite Release 12 (EBS R12) New Features" session. It became obviously that EBS R12 has many new features and the improved user interface is only one of them. Nevertheless, the new "Swan" user interface is for most end users an important one and end users are curious to experience […]
Merging pdf documents using the BI-Publisher API
BI Publisher (named XML-Publisher until a few weeks ago, but what is in the name) offers besides the possibility to create documents also the possibility to interact with the application through its application programming interface. These apis offer the programmer several functions of which the PDF document merger is one. […]
R12 AD utilities: One step forward, two steps back?
After having completed my first installation of E-Business Suite Release 12, I decided to take a look on Metalink whether there were some critical updates to EBS Release 12. My special interest was in the Applications Technology Family. I found out there was a number of patches to be applied. […]
Installing Oracle E-Business Suite Release 12 with shared APPL_TOP on CFS
As soon as EBS Release 12 became available, I started with the installation, eager to find out what the differences were compared to 11i. I had had the opportunity to attend some trainings sessions and presentations about the new technology features, and, well, you know how things go when you […]
First patch for Oracle E-Business Suite R12
This morning I downloaded my first patch for the new Oracle EBS R12. Already there are 2 high priority patches for the new EBS, and I downloaded one of them (patch p5856453_R12[1].AD.A_R12_LINUX.zip). I could not help feeling a little bit excited, because patching is changed in EBS R12. The manual […]
Sizing Oracle EBS 12i
I wanted to find out how ‘big’ the new Oracle EBS 12i release really is. So, I downloaded the software from Edelivery and created a stage area. From the stage area I started the rapidwiz to check the required disk space. Here is the required disk space for Oracle EBS […]
XML-Publisher how to display your input parameter
This week I have played a bit with XML-Publisher. The goal was take some reports and try to migrate them to XML-Publisher version. Yesterday I posted a blog about how you can setup a matrix report using the proper tags and references. I must say I was very content that […]
XML-Publisher building a matrix report
Last week I experimented with XML-Publisher a bit. The goal was to figure how to built a matrix report with simular layout as an Oracle Reports matrix report. Would it be easier, better I was not sure but curious to find out. As most developers know building an Oracle matrix […]
FNDCPASS ALLORACLE
FNDCPASS is an EBS tool to change passwords of database schema’s within the Oracle EBS. For example, you can change the APPS password using FNDCPASS, but also any other schema in the EBS database. FNDCPASS can also be used to change the password of an application user (like sysadmin). To […]
Upgrading EBS 11i database (9.2.0.6) to 10GR2 database
I have upgraded my EBS 11.5.10 database (9.2.6.0) to release 10gR2 (10.2.0.2.0). I have followed note 362203.1 from Metalink to perform the upgrade. Here are some tips or problems I ran into… 1. The first patch is 5478710 (TXK (FND & ADX) AUTOCONFIG ROLLUP PATCH O) After applying the patch […]
Changing background in Oracle EBS 11i
It would be nice to have your own company logo as background in the Oracle E-business suite. Default the background is white, but the following steps will put your company logo (or any other logo…) in the background. 1. modify the appsweb.cfg in the $OA_HTML/bin directory. Find the ‘background’ parameter […]
SQL Tracing in Self Service Applications (CRM) within Oracle Applications 11i
In a lot of cases it is very interesting to be able to trace Self Service Applications (CRM) in Oracle Applications 11i. Most of the time it is very hard to understand what is going on in such a session and in that case it might be very handy to […]
The issue of Webforms and Internet Explorer add-ons
IE 7 Webforms jvm.dll crash
Oracle APPS 11i Technology Administrator OCP beta program extended
Oracle has “recently” launched the Oracle Applications Technology Certified Professional Administrator (OCP) certification. First, Oracle launched a beta program for this certification, to end on October 31st of this year. However, Oracle now has decided to extend the beta program to the end of January, 2007. This was officially told […]
XML-Publisher 5.6.2, datasource and users
XML-Publisher
XML-Publisher 5.6.2, the automatic install
Some time ago I experimented with XML-Publisher 50 Desktop. The tool of which it looks like it is going to replace Oracle Reports in the future. Although the desktop version gives you a possiblility to create reports in several formats like RTF, PDF, Excel and HTMl it does not offer […]
The Future of Oracle Applications – John Wookey at OOW 2006
One of the keynote speakers during last week’s Oracle Open World Conference van John Wookey, Senior Vice President for Oracle Applications. John is sort of an old acquaintance, as two years ago I did an interview with him on dogfood (see: Eating your own dogfood – use of Oracle Development […]
adpatch fails- Cannot connect to RAC database
Yesterday I needed to apply a patch to my Oracle E-Business Suite 11.5.10.2 environment. This environment consist of a 10G release 2 RAC database and two application tiers. I needed to apply patch 4676589 (11i.ATG_PF.H.RUP4), which is about 275MB in size, zipped. I defined 4 workers; the patch ran smoothly […]
The Technology Stack for Oracle Applications Release 12
On Pankaj Chandiramani’s Blog we can find a lot of information with regard to the technology Oracle will build the Release 12 edition of the E-Business Suite on. Pankaj works as an application engineer for Oracle India and apparently has access to this information. He confirms the message we picked […]
Demo application advanced Forms features (ODTUG 2006 version)
Demo application advanced Forms features (ODTUG 2006 version) Last June, I held a presentation at the ODTUG conference in Washington DC “Oracle Forms: Productivity with new choicesâ€. During this presentation I showed a demo application, which is an improved version of the one I previously published on this blog This […]
Using FNDLOAD to transfer Oracle Alert
When you use Oracle Alert, a module from the Oracle EBS, you probably work with custom alerts next to the standard alerts provided by Oracle. When working with custom alerts, their will be changes to these alerts and those changes must also be applied to your production environment. Once you […]
Session on XML Publisher – The Successor to Oracle Reports?
Last week, my colleague Marcos guided us through the still relatively new Oracle offering called XML Publisher. During a session of our Knowledge Center on Oracle Development Tools, we saw XML Publisher in action and used it ourselves. We also had quite a bit of discussion, whether XML Publisher will […]
Oracle and Siebel – merger – is official
Yesterday, Oracle’s President Charles Philips announced that Oracle’s acquisition of Siebel is completed and Oracle and Siebel are now operating as one. One of the comments in the official announcement reads: “We also plan to evolve customers, at their own pace, to the next generation of our standards-based applications, Oracle […]
Implementing Virtual IP addresses with Oracle 10g/RAC for E-Business Suite 11i
Oracle 10g Cluster Ready Services enables databases to use a Virtual IP address to configure the listener on. This feature is to assure that oracle clients quickly failover when a node fails. When a client connects to a tns-alias, it uses a TCP connection to an IP address, defined in […]
How to properly start OC4J on a production server.
The proper way to start OC4J is sparsely documented by Oracle: To start OC4J in a standalone environment, issue the following command from the j2ee/home/ directory: java -jar oc4j.jar options This may often be adequate for development or test purposes, but it never is in a production environment.