haritha
5/10/2010 10:02:33 PM
This article illustrates the usage of $FLEX$ with an example.
Full Article>>
|
|
prudhvi
8/25/2009 4:42:38 PM
This article illustrates the steps to be followed to Email a concurrent program’s output.
1) Write a procedure that will submit the concurrent program whose output has to be sent as an Email and once the program completes, send the output as Email using UTL_MAIL.send_attach_varchar2.
2) Register this procedure as a concurrent program so that this program can be run from Oracle Applications which will email a concurrent program’s output.
Note#1: Please try procedure only if your database version is 10g or above. UTM_MAIL package has been introduced only in 10g and if you are on 9i then try using UTL_SMTP package.
Note#2: This process requires your application server and database server to be on the same phycical machine or on the shared drive.
Reason: concurrent program output and log files are created on the application node where as UTL_MAIL package runs on the database node. If your applications is installed on multi node then use shell script to mail the output instead of database procedure.
Full Article>>
|
|
haritha
6/6/2009 9:48:02 PM
A flexfield is a field made up of sub–fields, or segments. There are two types of flexfields: key flexfields and descriptive flexfields.
Descriptive flexfields lets you add additional fields to the form in order to track additional information needed by the business, that would not be captured by the standard form.
Full Article>>
|
|
prudhvi
6/6/2009 5:18:21 PM
Attachments feature enables users to link files like images, word files, emails e.t.c to a particular form/function/record. Once you link a file to a form in oracle it will be saved on your server so that you can retrieve it easily when ever you want it.
Full Article>>
|
|
prudhvi
6/6/2009 4:54:28 PM
Normally we assign any concurrent program to a request group corresponding to the responsibility from which we want to run our concurrent program. What in case if user want to launch concurrent program directly from a menu.
Full Article>>
|
|
prudhvi
6/6/2009 4:45:59 PM
Steps to register a Concurrent Program in Oracle Applications
and adding it to request group.
Full Article>>
|
|