Java Web Start installation
Simply installing Java 1.5 from Sun is the easiest way to get the newest Java and Java Web Start. Windows: To get 1.5, go to the Java 1.5 website. Just go through the install…
Read MoreGeneral Ledger Category Payroll Extract
Below is the query to extract Payroll data from General Ledger, historical data for a week. select gjl.je_line_num, gcc.concatenated_segments, nvl(gjl.entered_dr,0) entered_debit,nvl(gjl.entered_cr,0) entered_credit,gjl.description from gl_je_lines gjl,gl_code_combinations_kfv gcc, gl_je_headers gjh,gl_je_sources gs,gl_je_categories gc…
Read MoreInternal Requisition/ Internal Sales Order Integration
This integration will integrate IR/ISO based on upload file from APEX application that has been created as custom.Once file been uploaded lot based data based on FIFO basis will be…
Read MoreFusion Document Sequence
Fusion document sequence This document tells how to create a document sequence in Fusion and process setep’s
Read MoreExpense Report Processing for Terminated Employee
Expense Report Processing for Terminated Employee To enter an Expense report for an employee, the employee has to be Active. The expense code looks at the Hire Date…
Read MoreHow to Process 1099 Invoices In Oracle EBS Applications
1099 Invoices Processing Every Year January the subject of 1099 processing shoots to the top of the priority list for many AP Managers. Remembering exactly what was…
Read MoreOracle Employee Approval Signing Limits in Oracle EBS Applications
Oracle Employee Approval Signing Limits in Oracle EBS Applications There is no API and other Method To Enter Signing Limits Metalink Note (171837.1) The only option is direct insert in…
Read MoreOracle EBS – Tables involved in Procure to Pay Process
Tables Involved in P2P –Inventory select * from mtl_system_items_b msib where msib.segment1=’TEST’; select * from mtl_onhand_quantities_detail where inventory_item_id=111111; select * from mtl_onhand_quantities –view where inventory_item_id=111111; –Requisitions select…
Read MoreCash Management Tables in Oracle EBS
Cash Management base Tables CE_BANK_ACCOUNTS: CE_BANK_ACCOUNTS contains Legal Entity Level bank account information. Each bank account must be affiliated with one bank branch. CE_BANK_ACCT_USES_ALL: CE_BANK_ACCT_USES_ALL…
Read MoreTables Involved in Cash Management Reconciliation
Tables Involved CM Reconciliation Process 1) Run the program- Bank Statement Loader to load data in following Open Interface tables CE_STATEMENT_HEADERS_INT_ALL (Stores Information about bank statement Header details)…
Read More