Oracle EBS R12: User Management – Provide different function access to users via same responsibility (Role Bases Access Control)

This post will cover a basic RBAC setup under User Management module of Oracle EBS.

Oracle EBS R12: Complete Accounts Payable – Setup

The document provided in this post covers the complete setup of Oracle Accounts Payable.

Oracle EBS R12: Landed Cost Management – Pre Receiving – Setup

The document provided in this post covers the complete setup of Landed Cost Management – Pre Receiving.

Oracle EBS R12: Link PR and RFQ (By Populating PR Number on PR Lines)

Oracle Purchasing does not provide a link between PR and RFQ by any standard functionality. It is however possible to achieve the aforementioned, via a small and easy customization.

Oracle EBS R12: Query for SLA-GL Reconciliation of Payables Accounts (Liability, Prepayments etc.)

The Query provided in this post can be used to reconcile a Payables control Account to GL. This may be a liability account or a prepayment account:

Oracle EBS R12: Query for Inventory AP Reconciliation SLA to GL

The query provided in this post will provide you with the complete list of transactions that sum up to make your AP Accrual Balance in General Ledger. You may amend the query to run for whatever date range/GL Accrual Account you require, and any other columns you see fit:

Oracle EBS R12: Inter-Organization Transfer through Internal Requisition/Internal Sale Order Flow (Setup and Scenarios)

The purpose of the document attached in this post is to present setup required to achieve and process the following scenarios:

Oracle EBS R12: Complete Oracle E-Business Tax Setup (Single Recoverable/Non-Recoverable Rate, Grouping and Compounding)

The document provided in this post covers the complete setup of Oracle E-Business Tax. This document contains the complete Regime to Rate flow required to setup for applying Tax Rates at transactional level.

Oracle EBS R12: Archive of useful Standard DB Objects

The purpose of this post is to pool together useful seeded Oracle db objects that may help you for multiple purposes (Reporting, Queries, Data Extraction, Personalizations etc.).

Oracle EBS R12: Upload Suppliers, Supplier Sites and Supplier Contacts through WebADI

This post will provide you with the complete detailed method on how to Create a WebADI Integrator and to upload Suppliers into your Oracle EBS R12 instance through WebADI.