Oracle Application Blog

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) Contact Directory: D) Business Classification Page: E)…

Read More

Withholding Tax

Table of content: 1 Background …………………………………………………………………………………………………………   2 1.1 Definition ……………………………………………………………………………………………………… 2 1.2 Purpose ………………………………………………………………………………………………………… 2 1.3 How does WHT works …………………………………………………………………………………….. 3 1.4 Drivers for WHT …………………………………………………………………………………………….. 3 1.5 Gross…

Read More

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) – Create Top-Level Category Child Category (Browsing Category) – Create Child Shopping…

Read More

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 technologies to stay…

Read More

AR Transactions and Tax Query – India Localization

SELECT TO_CHAR (trx_date, ‘DD-MON-YYYY’) ar_posting_date,        TO_CHAR (jatt.excise_invoice_date, ‘DD-MON-YYYY’) excise_invoice_date,        rcta.trx_number ar_trx_number, flv.meaning document_type,        jatt.excise_invoice_no, hca.account_number cust_bill_to,        hp.party_name cust_name,…

Read More

BI Publisher Report with Excel Template

Step1:Concurrent Program Create a Concurrent Program with Exceutable File Name as XDODTEXE Step:2 Data Xml Template Create a Data Xml Template for the Query Step:3 Data Definitions Create a Data…

Read More

Region Interface – Shipping

                     Interface Tables: WSH_REGIONS_INTERFACE WSH_REGIONS_TL_INTERFACE Base Tables: WSH_REGIONS WSH_REGIONS_TL Create Country: Insert the following data into Interface tables   Generate Sequence_ID and…

Read More

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 control in…

Read More

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 rules can also specify…

Read More

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 convert between the units…

Read More