erpSchools

Category: Articles

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

  • AutoInvoice Grouping Rules

    AutoInvoice Grouping Rules: Auto Invoice Grouping rules let you specify what attributes must be identical for lines to appear on an Invoice. In other words, these grouping rules you specify will help the Auto Invoice Interface to identify which set of lines should be grouped as one Invoice /credit Memo /Debit Memo. You have TWO types…

  • Folders in Oracle Forms

    Folders in Oracle Forms: Folders let you do the below: 1.Control how you want the data to be displayed in the form meaning what columns should be displayed, what should be width of the columns, sequence of the columns, what should be the prompt for each of these columns etc. 2. Control what data should…

  • 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.…

  • Guarantee in Oracle Receivables

    Guarantee in Oracle Receivables: Oracle Receivables supports two types of commitments with our customers: 1. Deposit: Customer commits to buy certain goods from us within a certain time range. He pays the amount upfront and we use it until we run out. 2. Guarantee: Customer commits to buy a certain dollar amount from us over…

  • Deposits in Oracle Receivables

    Deposits in Oracle Receivables: Oracle Receivables supports two types of commitments with customers: 1. Deposit: Customer commits to buy certain goods within a certain time range and pays the amount upfront. 2. Guarantee: Customer commits to buy a certain dollar amount over a specified time period. We track their sales to see if they actually…

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

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

  • Prepayments in Oracle AP

    Prepayments in Oracle Payables: Normal Payables cycle is that you first create invoice when you get one from you supplier for the goods that you have bought and then make a payment of the amount in the invoice to the supplier. But there are scenarios where the supplier requests for an advance when you order…

  • Chargebacks in Oracle Receivables

    Chargebacks in Oracle Receivables: You create Chargebacks when you wish to close the original invoice which the customer has partially paid and create a new invoice for the remaining amount that the customer has to pay yet. For example, your customer sends payment of $75 for a $100 invoice. You can apply the receipt to…

  • Top Ten List in Oracle Apps

    Top Ten List in Oracle Apps: You can add forms that you use frequently to your Top Ten List. Once the form is added to Top Ten List, just by clicking on it, takes you to that form instead of traversing through all the menu options. You can create a different top ten list for…

  • Table Suffixes in Oracle Apps

    Table Suffixes: You have lot of tables ending with different suffixes in Oracle Apps database. Did you ever wonder what these denote? Listed below are the different table suffixes and what they mean. _ALL: Table ending with _ALL means it stores data related to multiple organizations. Such tables definitely will have a column called org_id…

  • OAF Architecture

    OAF Architecture: 1. Model View Controller: OA Framework is based on the industry-standard J2EE MVC design pattern. The MVC architecture is a component-based design pattern with clean interfaces between the Model, View, and Controller. The Model is where the application implements its business logic. The View is where the application implements its user interface and…

  • Register OAF Page in Oracle Applications

    Register OAF page in Oracle Applications We have already seen in our earlier articles about how to configure the OAF and steps to build Hello World page using OAF. In this Tutorial we are going to see how to attach a Hello World Page to Oracle E-Bussiness Suite. 1. Move OAF files to Oracle Apps Server…

  • Invoices and Credit Memos in Oracle AR

    Invoices and Credit Memos in Oracle AR: Glossary: Invoice: A document that will convey how much the customer has to pay for the goods and services he has bought and due date for paying the amount. Credit Memo: Negative amount to decrease the balance of the invoice. Balance of Invoice: The amount that the customer…

  • Oracle MSCA Label Printing

    Oracle MSCA Label Printing: By using High technology Printers like Zebra Printer (Zebra 810i), we can eliminate usage of third party tools like Loftware. Pre-Requisite: Organizations should be WMS enabled. Approach: Oracle WMS sends the XML directly to the printer. The label printer is capable of receiving XML that meets Oracle’s label specification and merges…

  • Inter-organization Transfer

    Business Requirement: Transfer material from Seattle Organization to Boston Organization. There are two ways to transfer material from one organization / warehouse to other organization. 1. We can transfer material across inventory organization through Internal Requisition / Internal Sales Orders 2. Inter-Organization Transfer from Inventory Application. Navigation: Inventory Responsibility > Transactions > Inter – Organization…

  • Inventory Miscellaneous Transactions

    As the name implies “Inventory Miscellaneous Transactions” are used for Miscellaneous reasons. Primarily we create Miscellaneous Receipts and Miscellaneous Issues to adjust the inventory on-hand quantity when actual quantity doesn’t match with the quantity represented by ERP system, Oracle Apps. Business Scenario – 1: Actual quantity available in warehouse is more than on-hand quantity in…

  • AP: Payment Manager Process in R12

    Payment Batch lets you create payments for multiple invoices that meet the criteria you specify in a single shot. In R12, it lets you select invoices with different Operating units, Currencies in a single batch. Note: The process of creating payment batches and processing payments in R12 has changed completely when compared to 11i. 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…

  • Procure to Pay Cycle Video

    P2p process with R12 screen shots: procure-to-pay-oracle-r12 Article with 11i screen shots: Procure to Pay Cycle 11i Query: Procure to Pay Cycle Query

  • OAF Hello World Example

      Please refer to “3 Steps to setup jDeveloper for OAF Projects” If you haven’t setup your jDeveloper yet. This article, “oaf hello world example” will help you learn how to Develop Hello world page OAF Page. Create new OA Workspace and Project Set Project properties Create Application Develop OAF Helloworld page Run OAF Page…

  • Back to Back Order Process

    Steps involved involved in back to back order process in oracle apps Enter Sales Order Book Sales Order Progress Sales Order to create Supply Order Requisition Import Create Purchase / Inventory Receipt Pick Release Sales Order Ship Confirm   Navigation: Order Management Super User >> Orders, Returns >> Order Organizer   Enter Customer name and…

  • Order to Cash cycle Video

    Note: Firefox is partially supported to view this video. You can view the video in IE, Chrome, Safari.

  • Assemble to Order Cycle Video

  • Oracle Apps Images

        [fbphotos id=307672549329650]

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

  • Technical Terms in Oracle Apps explained through real time example

    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…

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

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

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

  • Report Creation through wizard

    Objective: Create a report using wizard in Report Builder. Open Report Builder This is the first screen you will see. Select the first option “Use the Report Wizard” and click OK. Click Next Enter Report Title: erpschools_sample_report and then select “Tabular” option. As per name “Tabular” our output will be organized in a tabular way (rows and…

  • Shell Script Tutorial

    Topics: 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 ERPS_DEMO.prog…

  • XML Publisher

    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…

  • Forms Personalization Tutorial

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

  • Change displayed data in LOV using Forms Personalization

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