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..
Story The below example explains a few of the important terms and concepts used in the Oracle E-Business Suite. This would be a good starting point for the beginners to better understand the concepts behind Oracle Applications. Say Harry is the owner of a wholesale fruit shop. He buys various fruits like apples, oranges, mangos Read More..
SQL LOADER is a very powerful tool that lets you load data from a delimited or position based data file into Oracle tables. We have received many questions regarding SQL LOADER features from many users. Here is the brief explanation on the same. Please note that the basic knowledge of SQL LOADER is required to Read More..
Overview: SQL LOADER is an Oracle utility used to load data into table given a datafile which has the records that need to be loaded. SQL*Loader takes data file, as well as a control file, to insert data into the table. When a Control file is executed, it can create Three (3) files called log 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..
Objectives: Forms Customization Overview Mandatory Form and Libraries Setting the Forms60_Path in Registry Develop the form using form builder tool Changes to be made in the Triggers and Program Units Transfering the fmb file from local system to Vision Instance Generating the fmx file on Vision Instance Registering the form in Oracle Apps Forms Customization 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..
Objective: Create a report using wizard in Report Builder. Action: Open Report Builder This is the first screen you will see. Select the first option “Use the Report Wizard” and click OK. Action: Click Next Action: Enter Report Title: erpschools_sample_report and then select “Tabular” option. As per name “Tabular” our output will be organized in a tabular Read More..
Objectives: Steps to Register Shell Script as a concurrent program Sample Shell Script to copy the file from source to destination Basic Shell Script Commands Steps to Register Shell Script as a concurrent program step 1: ======= Place the <name>.prog script under the bin directory for your applications top directory. For example, call the script Read More..
Overview: Oracle XML Publisher is a template-based publishing solution delivered with the Oracle E-Business Suite. It provides a new approach to report design and publishing by integrating familiar desktop word processing tools with existing E-Business Suite data reporting. At runtime, XML Publisher merges the custom templates with the concurrent request data extracts to generate output Read More..
Steps To Develop a Query_Find Form in Oracle Apps Step 1: Open Template.fmb with form builder save it with another name(XXMZ_Query_Find.fmb) and give the module name as XXMZ_QUERY_FIND. Step2 : Delete BLOCKNAME from Window,Canvas and Data Block and delete DETAILBLOCK from Data Block. Step 3: Create window(DEPT_WINDOW) apply subclass information as WINDOW and give the Read More..
Why personalization? Oracle Supports personalization unlike customization Personalizations are stored in tables rather than files Will not have a bigger impact when you upgrade or apply patches to the environment Can be moved easily through FNDLOAD from one instance to other Can be restricted at site/responsibility/user level Easy to disable/enable with click of a button. Read More..
Goal: Change the LOV in “Supplier Name” field in the Find “Invoice Form (AP_APXINWKB)” Navigation: Payables Manager > Entry > Invoices Double Click it to open In the first filed, Supplier Name change LOV In such a way that no one can see the TaxPayerID in LOV. It should be masked with *’s. Navigation: Help Read More..
Introduction: Data loader is an utility where you can load data into different Form Based systems especially Oracle APPS. This simple utility works by recording keystrokes that are necessary for loading data from frontend. Software be downloaded free from http://www.dataload.net/downloads/download.php Advantages: Easy to learn and use Can save time for repetitive processes Can be copied Read More..
Overview: This article will illustrate how to create or define workflow attributes, notifications, messages, roles or users, functions, processes and last but not the least, how to launch a workflow from PL/SQL. The workflow concepts are better explained using an example. Business Requirement: When an item is created in inventory, workflow needs to be launched Read More..