Dependent Parameters in Oracle Applications Requirement: Say there is a concurrent program that lets you retrieve employee details based on employee name or employee number. The concurrent program has 3 parameters: 1.Search Criteria is a value set containing “Employee Name” and “Employee Number” as values 2.Employee Name 3.Employee Number When the user wants to search Read More..
The Generic Loader (FNDLOAD) is a concurrent program that can transfer Oracle Application entity data between database and text file. The loader reads a configuration file to determine which entity to access. In simple words FNDLOAD is used to transfer entity data from one instance/database to other. For example if you want to move a Read More..
Overview: Develop a report or PL/SQL Package to register as a concurrent program Create Executable: Link it to Report file(.rdf) or PL/SQL Package created Create Concurrent Program: Link to it executable defined in previous step Enter Parameters and link Value Sets Assign the registered Concurrent Program to a request group Creating Executable: Navigation: Login into Oracle Applications Read More..
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. To assign a concurrent program to a menu follow the steps Create a new function of form type Read More..
About Attachments: Attachment 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 whenever you want it. Supported Formats: You can link the following types. File (word, pdf, excel, Read More..
Overview of Flexfields: A flexfield is a field made up of sub–fields, or segments. There are two types of flexfields: key flexfields and descriptive flexfields. Key Flexfields: A Key flexfield is a field made up of segments, where each segment has both a value and a meaning, which appears on your form as a normal Read More..
This article illustrates the usage of $FLEX$ with an example. $FLEX$ is a special bind variable that can be used to base a parameter value on the other parameters (dependent parameters) Syntax – :$FLEX$.Value_ Set_Name Value_Set_Name is the name of value set for a prior parameter in the same parameter window that you want your Read More..
Goal: Define new DFF segment in Transactions Form and make it read only to Receivables Manager responsibility. All other responsibilities will have access to enter and edit the values and Receivables Manager will have access to only read but not edit and enter the value. You cannot make DFF segment read-only through personalization but you Read More..
The main use of enabling trace for a concurrent program comes during performance tuning. By examining a trace file, we come to know which query/queries is/are taking the longest time to execute, there by letting us to concentrate on tuning them in order to improve the overall performance of the program. The following is an Read More..
This article illustrates the steps to be followed to Email a concurrent program’s output. 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. Register this procedure as a concurrent program so that this Read More..
