Thursday, August 28, 2014

Oracle Pricing Setup : Modifiers In Oracle Apps

›
Modifiers enable you to set up discounts,surcharges,free goods,coupons,freight and special charges that can be applied immediately to prici...
Wednesday, August 27, 2014

Oracle Pricing Setup : Understanding Price Lists

›
Price List can be imagined as a table of Item vs Item Price. Every Item must have a price. Items are integral part of Inventory and Order M...
Tuesday, August 26, 2014

Oracle Pricing Setup : Flow for Oracle Advanced Pricing

›
Below is the Pricing Setup flow checklist to be performed during implementation :
Friday, August 22, 2014

Ref Cursor in Oracle PL/SQL

›
A REF CURSOR is basically a data type.  A variable created based on such a data type is generally called a cursor variable.  A cursor varia...
Wednesday, August 20, 2014

Nested Table in PL/SQL

›
Nested Table:   Nested table is a collection of rows, represented as a column within the main table. For each record within the main table...

Merge, Exists and Non-Exists in PL/SQL

›
Exists: ------------- The EXISTS condition is considered "to be met" if the subquery returns at least one row. The syntax fo...
Tuesday, August 19, 2014

Where Current of : PL/SQL

›
WHERE CURRENT OF clause is used in some UPDATE statements. The WHERE CURRENT OF clause is an UPDATE or DELETE statement states that the ...

Rank Function in PL/SQL

›
Rank : In Oracle/PLSQL, the rank function returns the rank of a value in a group of values. The rank function can be used two ways - a...
Friday, August 8, 2014

Create Person Party and Org Contact for a Organization Pary in Oracle R12

›
 --It is always a good idea to initialize apps and set global policy context before using standard API CREATE OR REPLACE PROCEDURE create...
Thursday, August 7, 2014

Example : get_service_duration API in Oracle R12 Order Management

›
--It is always a good practice to initialize apps and set global policy context PROCEDURE get_service_duration (    p_serv_period       ...