Workflow Tables Data Model
Oracle EBS: Order Management Tax Calculations Freight Charges
Oracle Order Management :Tax Calculation Freight Charges Tax Calculation on Freight Charges Currently, in Order Management, estimated t...
Oracle Order Management Worklfow Enhancement
Oracle Order Management :Workflow Enhancement Enhanced Workflow Activity Hold With the existing functionality of Holds in Order M...
Oracle eBusiness Suite :R12.2.6 Workflow Enhancement Part-1
Workflow R12.2.6 New Features External Links to Oracle E-Business Suite in E-mail Notifications If Oracle E-Business Suite(EBS) instan...
Oracle Order Management : DUAL UOM functionality
Oracle Order Management : DUAL UOM Dual UOM functionality mainly comes into picture in industries like poultry and fruits where items ...
Oracle eBusiness Suite: Payables R12 upgrade
Oracle eBusiness Suite: Payables R12 upgrade Suppliers New R12 tables -> Old 11i Tables AP_SUPPLIERS - replaces PO_...
Oracle eBusiness Suite: Banks R12 upgrade Technical snippets
What are the new tables/columns in R12 that correspond with the following list of 11i tables? AP_BANK_ACCOUNTS_ALL BANK_A...
Oracle eBusiness Suite:Serial Numbers :Mark ID
Mark IDs / Locked Serials: What is a mark id? The serial number table (MTL_SERIAL_NUMBERS) holds a list of existing serial numbers i...
Oracle eBusiness Suite : Oracle OM :Schedule ship/Arrival Date calculations
How is the Schedule Ship Date calculated? Non-ATP: set to Request Date ATP: uses calendars, supply and demand, Using Ad...
Oracle Order Managment :Setup of Credit Managment without OM
Question: What needs to be done if we are implementing Credit Management but we have Order Management on a legacy system? If a Sales or...
Oracle eBusiness Suite :Order Management -Hold API issues
Order Management OE_ORDER_:HOLDS API Issue: Applying Holds using OE_HOLDS_PUB.apply_holds using the below code. FOR l_orders in c_o...
Oracle SQL: 12c Features--Identity Column
Identity Columns :A column in a table can be marked as identity column which generates its value by itself. Oracle implicitly creates ...
Oracle SQL:12C New features
Oracle 12c features 1. Multiple indexes on the same column :Before Oracle Database 12c, we could not have multiple indexes on a single ...
Oracle eBusiness Suite :Payable :Expense Report :issues
Oracle Payable : Issue: Expense Report Export are rejected by 'No Exchange Rate' And Another Rejecting With Payment Me...
Oracle eBusiness Suite Payables :Implementation Issues
Issue: AP Invoice Import API: The PO is being closed though quantity is not fully received and not billed for remaining quantity ...
Oracle eBusiness Suite : Concurrent Program: Request Set :Issue
Issue: Created Request Set. Submitted the Request Set Inactive manager/No Manager Running fine while submitting as independent requ...
Oracle SQL :NVL,NVL2,COALESCE Functions
Oracle SQL:What is the difference between NVL,NVL2 and COALESCE Functions? Questions: NVL : Converts null value to an actual value. ...
Oracle eBusiness Suite :Payables: Default Vat Code on PO
\Q) How to change the VAT code which is defaulting on PO Ans) If you want to select another tax code at po level means. First you...
Oracle eBsusiness Suite: Inventory Interview Questions
Q) Inventory Organization (Default Accounts): While setting up inventory organization you need to give a Material account and an Expe...
Oracle eBusiness Suite:Payments :Build Payments
Build Payments - Payments Code: IBY_DISBURSE_SUBMIT_PUB_PKG Build Payments will create a record in IBY_PAY_SERVICE_REQUESTS w...
Oracle SQL : Latest Interview Questions
Oracle SQL Interview Questions 1. How will you a activate/deactivate integrity constraints ? The integrity constraints can be e...
Oracle SQL : Interview Questions New Series
Oracle SQL Interview Questions 1. What are the types of SQL Statement ? Data Definition Language : CREATE,ALTER,DROP,TRUNC...