Archives

Archive for February 2012

Create your own website in Oracle Apps

In all my Oracle Apps projects one of the first things that I make is excel sheets with Oracle instance details(URL, server name, IP, Unix password, database password), tns entries, contact list and other details. These excel sheets used to be referred by the entire project team by each individual storing the files on their local drives. … Continue reading

Rate this:

Attach BLOB documents to a workflow notification

  Business users are always looking for something that Oracle does not provide by default. It could range from simple to extremely complex. Some users wanted me to give them the flexibility to view attachments on a PO approval notification. Let me break this down. 1.       User creates PO 2.       User attaches documents to PO … Continue reading

Rate this:

Creating Menu items with Forms Personalization

Menu items can be added to forms using personalization to add functionality to the form that can be invoked as and when required by the user. As part of one requirement we had to give the user the option of initiating a workflow after making a change on the Supplier form. We created a menu … Continue reading

Rate this:

Enforcing field entry in Forms Personalization

I received a requirement to make the Anticipated Date field on the Payment Batch form mandatory for all users if the Payment Method field is Electronic. It seemed to be a very straight forward requirement whereby I only check the value of the Payment Method field and make the Anticipated Date field property, Required = … Continue reading

Rate this:

Change the default Oracle logo on all OAF pages

Some corporations want to modify the default Oracle logo that appears on top left of the Oracle Apps login page to be modified to their own logo to give a personal touch. I have shown the steps below to implement the solution.   Step 1: Back up the Oracle logo file The standard Oracle logo on Oracle … Continue reading

Rate this:

Use custom Profile Options/Lookups

Many a times a PL/SQL program in Oracle apps need to map certain values or retrieve a value based on certain condition. For example, an employee id which has a certain privilege for a responsibility, or to find out whether the responsibility in which the program is running allows for a certain operation, etc. I … Continue reading

Rate this:

Developing a workflow notification body to display master/detail information

Almost all workflow developments involve designing and developing notifications to be sent to users. Sometimes notifications might have to display data in master/detail format. For instance, we might need to show supplier master as well as supplier site information. Development process 1.       Create a workflow attribute with type as Document. This workflow attribute will contain … Continue reading

Rate this:

Execute a concurrent program from a form function

A concurrent program is generally submitted from the Standard Request Submission (SRS) form. From this form any request existing in the request group that is attached to the responsibility, can be executed. If we get a requirement to execute a program that falls outside the request group, how do we handle it? What if a request group … Continue reading

Rate this:

Register a Host/Unix concurrent program

Host concurrent programs are generally used for file processing. This is one area where PL/SQL does not do a very good job. For instance, if we need to process some files and have to clean data files, move the files across directories, then host programs come in handy. Almost all Oracle applications installations are done … Continue reading

Rate this:

Execute a concurrent program from unix shell script

Just as PL/SQL allows concurrent programs ot be excuted using the API, FND_REQUEST.SUBMIT_REQUEST. You can see an example of FND_REQUEST in a previous post. In Unix shell scripts one has to use CONCSUB program. An example is given below The back slashes are used when the command has to be continued on a new line. Explanation … Continue reading

Rate this:

Extending Lookups in APPS

Lookups in Oracle Apps give developers and users the ability to map one value to another. The limitation is that it allows for 4 fields only, Code, Meaning, Description and Tag. Among these values, Code, is a unique column. Again if we need to use more than 4 columns then we have to extend Lookups … Continue reading

Rate this:

How to delete a concurrent program in APPS

Oracle Apps allows creation of concurrent programs but does not allow deletion of the programs. The concurrent program form only allows the programs to be disabled. This might not go well with the IT manager or the DBAs as there can be several programs in Oracle which are no longer used but appear in the list of … Continue reading

Rate this:

Using Execute Immediate with PL/SQL tables/BULK operations

In previous posts I had demonstrated using PL/SQL tables in data processing and in Dynamic SQL. I shall now demonstrate how Execute Immediate can be used in BULK processing of Update and Delete. The code is illustrated below.   Create a backup table   Output Create table with Execute Immediate Let us select the user_id and … Continue reading

Rate this:

Script to enable and disable APPS users

The DBA wanted to disable all the users after an instance is cloned from production. As this was an existing instance he did not want the users to unknowingly login to it right after cloning before he released the instance for usage. He wanted to run a script to disable all the users after cloning, then … Continue reading

Rate this:

Invoke Discoverer Reports from OAF/Self Service pages

Discoverer reports are generally run from the Discoverer Viewer responsibility given to users. We can create a function on responsibilities so that the users can click on the link from the responsibilities page after logging in, to run the reports. We can add further restrictions on the function to allow the user access to certain … Continue reading

Rate this:

Traffic

Site Stats

  • 675,897 views since Feb 2012

Archives

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 208 other followers

Flags

Free counters!
Follow

Get every new post delivered to your Inbox.

Join 208 other followers