Differences Between CHAR and VARCHAR2 Data Types Predefined Subtypes How Blank-Padding Works Value Comparisons : ...
Oracle PLSQL : Data types: Boolean
BOOLEAN Data Type The PL/SQL data type BOOLEAN stores logical values, which are the Boolean values TRUE and FALSE and the valu...
Oracle SQL: Natural Data type
Data Type :NATURAL Definition: In Oracle PL/SQL, NATURAL is a 32 bit sub datatype derived from BINARY_INTEGER. It allows positive ...
Happy Christams
Oracle SQL :Data Type of NULL
Q)What is the Data Type of NULL? Ans) Oracle treats NULL as character value of length of 0. So, the default data type of NULL is a ch...
Oracle APPS : Inventory Valid Subinventory
Problem: Created new Responsibility for order management got the following error Solution: The specified subinventory is inva...
Oracle EBS: iProcurement Pro's and Con's
Oracle EBS iProcurement Pro's Punchout to Supplier(s) Desktop Receiving Catalog Management Requisition Tracking and Management ...
Oracle APPS :Inventory: Unable to Assign New Item to Item Categories
Q)Created a new item and want to assign category set but not sure why the item is not listed on category set window. What possibly c...
Oracle Payables: Payments Issues
Does EBS allow the payment for unaccounted invoic es? or Two invoices were paid but their status in "Accounted"...
Oracle SQL :Converting Table Data to XML format
Converting data from the table to XML format select dbms_xmlgen.getxml('select employee_id, first_name, last_name, phone_num...
Oracle APPS: Quoting: Tax On Quotes
Taxes on Quotes We are entering a quote in R12. We would like taxes to be generated on the quote on booking. Kindly let me know if...
Oracle APPS : Purchasing: Requisition Issues
Auto Create Requisition Into PO When PO Has Been Cancelled The issue can be reproduced at will with the following step...
Oracle EBS Fusion OM Feature Differences
Oracle EBS Fusion OM Feature Differences 1.Customer Pricing Profile : You can use a pricing profile to categor...
Oracle XML Publisher reports:Default output
How to set XML publisher report default output format to rtf? Solution: Set the Profile option 'FND: Default Template Ou...
Oracle Order Management Queries -2
Following sql query retrieve the Internal Requisition details which were transferred to OM , but Internal Sales Ord...
Oracle APPS :Order Management: Queries
To check whether the Sales Order was imported already, the following query can be used: SELECT 'Exists in OM main' FR...
Oracle Purchasing Purchase Order Matching
Unable to Match an Invoice to Purchase Order Check the Match Option set at PO Shipment Level. If Match Option is set to PO th...
Oracle APPS :Order Management Split Line Functionality
Order Management Split Line Functionality Users can split scheduled lines. Line splits performed from the Scheduling organizer wil...
Oracle Order Management: Internal Sales Order
Q) How to determine whether the Sales Order information was sent to Order Entry? Answer: After running Create Internal Sales ...
Oracle APPS :Purchase Order :Copy Document
How to remove the Copy Document PO from Tools of Purchase order form.? Copy Document function can be excluded in the responsibi...
Oracle Purchasing :Discounts on PO
Q)Can we give discounts for Purchase Orders? Solution: Yes we can give discounts by using modifiers Modifier Creation ...
Oracle APPS : How to Face Interviews?
Oracle APPS : Interview Preparation Normally when we are giving interviews ,we hav...
Oracle APPS :XML Publisher Reports :Emailing the Output
How to Schedule and email XML publisher reports into one or more peoples inbox ? Developed couple of reports in XMLP,We want t...
Oracle Purchasing :cancellation of PO's Part-2
If we want to cancel PO'S its needs to satisfy the following conditions then only we can cancel the PO For more articles on Pu...
Oracle Purchasing :PO and Requisition Cancellation
We can't cancel Requisitions and PO in the following scenarios Requisitions · if a buyer places a requisition lin...