Oracle Application Blog

11i to R12 Table Changes

Accounts Payable 11i R12 PO_VENDORS AP_SUPPLIERS PO_VENDOR_SITES_ALL AP_SUPPLIER_SITES_ALL PO_VENDOR_CONTACTS AP_SUPPLIER_CONTACTS AP_SUPPLIER_INT_REJECTIONS AP_INVOICE_LINES_ALL IBY Payment 11i R12 IBY_PAY_SERVICE_REQUESTS IBY_PAY_INSTRUCTIONS_ALL IBY_DOCS_PAYABLE_ALL IBY_PAYMENTS_ALL IBY_EXTERNAL_PAYEES_ALL IBY_EXT_BANK_ACCOUNTS IBY_EXT_PARTY_PMT_MTHDS IBY_ACCOUNT_OWNERS IBY_PMT_INSTR_USES_ALL Accounting 11i R12 AP_ACOCUNTING_EVENTS_ALL XLA_EVENTS…

Read More

Oracle HRMS – Create Employee API

This blog describes the process and technical information required for creating new employee using API. In any business organization employee should there to do the work, so Oracle provide hr_employee_api.create_employee…

Read More

Create, Update Organization API

This blog describes the technical information required for creating Inventory organization and their classification using API.In order to create Inventory organization we can use three API which are    Apps.hr_organization_api.create_organization    Apps.hr_organization_api.update_organization   …

Read More

Query to Link PO, AP, GL, ZX, CE, RCV & XLA

   SELECT glimp.je_header_id je_header_id, glimp.je_line_num je_line_num,           xal.accounted_cr accounted_cr, xal.accounted_dr accounted_dr,           xal.entered_cr entered_cr, xal.entered_dr entered_dr,           xah.accounting_date accounting_date,           xal.accounting_class_code acct_line_type,           xal.code_combination_id code_combination_id,              gcc.segment1           || ‘.’…

Read More

Query to Link PO,AP,GL,TAX RATE & XLA

SELECT r.je_header_id je_header_id, r.je_line_num je_line_num,        200 application_id, aeh.ledger_id set_of_books_id, ‘INV’ trx_class,        l8.displayed_field trx_class_name, l1.displayed_field trx_type_name,        i.invoice_type_lookup_code trx_type_c, i.invoice_num invoice_number,        i.invoice_num trx_number_displayed, ael.description comments,        fd.NAME doc_sequence_name,…

Read More

Steps to Controller Extension in OAF Page

To extend the OA Framework page you have 2 options, extend the VO or extend/create the controller. Extending a VO is on a global level and you pick this option…

Read More

To Resolve error “JSP files must reside in the server root directory or a subdirectory beneath it”

The error “JSP files must reside in the server root directory or a subdirectory beneath it” occurs during compilation if the JSP files are located in other than HTML_ROOT Directory.…

Read More

Enable Oracle apps Diagnostics for certain users

Steps 1 Navigate to System Administrator responsibility> Profile> System> Steps 2 Enter profile name: Utilities: Diagnostics Enter Application User for whom you want to enable Diagnostics-> Examine Steps 3 Give…

Read More

Steps to Export OAF personalization across Instances

This article explains the personalization steps and how to export the personalization file from one instance to another instance. Screen 1 Provide the document path for the page where it…

Read More

OAF Search page

  1.     Create a New Workspace and Project    Right click Workspaces and click create new OAworkspace and name it as SrilathaSearch. Automatically a new OA          Project…

Read More