-
Workflow tutorial
Overview: This workflow tutorial will illustrate how to create or define a new workflow from scratch including 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,…
-
Display and change images dynamically in XML publisher
This article discusses about how to display images dynamically using XML Publisher. COMPANY NAME ADDRESS REPORT TITLE CF_PRINTED 1. 2. 3. Customer No.. Customer Name Address Tax Category Number Name Address Tax Category Note :- We have to place Dummy Images on template like in above template. 1)In this option we placed image path Directly…
-
Drop Ship Cycle
The below are the steps involved in the Drop Ship Cycle: Before you create an order, you have to perform some setups in order to drop ship, which are listed in the below mentioned article “Drop Ship Setups”: Drop Ship Setups 1. Create Sale Order 2. Book Sales Order 3. Check Status 4. Progress Sales…
-
Handling multiple layouts in Xml Publisher (.Rtf)
Steps for handling multiple layouts in XML. After developing the Report definition file (.rdf) we have to add one more parameter like follows. This parameter value should be assigned to Place holder column(CP ) like follows We can assign Parameter value either after parameter form or before report Triggers. In this we assigned in Before…
-
Sales Order Holds in OM
Application: Order Management Process: pply Sales Order Hold Objectives: To create Sales Order Holds. To apply Sales Order Holds. To view Sales Order Holds. Prerequisites: Hold Types have been defined. Workflow items and activities have been defined. Transaction Order and Line Types have been defined. Responsibilities have been defined. Release Reasons have been defined. For…
-
Return Material Authorization (RMA) in Order Management
The following topics will be discussed in this article: Overview of RMA Creating a New Return (RMA with Credit) Creating a Return using the Copy Function (RMA with Credit) Creating a New Return (RMA no Credit) Creating a New Return (RMA Credit Only) RMA Receipt Viewing the status of RMA Close RMA Pre-requisites: Return Order…
-
Setting up Pricing Agreements
This article will show how to setup pricing agreements. Note: The Agreement Field does not display by default on the Order Management Sales Orders Order Information window. Folder technology Navigation: Pricing > Pricing Agreements The Pricing Agreements Agreement Tab: Enter the Following: Agreement Name: Enter the name of the agreement Agreement Number, Revision: Enter…
-
HRMS: Define Organization Hierarchy
The following are the setups relating to Core HR. Creating Location: We can create locations using the Work Structures => Location window. Create Business Group We can use either the start up BG or we can create a new BG. The start up BG has a default legislation code of US and has a default…
-
HRMS Fast Formula
What is Oracle Fast Formula? Oracle Fast Formula is a simple way to write formulas using English words and basic mathematical functions. You can use information from your database in formulas without learning the database structure or a programming language. You can use Oracle Fast Formula to: 1.Calculate your payrolls 2.Define the rules for PTO…
-
Position Based Approval Hierarchy in Purchasing
Approval hierarchies let you automatically route documents for approval. There are two kinds of approval hierarchies in Purchasing: position hierarchy and employee/supervisor relationships. If an employee/supervisor relationship is used, the approval routing structures are defined as you enter employees using the Enter Person window. In this case, positions are not required to be setup. If…
-
Payment batches in Payables 11i
Introduction: We will see how we can use Payments Batches to create payments for multiple invoices that meet the selection criteria you specify. Process: The below diagram illustrates the sequence of steps to be followed to complete the payment batch. Each of the steps is initiated from the Payment Batch Actions window. 1.…
-
Procure to Pay Cycle
Diagrammatic representation of Procure to Pay cycle. Watch the procure-pay-cycle-video Article with 11i screen shots: Procure to Pay Cycle 11i Query: Procure to Pay Cycle Query 1) Create Requisition: Requisition is nothing but a formal request to buy something (like Inventory material, office supplies etc) needed for the enterprise. Only an employee can create…
-
Order to Cash Process
order to cash process steps can be listed as below Enter the Sales Order Book the Sales Order Launch Pick Release Ship Confirm Create Invoice Create the Receipts either manually or using Auto Lockbox ( In this article we will concentrate on Manual creation) Transfer to General Ledger Journal Import Posting Watch o2c Video: Order…
-
Importing Blanket Purchase Agreements(BPA)
In this article we will see what a Blanket Purchase Agreement is and how we can import them along with the price breaks. Overview of Blanket Purchase Agreements: You create blanket purchase agreements when you know the detail of the goods or services you plan to buy from a specific supplier in a period, but…
-
Oracle iExpenses Overview
Using Oracle iExpenses, employees can enter and submit expense reports. There is a Workflow process that is initiated behind when an expense report is submitted which automatically routes expense reports for approval. Oracle Internet Expenses integrates with Oracle Payables to provide quick processing of expense reports for payment. This article includes these topics: Process Overview…
-
Delimited Report Output using Report Builder
Overview: In this tutorial, we will see how to customize the existing standard Oracle report to get a delimited output file instead of the regular layout. Most business users prefer delimited report output as it can easily be imported into Excel where they can manipulate and perform calculations on the data easily. Report Builder is…
-
Customizing Self Service Applications using Personalizations
Release 11.5.10 provides a feature called Personalize Page, which gives us the ability to customize the look and feel of the Self Service Applications. Setting the Profile option Personalize Self-Service Defn to “Yes”, enables this feature. If it is set to “No”, the Personalize Page link will not be seen prohibiting you from customizing the…
-
Oracle iExpense Reporting
By Haritha gogineni In this article, we will cover the below topics related to Oracle iExpense Create a New Expense Report Itemize an Expense Line Withdraw an Expense Report Update an Existing Report Delete an expense report View the Approval Status of an existing Expense Report Creating an Expense Report in iExpense: Creating 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…