Oracle-EBS

Overview of Inventory Transactions A transaction is an item movement into, within, or out of inventory. A transaction changes the quantity, location, planning responsibility, and cost of an item. Oracle Inventory supports a number of predefined and user-defined transaction types. Every material movement has a corresponding set of accounting transactions that Oracle Inventory automatically generates. All transactions validate the various controls (revision, locator, lot number, serial number and secondary unit of measure) you enable for items. INVENTORY TRANSACTIONS You can perform the following inventory transactions: •          Receive items into your organization from a general ledger account number. •          Issue items from your organization to a general ledger account number. ·           Transfer items from a subinventory in your organization to another subinventory in the same organization. •          Transfer items directly between organizations. •      

R12 E-Business Suite Suppliers Query - SQL to join Suppliers, Contacts, Banks In the Oracle E-Business Suite (EBS) Release 12 the data model of Suppliers has become much more complex. The base tables have changed (Suppliers, Sites, Bank Accounts, Contacts) and some of the fields have become obsolete. Here is a query to bring many of the Supplier attributes together, with focus on banks / bank accounts, payment methods, contacts, remittance delivery (email, notification method). Please post comments if you find any issues! Adjust the WHERE clause on the first WITH query to return the suppliers that you need to report on. Hope this query helps someone out. Add additional fields to the final query (or WITH queries as required.) with vendors as ( select vendor_id from ap_suppliers where 1=1 /* COMMENT / UNCOMMENT and UPDATE THE NEXT 5 LINES AS YOU REQUIRE */ --and vendor_type_lookup_code = 'VENDOR' --and upper( vendor_name ) like 'VIRTUATE%' and

Oracle Purchasing Interview Questions  Some Oracle Apps Purchasing FAQ’s What is a Purchase Requisition and define various requisitions What are the base tables for a Purchase Requisition? What is a Requisition Import Program? What tables are affected when you run Requisition Import Program? What are the reports associated with requisition import process? When will you use a Requisition Template? What is the purpose of choosing a Category when creating a requisition? What does the status pre-approved mean? What is the difference between a rejected and a returned requisition? What is RFQ and differentiate the types of RFQ’s What is a Quotation, what are the different types of Quotations available and describe the Quote Analysis? What is a Purchase Order and explain the different types of PO’s available What are the base tables that are affected when you create a P.O? What is 2-way, 3-way, 4-way matching? Explain the P2P process flow What is an approval hierarchy? W