Blog / Category
EBS Functional
219 articles in this category
Fixing Incomplete AP Open Balance on the Oracle ECC Supplier Balance Dashboard
Introduction/Issue: Even though supplier setup in Oracle Payables was correct, the “Supplier Balance” dashboard on the Oracle Enterprise Command Center (ECC) wa…
Adding Order Date Filter to the Order Management ECC Dashboard
Introduction / Issue Users of the Order Management – Enterprise Command Center dashboard needed a way to narrow down the Orders by Order Date directly from the…
Oracle EBS OAF vs Forms Personalization
Oracle EBS OAF Personalization vs Forms Personalization – Understanding the Difference Introduction Oracle E-Business Suite (EBS) provides multiple ways to cust…
API to create party and link to the Supplier
Introduction / Issue As part of TCA, the supplier needs to be linked to the party. This API establishes the link between the Party and the Supplier. Why We Need…
Integrating Oracle EBS with Oracle Apex
Introduction / Issue Organizations often develop custom applications in Oracle APEX to extend the functionality of Oracle E-Business Suite (EBS). However, one c…
WIP Raw Material Issue with PL/SQL
Automating Oracle EBS WIP Raw Material Issue with PL/SQL Manually issuing raw materials to a discrete job through the WIP Material Transactions form works fine…
Mass Inventory Category Cleanup Using Oracle Inventory API
Mass Inventory Category Cleanup Using Oracle Inventory API In large Oracle E-Business Suite (EBS) implementations, item categories often become inconsistent ove…
Creating a BOM Item in Oracle apps R12
Creating a BOM Item Creating a Bill of Materials (BOM) item in Oracle Apps R12 involves defining the parent assembly and its components within the Bills of Mate…
API to create Quality samples and the results
Introduction/ Issue: This blog contains an API and that can be used in Oracle EBS to create Quality samples and the corresponding results. Why we need to do / C…
Journals Uploaded Twice into Oracle Apps r12
Introduction/ Issue: The Same details Journals Uploaded Twice into Oracle. Why We need to do / Cause of the Issue: User was uploaded the same GL File Twice into…
Auto Reversal Journals Setup -Fusion
Introduction/ Issue: How to define Auto reversal journal setup Purpose of Auto Reversal: Auto Reversal in Oracle Fusion is used to automatically reverse journal…
Item Where-Used Analysis Report (Excel – PL/SQL)
Introduction: This blog has the SQL query that can be used for Item where used Report in Oracle Apps R12. Cause of the issue: Business wants a PLSQL excel based…
Not able to submit the Print statement in AR
Issue :- Not able to submit the Print statement in AR Cause of the issue: Statement Periods are not defined for the New Year. How do we solve: We need to defin…
Need to delete the incorrect receipt entry from Account receivables
Introduction/ Issue: Need to delete the incorrect receipt entry from Account receivables User has mistakenly made Receipt entry by selecting wrong customer now…
Oracle PLSQL to Generate XML Tag Using Standard Functionality
declare l_ctx dbms_xmlquery.ctxHandle; l_clob clob; begin l_ctx := dbms_xmlquery.newContext(‘select * from <TABLE_NAME>’); dbms_lob.createtemporary(:g_clob,true…
Purchase Invoice GL to AP Drill down for Account Analysis Reconciliation
Introduction: This document outlines how to reconcile Oracle General Ledger (GL) and Oracle Payables (AP) for Purchase Invoice analysis by using a specific SQL…
AP: Create Accounting Completed In Warning with Offsets Error
Issue Overview: The error “The accounting program cannot create this journal line because the debit or credit that offsets it cannot be found” occurs when attem…
Fixed Asset- Split Transaction
Introduction/ Issue In this document we shall see how to perform SPLIT in Fixed asset Split Divide an asset into separate units. Use the Split Assets routine to…
How To Achieve Serial Approval Between The Groups And First Responder Wins Within A Group
We have 2 Approval Groups Approval Group-1 – Parallel Approval with First Responder Wins Employee-A Employee-B Approval Group-2 – Parallel Approval with First R…
Orcale EBS-Query to get active users along with their active responsibilities
LIST OF ALL ACTIVE USERS ALONG WITH THEIR ACTIVE RESPONSIBILITIES Introduction: This query is used to get all active users along with their active responsibilit…
Oracle EBS-Query to get Service Contract Details
Query to get the Service Contract Details Introduction: This query is used to fetch the service contract details.In this we will be passing contract_numb…
Unable To Add Vendor in Threshold Exception Setup
Introduction: Information in this document applies to any platform. Oracle Financials for India – Version 12.1.1 and later Vendor not showing up in LOV (List of…
GST: India Tax Details Form Is Not Opening For Payables Invoice
Introduction: Information in this document applies to any platform. Oracle Financials for India – Version 12.1.1 and later Due to this issue, users cannot enter…
GST: India Tax Details Form Is Not Available In Any Responsibility
Introduction: Information in this document applies to any platform. Oracle Financials for India – Version 12.1.1 and later India Tax Details is not available in…
Script to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time
Script to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time Use-Case: In general during the migrati…
Move concurrent program from One Instance to Another Instance having same name as old instance. Working as same as under old instance same responsibility and request group
Move concurrent program from One Instance to Another Instance having same name as old instance. Working as same as under old instance same responsibility and re…
Unable to apply the receipts getting Error ACC DATE NOT IN OPEN PD
Unable to apply the receipts getting Error ACC DATE NOT IN OPEN PD Error message:- This error appears when Accounting Periods are not open in Payables Please ma…
Preventive Maintenace Work Order
Breakdown Maintenance A.1 N> Enterprise Asset Management > Work Order Sub Menu > Work Order Definition >Open A.2 Click NEW for creation of New work order…
R12 Oracle General Ledger Setup
r12-oracle-general-ledger-setup
Create and Assigning the Bank Account to the Supplier in Oracle Apps 11i
This Document will explain the steps to create Supplier Bank account and assign the supplier to the Bank account in Oracle Apps 11i. In Payables, you can define…
SLA Customization to Override Accounting created by Auto Accounting
SLA Customization to Override Accounting created by Auto Accounting Review the setup for replacing the accounting generated by Auto Accounting using Sub ledger…
Oracle Internet Of Things (IoT)
Dear Readers I would like to explain more about the Oracle IoT Cloud services. Will provide continues blogs on this technology. In this block we will explore wh…
R12 – Accounting Setup Manager Checklist
r12_setup_check_list Accounting Setup Manager Checklist The following table describes the steps to create accounting setups using Accounting Setup Manager. Each…
Payment Process Request Cancelled Because No Invoices Selected.
Issue :- Invoices are being rejected at payment batches Error:- “Payment Process Request Cancelled Because No Invoices Selected.“(Print attached). Soluti…
A Cash application is being against a transaction with zero line amount basis, please contact oracle support
Issue :- Getting an error while doing CM in Oracle EBS Error:- A Cash application is being against a transaction with zero line amount basis, please contact ora…
AP Invoice Interface
Introduction: Information in this document applies to any platform. Oracle Payables – Version 12.1 and later Cause: This interface helps us to import ven…
Pay On Receipt (Evaluated Receipt Settlement)
Introduction: Oracle Receivables – Version 12.1 and later Cause: Pay on Receipt, also known as ERS (Evaluated Receipt Settlement), or Self-Billing, is an Oracle…
Re-Open a Closed Inventory Accounting Period
Introduction: Information in this document applies to any platform. Oracle Cost Management – Version 11.5.10.0 and later Oracle Inventory Management – Version 1…
Oracle Service Contract Cycle in Oracle EBS R12
oracle-service-contract-cycle-in-oracle-ebs-r12
Automatic Modifier is Not Applying to Service Contract
automatic-modifier-is-not-applying-to-service-contract
AP PO Accrual Reconciliation Process
Introduction: Oracle Payables – Version 12.1.3 and later Information in this document applies to any platform. Cause of the issue: This note provides basic step…
AutoInvoice Error: Invalid Warehouse ID (WAREHOUSE_ID)
Introduction: Oracle Receivables – Version 12 and later Information in this document applies to any platform. Cause of the issue: Getting an error when running…
Autoinvoice Import Errors with APP-AR-11526: ORA-00001: unique constraint (AR.RA_CUSTOMER_TRX_U3) violated
Introduction: Oracle Receivables – Version 12 and later Information in this document applies to any platform. Cause of the issue: Getting an error when running…
AP:Intercompany Payables Invoices Getting Rejected by Payables Open Interface Program With Error: ZX_SOURCE_DOC_MISSING
Introduction: Oracle Payables – Version 12.1.3 and later Information in this document applies to any platform. Cause of the issue: Payables Interface program is…
How to Deletion of Journal entry from Oracle ?
To Modify a journal batch that is frozen, follow this procedure: a). Setup > Journal > Sources b). Query the Journal Source c). Uncheck the Freeze Journals box…
Accrue On Receipt Flag in PO Shipments can not be Unchecked
Module: Oracle Purchasing Enter Purchase Orders Error : Can not uncheck the ‘Accrue On Receipt’ flag in PO shipments Error : Cannot update ‘Accrue On Receipt’ f…
Oracle WMS – Cross Dock Setup
X-Dock in Oracle WMS Crossdocking is the use of inbound receipts to satisfy outbound demands. You can use crossdocking to match outbound shipments to scheduled…
BMCOIN:Component And Assembly Item Attributes Invalid
Problem Description ——————- You are importing Bills of Material (BMCOIN) and receive the following error for some of your bills/items: Component and assembly it…
Unable to back order a line due to Shipping Exception Error in Order Management
Issue Summary: Unable to back order due to Shipping Exception Error. Issue Description: Unable to Ship the order due to Shipping Exception error and henc…
Employee As Supplier creation -page error
Employee as Supplier creation page error-Alternative Solution proposed Follow this process for first time creation for employee as supplier Enter expense report…
Deleting the Allocation in Oracle RMS
Description: How to delete the Allocation in Oracle RMS manually. Navigation -> RMS -> Applications -> Planning -> Allocation Search for the Allocation Id and c…
Auto Reversal Journal Setup
Auto reversal in oracle means , We will create some rules and setups for some GL journal source which will automatically reverses the GL journals for that Sourc…
Manual Item Ranging in Oracle RMS
Description: How to perform the manual Item Ranging for individual items in Oracle RMS. Navigation -> Marchandising -> Merchandising System (RMS) -> Items -> It…
Setup a new store in Oracle RMS
To Setup a new store in RMS follow the steps given below Step 1: First open the browser and type the given URL: http://shk-oratestapp02.hk.oracle.se:7783/Retail…
Unable to raise the change request on the requisition in iprocurement
Change request cannot be initiated for this requisition since none of the associated purchase orders are eligibile for change. Issue Description: Unable to rais…
Data Migration and Conversion Strategy
Data migrations generally result from the introduction of a new system. This may involve an application migration or consolidation in which one or more legacy s…
How to Change the Default Request Group in E-Business Suite Support Analyzer Bundle Menu
It is possible to change the default request group for a given Analyzer at the individual analyzer level. 1.Start the menu with “perl Menu.pl” 2,Select a Produc…
Oracle R12 AR Lockbox Query
SELECT hou.name operating_unit, xep.name legal_entity, ala.lockbox_number “NUMBER”, absa.name batch_source, cebb.bank_name, –cebb.bank_number, –cebb.bank_branch…
Oracle SQL Query To Find Square Root For A Number
Syntax: SQRT(number); Query: select SQRT(25) from dual; Output: 5
BILL CODE MAPPING IN ORACLE APPS R12
Step 1: Navigation: US AR SetupUser à Iron Source Bill Code MappingàEnter the Source->Operating Unit->Bill Code-> Modifiy the Code Combination-> Save &nb…
Assign the user ID to the responsibility
Purpose: Need to assign the responsibility which we created last sheet to the specific user ID Navigation: System Administrator > Security > User > Defin…
To Create New AutoAccounting in Oracle Apps R12
To Create New AutoAccounting in Oracle Apps R12: Define AutoAccounting to specify the general ledger accounts for transactions that you enter manually or import…
Create Oracle Chart of Accounts Setup
Create Oracle Chart of Accounts Setup We will share the detail steps to implement the chart of accounts in oracle. We will share the complete configuration deta…
Oracle Withholding tax procedure
Withholding tax: Withholding tax is an amount of which deduction takes place directly from the earning of an employee by the employer. It is paid to the…
Create the Payment Method in Oracle Apps R12
Create the Payment Method in Oracle Apps r12 The Payment Method we do create for supplier payments. As per our requirement, we can create the new payment method…
DOCUMENT SEQUENCE CREATION IN RECEIVABLES
Enable Sequential Numbering Profile Option The profile option Sequential Numbering must be enabled in order to use the Document Sequence feature. This can be se…
Create Journal on a Spreadsheet Fusion
Please make sure to open the period where you want to post the journal. Let us create the following journal on a spreadsheet- Navigation- Go to General Accounti…
Concurrent program assigned responsibilities
SELECT frt.responsibility_name, frg.request_group_name, frg.description FROM fnd_request_groups frg ,fnd_request_group_units frgu ,fnd_concurrent_programs fcp ,…
How to Create location In HRMS
Navigation:- Choose HRMS Role >> Work structures >> Location Required details Name:- Description:- Inactive date:- Address details: Address style address >> Add…
Creation a New Receivable Transaction Type
ar-transaction-type-creation-1-1 Responsibility: IM US AR SUPPORT -> Transactions -> Transaction Types Enter the Required details :- Operating Unit Legal…
TAX exception for customer
TAX Exception on customer
Income statement revaluation rule
income-statement-revaluation-rule
Form Personalization on Purchasing Receipt Standard Form
Header : How to apply Form Personalization on Purchasing Receipt Standard Form Usage of Heading : Useful in the purchasing module in receipt of goods Descriptio…
How to Enable DFF in Bank Account Transfer Page
Header : How to Enable DFF in Bank Account Transfer Page Usage of Heading : Useful in the cash management module in banking page Description of post : DFF means…
CHANGE ORDER MADE ON THE REQUISITION STUCK IN PENDING STATUS
Issue: Unable to raise a Change Request as the earlier change raised is not completed and stuck in “Pending” status Solution: Practical Guide To Troubleshoot Re…
Open Account Balances Data Manager (XLATBDMG) / Accounts Payable Trial Balance (APTBRPT) Performance Issue in R12
The “Accounts Payable Trial Balance” / “Open Account Balances Data Manager” report having severe performance issues. The rebuild it self taken more than 4 hours…
Approve and Review iExpense Reports in oracle apps
Description For both the manager approval and expense report audit/review, any credit card transactions designated as personal expenses will be listed as a sepa…
iExpense report audit/review in oracle apps
Introduction: This post detailed about the Steps required for i-expense Report audit/review in oracle application. Responsibility: – Internet Expenses Audit Man…
iExpense with Business and Personal expense validate and submit for approval
Description iExpense is an Oracle module used to report and seek reimbursement of expenses paid by employees. This powerful application empowers companies to ca…
I Expense Related Issue Release R12
While employee Submitting expense reports, he will face the issues. Which means, expense report will get stuck up with the status as Pending with System Adminis…
CROSS VALIDATION RULE EBS R12
What are Cross Validation Rules Cross Validation Rules are used to restrict the combination between the segments of a particular Chart of Accounts. As per our E…
Updating Unit List Price in Blanket Sales Agreement in R12.2
Exercise 1: Firstly we will try to create a Blanket Sales Agreement. Responsibility: Order management Super User. Navigation: Sales Agreements > Sales Agreement…
Sale Quote Configuration with Creation and Approval process in R12
Oracle Sale Quote is the system that offers excellent opportunity for the sales guys to create/follow up and play with the Sales Quotes as per the customer requ…
Price Tolerance Percentage and Price Tolerance Amount Functionality in Purchase Orders – R12.2
GOAL: Understanding the Price Tolerance Amount functionality in Oracle Purchasing. Exercise 1: Price Tolerance (%) options in Purchasing. Step 1: Raise a requis…
Order Management Under Shipment Tolerance functionality while splitting the order lines in R12.2
Remained Order Line gets cancelled after we split the Order line in shipping tranasaction form and ship the line. This document makes you understand the under s…
How to enable the MOAC parameter “Operating Unit” for a Concurrent Program
You can notice that the new field “Operating Unit” which is new field in R12 and by default is in disabled mode:- With the introduction of multi-org access cont…
Defaulting Requisition Sourcing details using Sourcing Rules
Sourcing Rules in Oracle R12: You can define sourcing rules that specify how to replenish items in an organization, such as purchased items in plants. Sourcing…
Withholding Tax
Introduction: Withholding tax (WHT) is the amount withheld by the party, making a payment to another (payee)and paid to the taxation authorities. The amount the…
UOM and Conversions
Define Units Of Measure: Define units of measure, unit of measure classes, and base units of measure for tracking, moving, storing, and counting items. You can…
Contract Purchase Agreement Creation Process in R12.2
Definition: Contract Purchase Agreements in Oracle EBS You create contract purchase agreements with your suppliers to agree on specific terms and conditions wit…
Allow Negative Quantity functionality in Shipping Process
Description: The purpose of this document is to provide some troubleshooting guide for issue where sales orders are not getting back ordered even though insuffi…
Un-Ordered Receipts in Oracle Purchasing – R12.2
Description: Unordered material consists of items that arrive at the warehouse without documentation, such as a purchase order. You must match unordered receipt…
AIM Document Specifications
Description: The Oracle Application Implementation Methodology (AIM) is a proven approach for implementation of Oracle Applications across business domains. … A…
BPA With Allow Price Override and Price Limit Functionality – R12.2
Description: Case 1: Checking Allow Price Override A price override is a feature of a retail management system that allows an authorized person to change the au…
Physical Counting in Oracle Inventory – R12.2
Description: An actual count of the goods owned by the company. The actual counts are then compared to the quantities reported on the detailed inventory records…
Order Import Issue – Item with inventory_item_id=XXXXXX is not defined in Item validation Org XXX
Discription: Approved Internal Requisitions are not converted into Internal Sales Orders. Description: In Purchasing Responsibility, an Internal Requisit…
Blanket Purchase Agreement (BPA) with Minimum Release Amount Functionality
Discription: This Post explained what the steps should follow to Create Blanket purchase agreement with Min Release amountStep 1 – Create Items: Responsibility:…
BPA – Blanket Purchase Agreement with Cumulative Pricing
Discription: Price Breaks will be applied to the cumulative quantity on all released shipments for the item. Step 1 – Create BPA: Create an Blanket purchase Agr…
ADC – Automatic Document Creation in Oracle Purchasing R12.2
Description: Automatic Document Creation (ADC) is used to create documents like Approved Quotation, BPA, and CPA. ADC will reduce the time and inputs to create…
BSA – Blanket Sales Agreement and Releases in Oracle R12.2
Description: Once a Blanket Sales Agreement is entered for a customer, multiple releases (sales orders) against the Blanket Sales Agreement are processed over a…
PO Return/Cancellation Issue – Primary quantity XX exceeds available subinventory quantity YY
Description: Issue: Buyers have created the Purchase Orders with wrong items, and they have submitted for Approval process. Then the PO has been Approved and Fu…
Trigger Enhancements in Oracle Database 11g Release 1
Description: Oracle allows you to define procedures that are implicitly executed when an INSERT, UPDATE, or DELETE statement is issued against the associated ta…
Move Order Approval Method through Planner
Description: Create move order through Planner Create a Move order for the same item and click on the approval button on the bottom of the form. Navigation: Set…
AMEX Payment Process
Description: An American Express card, also known as an “AmEx,” is an electronic payment card branded by the publicly-traded financial services company American…
PO Approval Issue – Workflow Error at “Is Document Complete” Activity
PO Approval Issue – Workflow Error at “Is Document Complete” Activity Issue: One Purchase Order (PO# 549131) have been created without the “Supplier” and “Suppl…
Account Receivables- Transaction and Receipt Creation
Introduction: Description: The word receivable refers to the payment not being realized. This means that the company must have extended a credit line to its cus…
Min-Max Planning Method in Oracle Apps – Planning Level: Organization, Source Type: Inventory, Item: Buy
Planning Level: Organization, Source Type: Inventory, Item: Buy Responsibility: Inventory Navigation: Items > Master Items. Create a item in Item Master and ass…
GENERAL LEDGER PRIMER ORACLE GENERAL LEDGER PROCESS
Description: The Oracle General Ledger is the central repository of accounting information. The main purpose of a general ledger system is to record the financi…
How to Remove Error Workflow Notifications from Work list
How to Remove Error Workflow Notifications from Work list Issue: In some of the Oracle users Work-list, will have multiple notifications with Error message “Doc…
Blind Receipts in Oracle Purchasing – R12.2
Description: Blind receiving is the process of receiving shipments in a warehouse without an order and shipment line. If you are performing blind receiving usin…
Unable to View or Add any Items in Sales Orders
Description: In the Sales Order Lines, Items are not getting displayed at ‘Ordered Item’ field. Solution: Prerequisites for solving this problem Make sure that…
Problems while creating the New Locations in Oracle R12.2
Description: Use this window to define each work location used by your enterprise. This window contains information and notified the problems, such as Inventory…
Security Hierarchy functionality Setups and Flow in Oracle Purchasing
Description: Security hierarchies let you control who has access to certain documents. For example, you can create a security hierarchy in which only you and ot…
Cascade Receipts in Oracle Purchasing – R12.2
Description: The Cascade function facilitates the distribution of a given quantity of an item and UOM from a single supplier across multiple shipments and distr…
Item Code as Qualifier and Percentage Discounts based on Item Code
Item Code as Qualifier in Advanced Pricing Description: A line level qualifier based on item code is required to identify the eligible line to provide the requi…
Express Receipts in Oracle Purchasing – R12.2
Description: The specific function is a quick method of entering receipts and receiving transactions. This function is available in the Receipts window if you h…
Back to Back Sales Order Cycle Setups and Process Flow in R12.2
Description: This Post shows how to perform Back to back Orders in oracle. Step1: Create Transaction type. Use Order Fulfillment flow as Order Flow – Generic. U…
Substitute Receipts in Oracle Purchasing – R12.2
Substitute Receipts Description: The Substitute Receipts Report lists all or specific substitute receipts. To prevent disruption in your receiving process, Purc…
Discrete Jobs End to End Cycle with Cost Roll-up in Standard Cost Organization in R12.2
Description: An organization’s operations include the buying and selling of products and services. Items can represent the products and services that are purcha…
Bills Of Materials Setup Document with Costing
Introduction: A bill of materials (BOM) is an extensive list of raw materials, components, and assemblies required to construct, manufacture, or repair a produc…
Datafix Script to clear the RCV stuck pending transactions for Receipts
Introduction: While we are receiving or correcting a PO, sometimes the transactions get stuck without Processing due to delay in running receiving transaction p…
Oracle work in process setup document in R12.2
Introduction: Oracle Work in Process is a complete production management system. Work in Process is part of Oracle Applications, an integrated suite of business…
iProcurement Setup Document and it’s basic flows in R12.2
Introduction: Oracle® iProcurement is the self-service requisitioning application influences employee purchasing. It is a key component of Oracle Procurement, t…
White Paper on Advanced Approval using Approval Management Engine – AME
Introduction: Oracle Approvals Management (AME) is a self-service Web application that enables users to define business rules. Oracle Approvals Management enabl…
RMA – Return Material Authorizations in R12.2
Description: Order Management allows the customers to return the goods to you. OM also enables you to authorize the return of your sales orders as well as sales…
IR & ISO – Internal Sales Order Cycle with Setup Steps in R12.2
Definition: Internal Requisition/Internal Sales Order provide the mechanism for requesting and transferring material from one inventory organization to other in…
Oracle Order Management Setup Document in R12.2
Description The Oracle Order Management Application provides many flexible features enabling you to set up your system to begin processing order information. Yo…
Inventory Module Setup in Oracle EBS R12.2
Description An Oracle Inventory Module is a facility where you store and transact items. Before you can use Oracle Inventory, you must define one or more invent…
Back 2 Back and Dropship Order Process in Oracle R12.2
DescriptionL In Back to Backorder, the shipment process is also completed through OM as a standard order after the item is received against a PO This order type…
MANUAL SHIP CONFIRM PROCESS IN ORDER MANAGEMENT ORACLE EBS R12.2.2
Concept: Once the pick release and pick confirm process is over, the details will be assigned to deliveries. Deliveries will be assigned to trips and tri…
Oracle WIP_Repetitive Schedules_Setup Steps and Process Flow in R12.2
Introduction: Work in Process module in Oracle E-Business Suite is used to record manufacturing transactions for discrete Manufacturing. An Assembly or subassem…
Enable Oracle apps Diagnostics for certain users
Introduction: Oracle Diagnostics Framework improves the supportability of your E-Business Suite Applications throughout its life cycle. Ora…
Billing Process in Brazil
Introduction: The billing process in Brazil has the following steps as there are localizations and also the government involved in approving the sequence number…
Brazil Electronic File Transfer in Receivables
Introduction: Companies in Brazil use bank services to collect customers. The Brazilian Electronic File Transfer for Receivables (CLL F034) provides the functio…
Electronic File Transfer in AR – Brazil – Technical Information
Introduction: Companies in Brazil use bank services to collect customers. The Brazilian Electronic File Transfer for Receivables (CLL F034) provides the functio…
Bill of Entry Process after GST Implementation
Description: BOE is a legal document in a prescribed format that needs to be submitted to the Customs Authority by the importer or his authorized agent. BOE con…
Approval Management Engine in EBS
Description: Oracle Approvals Management (AME) enables you to define business rules governing the process for approving transactions in Oracle applications that…
GST RETURN TO VENDOR (RTV)
Description Return to Vendor(RTV)is used to return the materials to the supplier. If buyer had made PO for certain items and after receiving at inspection secti…
GST Return Material Authorization(RMA)
Description A Return Material Authorization (RMA) or Sales Return is the process of a seller accepting a purchased item back from the consumer. In turn, the cus…
GST Sales Order Creation
Description Suppliers are responsible for issuing invoices and charging GST at a specific rate of tax on the goods and services they provide to the customers. T…
GST with Internal Requisition and Internal Sales Order(IRISO)
Description IRISO Stands for Internal Requisition Internal Sales Orders. IR ISO is used to transfer the material from one inventory organization or warehouse to…
How to add expense items type in expense template
Add Expense type in Expense template Navigation AP setup user à Setup à Invoice à Expense Report Templates Name:Cost of Sales Emp T&E Expense category:Miscellan…
REVERSE CHARGE MECHANISM
Description Reverse charge is a mechanism where the recipient of the goods and services is liable to pay GST instead of the supplier. Typically, the supp…
Rest Web Service Call in Oracle Forms
Description: Representational state transfer (REST) is a software architectural style that defines a set of constraints to be used for creating Web services. ……
Purchase Order Creation with GST
Description A Purchase order is a commercial document and first official order issued by the buyer to the supplier, indicating types, quantities, and agreed pri…
Creating Withholding Tax Invoice in Oracle Fusion Applications
Description Oracle Fusion Tax can automatically create withholding tax invoices, or you can perform this task manually. To create withholding tax invoices autom…
Manual AP Invoice Creation and Cancellation with GST
Description: Please find the below steps for Manual AP Invoice Creation and Cancellation with GST Step 1:Responsibility: India Local Payables Navigation: Invoic…
Creating the Invoice in Oracle Fusion Applications
Description In Fusion to create the ap invoice, we have different navigation as compared to EBS R12. Fusion has given new features in Oracle fusion for the Paya…
Invoice Payment in Oracle Fusion Applications
Description An invoice is an itemized list of goods shipped or services rendered, with an account of all costs. Oracle Fusion Payables lets you capture all the…
Creating the Customer in Oracle Fusion Applications
Description To create a customer, you must specify at least a customer name, Account Address Set, account site address, and business purpose. In the Account Inf…
iExpenses – change the lable name in template
From Sysadmin Responsibility: Navigate to the Functional Administrator responsibilityà Personalization. Provide Document path like “/oracle/apps/ap/oie/WebUI/OI…
How to Prepare the OTBI Reports in Oracle Fusion
Description OTBI is a set of pre-seeded yet customizable analysis structures that Oracle Applications users can access to create ad hoc reports, dashboards, and…
Auto Lock Box – Basic Concepts and Implementation Steps
Description : => Lockbox is a service offered by banks to companies in which the company receives payments from their customers by mail to a post office box, an…
How to Prepare the BI Reports in Oracle Fusion Applications
Description Oracle Business Intelligence Publisher (BI Publisher, formerly XML Publisher) is an enterprise reporting solution that streamlines report and form g…
How to get the DBC file for a particular instance
Description: DBC file is simply a database format structured around CAN Messages and Signals. The DBC format is proprietary, but a number of online DBC wikis de…
Problems while creating the New Locations in Oracle R12.2
Description: Use this window to define each work location used by your enterprise. This window contains information and notified the problems, such as Inventory…
Order Management Under Shipment Tolerance functionality while splitting the order lines in R12.2
Description: Oracle Order Management provides you with the ability to capture shipping tolerance levels for over and under shipments recorded during ship confir…
Lockbox – Error Handling
intorduction this post is about to Submit postQuickcash for records struck in the interfac Lockbox – Error Handling Submit postQuickcash for records struck in t…
Oracle Forms – Dynamic Message Tool Tip
Introduction This Post is about to oracle forms-Dynamic Message Tool Tip in oracle EBS-R12 Multiple tooltip message in single text field Step 1:- Create…
Query to fetch Customer Statement of Account Details
Description: Query to fetch Customer Statement of Account Details SELECT rc.customer_name “Customer_Name”, rc.customer_number “Customer_Number”, hou.NAME operat…
AR Receipt Distribution Query: AR XLA GL
Description: The below process explains the responsibilities of AR Receipt distribution query on AR XLA GL SELECT glcc.segment1 co, glcc.segment2 loc, gl…
Period End Processing of Oracle Inventory and Cost management in oracle apps
1. Description Oracle Inventory provides the features you need to summarize costs related to inventory and manufacturing activities for a given accounting perio…
Query to get employee details who are not submitted the iExpense details for approval
Query to get employee details who are not submitted the iExpense details for approval Introduction This post is about to get employee details who are not…
Open Purchase Order Details(Standard Po)
Introduction This post is about to Open Purchase Order Details(Standard Po) in Oracle EBS R12. Script to Open Purchase Open Details (Standard PO) …
Call Oracle package in Oracle BI Publisher 10g
Introduction This Post is about Oracle BI Publisher is just a reporting tool. From which we can download excel, CSV, XML, RTF, PDF reports. In which we can use…
Oracle WIP_Repetitive Schedules_Setup Steps and Process Flow in R12.2
Repetitive Manufacturing in Work in Process Table of Contents? What is Repetitive Manufacturing? Setups required to perform Repetitive Manufacturing Transaction…
ORACLE WORK IN PROCESS SETUP DOCUMENT IN R12.2
Table of Contents? STEP 1: Setup Prerequisites Oracle Inventory Oracle Bills of Material Oracle Engineering Oracle Cost Management Oracle Project Manufacturing…
Datafix Script to clear the RCV stuck pending transactions for Receipts
Scripts used for clearing the RCV stuck pending transactions Scenario: While receiving or correcting a PO, some time the transactions get stuck with out Process…
Bills Of Materials Setup Document with Costing
PROFILE OPTIONS IN BILLS OF MATERIALS Profile Option User System Administrator Requirements User User Resp App Site Required? Default Value BOM: Check for Dupli…
Discrete Jobs End to End Cycle with Cost Roll-up in Standard Cost Organization in R12.2
STEP 1: CREATE ITEMS Responsibility: Inventory Navigation: Items > Master Items Select the Organization as “M1 – Seattle Manufacturing“ Create the below items;…
Blanket Sales Agreement with Approvals and Release in Oracle R12.2
Setups Required: 1. Transaction Type: Create an order transaction type. Sales Document type should be “Sales Agreement“. Fulfillment flow: Sales Agreement – Gen…
Back to Back Sales Order Cycle Setups and Process Flow in R12.2
Back to Back Orders in Oracle Setups Required: Step1: Create Transaction type. Use Order Fulfillment flow as Order Flow – Generic. Use the Line flow and validat…
Item Code as Qualifier and Percentage Discounts based on Item Code
Item Code as Qualifier in Advanced Pricing Business Case: A World leading soft drinks manufacturer in Vietnam likes to implement Advance Pricing to incor…
Move Order Approval Process in R12.2
Move Order Approval Method through Planner. Before we learn about Move order, let us check the only setup for the move orders in organization Parameters. Create…
Security Hierarchy functionality Setups and Flow in Oracle Purchasing
Using Security Hierarchies Security hierarchies let you control who has access to certain documents. For example, you can create a security hierarchy in which o…
Unable to View or Add any Items in Sales Orders
&nbs…
Table of ContentsSupplier Creation in Oracle Pa…
Table of Contents Supplier Creation in Oracle Payables Overview of Suppliers : Supplier Creation procedure: A) General information: B) Address Book Page: C) Con…
Withholding Tax
Table of content: 1 Background ………………………………………………………………………………………………………… 2 1.1 Definition ……………………………………………………………………………………………………… 2 1.2 Purpose ………………
iProcurement Setup Document and it's basic flows in R12.2
iProcurement Setup Document Mandatory Setups for iProcurement: Profile Options Shopping Category Creation Category Hierarchy Top Category (Browsing Category) –…
White Paper on Advanced Approval using Approval Management Engine – AME
“If you want something new, you have to stop doing something old”- as Peter F. Drucker says many organizations are stop doing old and keep innovating new techno…
How to enable the MOAC parameter “Operating Unit” for a Concurrent Program
You can notice that the new field “Operating Unit” which is new field in R12 and by default is in disabled mode:- With the introduction of multi-org access cont…
Defaulting Requisition Sourcing details using Sourcing Rules
Sourcing Rules in Oracle R12: You can define sourcing rules that specify how to replenish items in an organization, such as purchased items in plants. Sourcing…
UOM and Conversions
Define Units Of Measure: Define units of measure, unit of measure classes, and base units of measure for tracking, moving, storing, and counting items. You can…
Contract Purchase Agreement Creation Process in R12.2
Definition: Contract Purchase Agreements in Oracle EBS You create contract purchase agreements with your suppliers to agree on specific terms and conditions wit…
Sale Quote Configuration with Creation and Approval process in R12
Oracle Sales Quote – Approval – Setup Oracle Sale Quote is the system that offers excellent opportunity for the sales guys to create/follow up and play with the…
Allow Negative Quantity functionality in Shipping Process
Purpose: The purpose of this Document is to provide some troubleshooting guide for issue where sales orders are not getting backordered even though insufficient…
Price Tolerance Percentage and Price Tolerance Amount Functionality in Purchase Orders – R12.2
GOAL: Understanding the Price Tolerance Amount functionality in Oracle Purchasing. Exercise 1: Price Tolerance (%) options in Purchasing. Step 1: Raise a requis…
Order Management Under Shipment Tolerance functionality while splitting the order lines in R12.2
Remained Order Line gets cancelled after we split the Order line in shipping tranasaction form and ship the line. This document makes you understand the…
Updating Unit List Price in Blanket Sales Agreement in R12.2
Updating Unit List Price in Blanket Sales Agreement Exercise 1: Firstly we will try to create a Blanket Sales Agreement. Responsibility: Order management Super…
Group Shipments functionality of Autocreate in R12.2
This document provides information on Group Shipments functionality for Auto created Purchase Documents. New feature in R12.2 + related to Group Shipments…
AIM Document Specifications
AIM Document Specifications: 1. Business Process Architecture (BP) 2. Business Requirements Definition (RD) 3. Business Requirements Mapping 4. Application and…
Problems while creating the New Locations in Oracle R12.2
Problems while creating the New Locations in Oracle R12 ERROR DETAIL: Not able to Create the new Locations as well as Update the existing Locations in Oracle. E…
General Ledger Primer Oracle Genera..
GENERAL LEDGER PRIMER ORACLE GENERAL LEDGER PROCESS 10/8/2014 Srinivasa Ramanujam Contents ? Manual Journal Entry Journal Approval Process Daily Rates Entry Cal…
AMEX Payment Process
DOYEN SYSTEMS PRIVATE LIMITED AMEX PAYMENT PROCESS CONFIG AND TESTING DOC Doyen 11/20/2014 [Type the abstract of the document here. The abstract is typically a…
Inventory Module Setup in Oracle EBS R12.2
What is Oracle Inventory? An Oracle Inventory Module is a facility where you store and transact items. Before you can use Oracle Inventory, you must defin…
IR & ISO – Internal Sales Order Cycle with Setup Steps in R12.2
Definition: Internal Requisition/Internal Sales Order provide the mechanism for requesting and transferring material from one inventory organization to other in…
RMA – Return Material Authorizations in R12.2
Return Material Authorizations in OM Order Management provides sophisticated tracking of your return material authorizations (RMA). Returns from a customer occu…
PO Return/Cancellation Issue – Primary quantity XX exceeds available subinventory quantity YY
Issue and Resolution Document for PO Returns and Cancellation Issue 1. Issue: Buyers are created the Purchase Orders with wrong items and they have submitted fo…
BSA – Blanket Sales Agreement and Releases in Oracle R12.2
Definition: Blanket Sales Agreements are used when you have specific characteristics related to a purchasing agreement between a customer and a supplier. These…
Back 2 Back and Dropship Order Process in Oracle R12.2
This order type applies when customer orders a product which you do not stock or manufacture. In turn customer places the order, you place the order with suppli…
ADC – Automatic Document Creation in Oracle Purchasing R12.2
Concept: ADC is created for the documents like Blanket Purchase Agreement, Approved Quotes, and Contract Purchase Agreements to Release the Purchase Orders auto…
Physical Counting in Oracle Inventory – R12.2
PHYSICAL COUNTING IN ORACLE EBS R12.2 Counting is used to verify the System On hand Quantity with Actual (Physical Qty) Quantity of the item and perform the adj…
BPA With Allow Price Override and Price Limit Functionality – R12.2
Allow Price Override and Price Limit in BPA Case 1: Checking Allow Price Override Step 1 – Create and Approve BPA: Responsibility: Purchasing. NAV: Purchase Ord…
Un-Ordered Receipts in Oracle Purchasing – R12.2
Un-Ordered Receipts Allow Unordered receipts allows to receive the goods without a PO. But these goods can only sent to receiving area and not for the sub-inven…
Substitute Receipts in Oracle Purchasing – R12.2
Substitute Receipts This option can be used when we can receive the substitute item. Means we can receive item B, where as we ordered item A. Firstly for this w…
Express Receipts in Oracle Purchasing – R12.2
Express Transactions The express transaction function is a quick method of entering receipts and receiving transactions. Step1: Create a PO. Create a purchase o…
Cascade Receipts in Oracle Purchasing – R12.2
Cascade Receipts The Cascade function facilitates the distribution of a given quantity of an item and UOM from a single supplier across multiple shipments and d…
Blind Receipts in Oracle Purchasing – R12.2
&nbs…
PO Approval Issue – Workflow Error at "Is Document Complete" Activity
PO Approval Issue – Workflow Error at “Is Document Complete” Activity Issue: One Purchase Order (PO# 549131) have been created without the “Supplier” and “Suppl…
BPA – Blanket Purchase Agreement with Cumulative Pricing
Cumulative Pricing in Blanket Purchase Agreement Cumulative: Price Breaks will be applied to the cumulative quantity on all released shipments for the item. Ste…
Blanket Purchase Agreement (BPA) with Minimum Release Amount Functionality
Minimum Releases in Blanket Purchase Agreement Step 1 – Create Items: Responsibility: Purchasing Super User Navigation: Items > Master Items. Create two differe…
How to Remove Error Workflow Notifications from Work list
How to Remove Error Workflow Notifications from Work list Issue: In some of the Oracle users Work-list, will have multiple notifications with Error messag…
Min-Max Planning Method in Oracle Apps – Planning Level: Organization, Source Type: Inventory, Item: Buy
Planning Level: Organization, Source Type: Inventory, Item: Buy Responsibility: Inventory Navigation: Items > M…
Min-Max Planning Method with various Scenarios in Oracle Apps
Credit Check Functionality in Order Management
1) Overview: The ultimate goal of Credit Management processes is to minimize the financial risk that your organization assumes as a result of day-to-…
How to Resolve the Shipping Exception Issue – Schedule Date has been Postponed – Exception Name "WSH_CHANGE_SCHED_DATE"
Issue: Sometimes, we may change the Schedule Ship Dates in the Sales Orders. When we try to do the Ship Confirm for those changed orders, system will not allow…
How to Process the Stuck Purchase Orders with an Pending "Respond to Changes" Action
Issue: Requisitions are created using either from the Core Purchasing or Internet Procurement responsibilities. Then the requisitions will be converted into Pur…
Receiving Transaction Processor errors out with error numbers RVTTH-445, RVTBM-008 & RVTBM-120
RECEIVING TRANSACTION PROCESSOR ERROR ISSUE Title: Receiving Transaction Processor errors out with error numbers RVTTH-445, RVTBM-008 & RVTBM-120 Issue Descript…
PO Workflow Error – Document Manager Failed with Error Number 3 while processing Standard Purchase Order XXXXXX
Reset a Purchase Order Statuses From In Process or Pre-Approved To Incomplete/Requires Reapproval Title: Document Manager Failed with Error Number 3 while proce…