Oracle Application Blog

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 without indicating the goods and services that you…

Read More

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 Sales Quotes…

Read More

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 inventory is available. Goal: Book a…

Read More

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 requisition for an item (Test 123) with price…

Read More

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 shipment tolerance functionality…

Read More

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 User. Navigation: Sales Agreements > Sales…

Read More

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 of Autocreated purchasing documents. Purchase orders generated through…

Read More

AP Pre Payments Query: AP XLA GL

SELECT glcc.segment1 COMPANY,  glcc.segment2 LOCATION,  glcc.segment3 COST_CENTER,  glcc.segment4 ACCOUNT,  glcc.segment5 PRODUCT_LINE,  glcc.segment6 CHANNEL,  glcc.segment7 PROJECT,  (SELECT flex_value    || ‘ ‘    || fvt.description  FROM apps.ap_invoices_all ap1,    apps.gl_code_combinations glc,    apps.fnd_flex_values fv,    apps.fnd_flex_values_tl…

Read More

AP Distribution Query: AP XLA GL

SELECT glcc.segment1 company, glcc.segment2 LOCATION,       glcc.segment3 cost_center, glcc.segment4 ACCOUNT,       glcc.segment5 product_line, glcc.segment6 channel,       glcc.segment7 project,       (SELECT flex_value || ‘ ‘ || fvt.description          FROM apps.ap_invoices_all ap1,               apps.gl_code_combinations glc,               apps.fnd_flex_values fv,               apps.fnd_flex_values_tl…

Read More

AR Adjustments Query: AR XLA GL

SELECT glcc.segment1 company, glcc.segment2 LOCATION,       glcc.segment3 cost_center, glcc.segment4 ACCOUNT,       glcc.segment5 product_line, glcc.segment6 channel,       glcc.segment7 project,       (SELECT flex_value || ‘ ‘ || fvt.description          FROM apps.gl_code_combinations glc,               apps.fnd_flex_values fv,               apps.fnd_flex_values_tl fvt         WHERE…

Read More