Oracle EBS Table Suffixes
introduction You have a lot of tables ending with different suffixes in the Oracle Apps database. Listed below are the different types of tables. ALL: Table ending with _ALL means it…
Read MoreQuery to extract iProc Smart Forms
Introduction This Post is about extract iProc Smart Forms query in Oracle EBS R12. SELECT DISTINCT STORE.NAME store_name, smartforms.template_name request_name, pas.commodity_id, pas.vendor_name supplier, (SELECT NAME FROM apps.hr_operating_units WHERE organization_id…
Read MoreExport employee data with personal expenses in i-expense and the expense is not claimed in oracle apps
Introduction This Post illustrates the steps required to Export employee data with personal expenses in i-expense and the expense is not claimed in Oracle EBS R12. Script to Export employee…
Read MorePayroll Employer Costs Extract
Introduction This Post is about to Payroll Employer Costs Extract in Oracle EBS R12. Script to Payroll Employer Costs Extract. SELECT SUM(peevf.screen_entry_value) FROM pay_element_types_f petf ,pay_element_entry_values_f peevf ,pay_element_entries_f peef…
Read MoreUpdate Oracle Project information using PA_PROJECT_PUB.
Introduction This Post illustrates the steps required to Update Oracle Project information using PA_PROJECT_PUB in Oracle EBS R12 Script to Update Oracle Project information using PA_PROJECT_PUB. SET DEFINE OFF; CREATE OR REPLACE…
Read MoreHow to Create Responsibility API
Description: A responsibility is an important configuration which allows the user to navigate to the various menus and form functions within that responsibility. Oracle API is used to load responsibility…
Read MoreQuery to get transactions of inventory items with available onhand quantity
Introduction This post is about to get transactions of inventory items with available onhand quantity. Script to get transactions of inventory items with available onhand quantity. SELECT recs.doc_type, recs.item_number,…
Read MoreAccount Payables Remittance Advice.
Introduction This post is about AP Remittance Advice, a document that describes payments that are being made. The person or company that is causing the payment will include a remittance…
Read MoreSuppliers Report (XML)
Introduction This Post described Suppliers Report (XML) is used to review the supplier, supplier site, and supplier contact details. Query Fetching Vendor Details: SELECT p.vendor_id c_vendor_id, p.segment1 c_vendor_number, p.vendor_name c_vendor_name, DECODE (UPPER (:p_order_by_par),…
Read MoreQuery of 11i to R12 Table Changes
Description: In this page, going to cover minimum database object level changes done by Oracle in the upgrade like object obsolete, package level changes, API changes. Accounts Payable 11i R12…
Read More