erpSchools

Category: Sysadmin and AOL

  • Value set security feature in 12.2 and above versions

    Oracle has introduced a new value set security feature  in 12.2 version which will disable accessing value set values to all users. This is default functionality and Business users are expected to give permissions either to specific value sets or all value sets to specific users or group of users. Let’s backup a little bit…

  • Register PL SQL stored procedure in Oracle Apps

    Register PL SQL stored procedure in Oracle Apps: You have a PL/SQL procedure in your database and you want the user to be able to execute it from Oracle Apps front end. To do so, we have to register the procedure in Oracle Apps. Now let’s see how to do that. Steps to register a…

  • Responsibility in Oracle Apps

    Responsibility in Oracle Apps: A responsibility lets you control what (forms / reports ) a user can access when logged into it. A responsibility will have one main menu. Under that main menu you can have other sub menus or functions. Each of these responsibilities can be assigned to various user accounts. Menu is assigned…

  • Menu in Oracle Apps

    Menu in Oracle Apps: Menu is nothing but a logical or hierarchical listing of functions (forms) so that the user can easily navigate through the forms once he is in a responsibility. Every responsibility will be assigned only one main menu. Under that main menu, you can have either have other sub menus or functions.…

  • SQL Validation used for profile options List of Values

    SQL Validation used for profile options List of Values: Before proceeding further, we recommend you to go through our article on Profile Option in Oracle Apps where we have covered how to create a profile option and assign a value (user enters free text as value) to it. Many a times, you need to a…

  • Register Custom Tables in Oracle Apps

    Register Custom Tables in Oracle Apps: Say you have a custom table called “ERPS_EMPLOYEE” with columns EMP_ID, EMP_NAME and EMP_TYPE in your database.  You need to create a  TABLE type Value set  that pulls up information from  this table as LOV. If you give in the custom table name in “TABLE NAME” field in the…

  • Profile Option in Oracle Apps

    Profile Option in Oracle Apps: Profile Option values control the behavior of Oracle Apps, in other words they determine how Oracle Apps should run. The value for a profile option can be changed any time. For Example we have a profile option called MO: Operating Unit. Assigning a value to this profile option will determine…

  • Scheduling concurrent program in Oracle Apps

    Scheduling concurrent program in Oracle Apps: Many times you may want to run a concurrent program at a specific time on some specific days of a week. Remembering the schedule and submitting the programs manually may not be feasible all the times. Oracle E- Business suite conveniently let’s you schedule a program to run on…

  • Assigning Operating Unit to a Responsibility in 11i and R12

    In Oracle Apps 11i we can assign only one operating unit to single responsibility but where as in R12 we can assign multiple operating units to a single responsibility to avail MOAC (Multi Organization Access Control) feature. Oracle Apps 11i: Set a profile option called ‘MO: Operating Unit’ to assign operating unit to responsibility Navigation:…

  • Value Set: Security Type

      Enabling security on value sets helps us to restrict values on concurrent program parameters. Business Scenario: Let’s say that we would like define Apple products with their codes in a independent value set which will be attached to a concurrent program as a parameter. 100: iPod Product Family             (Note: This is not a product…

  • Value Sets: Independent, Dependent, Table

    To demonstrate different types (Independent, Dependent and Table) of value set let’s first define a concurrent program. 1. Define Executable. Navigation: Application Developer > Concurrent > Executable Enter Information as below Note: You don’t really need to have PLSQL package defined for this demo. Save it. Navigation: Application Developer > Concurrent > Program Enter Information…

  • USER Management | Role Categories | Roles | Indirect Responsibilities

    User Mangement Application helps system administrators to assign or un-assign a responsibility for multiple users at a time. Yes, We don’t have to manage individual user accounts for assigning the responsibilities if you are using User Management Application. In Oracle Applications, Traditional method of assigning a responsibility to a user is from System Administrator >…

  • Dependent Parameters in Concurrent Program using Special Value Set

    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…

  • FNDLOAD to transfer AOL Objects from one instance to other

    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…

  • Report Registration and add it to request group

    Overview: Develop a report to register as a concurrent program Create Executable: Link it to Report file(.rdf) 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 –> Go to Application Developer Responsibility…

  • Launch Concurrent Program From Menu

    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…

  • Oracle Attachment Functionality

    About Attachments: Attachment in Oracle Application What is attachment in oracle application? The attachments feature in oracle application enables users to link unstructured data, such as images, word-processing documents, spreadsheets, or text to their application data. For example, users can link images to items or video to operations as operation instructions. Where to find an…

  • Descriptive Flexfields

    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…

  • Usage of $FLEX$ and $PROFILE$ In concurrent program parameters

    This article illustrates the usage of $FLEX$ and $PROFILE$ 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…

  • Make DFF Segment readonly through Security Rules

    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…

  • Enable Trace for a concurrent program

    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…

  • Email the output of a concurrent program as Attachment

    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 program…