Entries Tagged 'Development' ↓

How many of you need to print the address of an operating unit on a custom report or OAF page? How many of you need to include the county? How many of you ended up with a query like

select haou.name organization_name, flv.meaning county
from hr_all_organization_units haou
, hr_locations_all hl
, fnd_lookup_values_vl flv
where haou.location_id = hl.location_id
and flv.lookup_type = hl.style || ‘_COUNTY’
and flv.lookup_code = hl.region_1

and learn that it does not work in Europe? Let me tell you something… Continue reading →

Consider the following simple task. The client is running Oracle eBusiness Suite release 11i or 12, and needs to print customer statements or AR dunning letters in a nice looking format with pictures, diagrams, hyperlinks, and fine print.
Definitely, we will be using BI Publisher to convert XML produced by the customer statement or dunning letter report into whatever format our client desires. The key question is: how to apply BI Publisher to customer statement output since customer statement is a spawned process which, as of time of this article, does not allow for BI Publisher template application!? Continue reading →

Quality of design documents is the perpetual issue which I had to face on every implementation I had ever had a chance to work on.
On my very first Oracle eBusiness Suite implementation project my manager asked me to paste everything, including source code at 6pt, into one big Word document to make sure nobody reads it. I am very thankful to my manager because I learned how not to write design documents and I read AIM Guidelines, both volumes. Question to the audience: who has ever seen these documents? Continue reading →

Introduction

Everybody who has worked with Oracle Receivables has had to deal with customer statements. Customer statements show customer related transactions such as invoices, credit memos, payments, etc. Customer statements are printed with a predefined cycle. There is a special form which allows you to submit generation of a customer statement.

The form submits a standard process ARXSGP written in Pro-C.  This process gathers information about customer receivables activities for the reporting period throughout the Oracle eBusiness Suite, inserts the information into temporary tables and submits the report ARXSGPO to actually produce the output. The result of this operation is an ASCII file. Continue reading →

The other day I came across a web site www.javacamp.org which lists Java design patterns. Highly recommend to all software designers. Even if you do not do software design for Java, knowledge of design patterns is an invaluable resource of ideas for new applications you are building.