Oracle EBS: Item Tracking

✅ 1. Item Tracking Overview Oracle EBS supports multiple item tracking methods through item attributes and system setups. Tracking helps ...

Oracle APPS :Requisition moved from different stages till converting into PR

SELECT DISTINCT u.description "Requestor", porh.segment1 AS "Req Number",                 TRUNC (porh.creation_date)...

Oracle EBS: XML Publisher Reports Watermark

 XML Publisher Reports Watermark Issue In XML Publisher Reports Watermark comes up in PDF output but does not show in RTF.  1. Cre...

Oracle EBS Property Management Part-2

1) Buildings Menu Path: Property Definition > Building 2) Land Menu Path: Property Definition > Land 3) System Options Menu P...

Oracle EBS :Payables :Pay Alone Technical snippets

With the release of R12.0.0, payment information like the Pay Alone Flag (Exclusive_Payment_Flag) and default Payment Method are now stor...

Oracle EBS :Payables :Payment Process Request Template

What is a Payment Process Request (PPR) Template? "Oracle Payables uses templates created [by users] in the Templates tab of the...

Oracle EBS :Payables :Payments for Inactive Supplier Site

The system allowing to Make Payments for Inactive Supplier Site It is not a bug. The system is coded to allow the user to pay invoic...

Oracle EBS: Payables :Creation of Employee Type Suppliers

Creation of Employee Type Suppliers     1. Select responsibility with full access to employee suppliers     2. Choose Create Supplier b...

Oracle EBS :PO :PDOI Quantity in po_lines_interface

How is quantity populated in po_lines_interface? If shipment_num populated in the po_lines_interface, then the quantity should  be popul...

Oracle EBS: AR Receipts(Standard,Mis Receipts,Trade Receipts)

Difference between Standard, miscellaneous and  trade receipts   Standard receipts: Payment (such as cash or a check) that you receive f...

Oracle APPS :XML Reports:Calling PL/SQL procedure/function

Q)Is it possible to call Calling PL/SQL procedure/function from a BI Reports Template ? In data template we can call as below    e.g. ...

Oracle EBS: Inventory : LOT numbers Generation

Error:  Some times while generating LOT numbers by using  API - INV_LOT_API_PUB.Auto_gen_lot ,will get error " Lot number can not be ...

Oracle Order Management :Shipped Quantity Not Matching With AR Invoiced Quantity

Issue: Shipped Quantity Not Matching With AR Invoiced Quantity Reasons: The reason why fulfilled_quantity and invoiced_quantity is ...

Oracle APPS : OM Back to Back Order Technical snippets

Oracle APPS : Back to Back Order Technical snippets  Table MTL_RESERVATIONS, after PO created, the system will automatically reserve ...

Oracle APPS: Profile Options

Oracle APPS: Profile Options How to know which profile option is modified recently? select * from fnd_user where user_name like ...

Oracle Applications: Pitfalls in Migration

Oracle Applications: Pitfalls in Migration All we worked different objects .Some times code will work in DEV instance and some times it...

Oracle EBS: Order Management :Reserving quantities

How to reserve quantities at the time of sales order booking?   From the Sales Order Line, kindly go to Tools>>Scheduling>...

Oracle apps :Purchase order Final Close

Oracle apps :Purchase order Final Close What checks be made before user finally closes a PO? Does system make any checks and gives an...

Oracle Applications :Order Management :RMA account entries

Oracle Applications :Order Management :RMA account entries RMA Returns You can return items received into inventory through an RMA ba...

Oracle APPS:Purchasing Technical Components

Oracle APPS:Purchasing Technical Components Oracle Purchasing allows requisitions, purchase orders, quotations, and receipts etc to ...