Lockbox – Error Handling
intorduction this post is about to Submit postQuickcash for records struck in the interfac Lockbox – Error Handling Submit postQuickcash for records struck in the interface. Query with Transmission Name…
Read MoreOracle Forms – Dynamic Message Tool Tip
Introduction This Post is about to oracle forms-Dynamic Message Tool Tip in oracle EBS-R12 Multiple tooltip message in single text field Step 1:- Create canvas and Using the below…
Read MoreQuery to fetch Customer Statement of Account Details
Description: Query to fetch Customer Statement of Account Details SELECT rc.customer_name “Customer_Name”, rc.customer_number “Customer_Number”, hou.NAME operating_unit, DECODE (ps.CLASS, ‘INV’, ‘Invoice’, ‘DM’, ‘Debit Memo’, ‘DEP’, ‘Deposit’, ‘CM’, ‘Credit Memo’, ‘PMT’, ‘Receipts’…
Read MoreAR Receipt Distribution Query: AR XLA GL
Description: The below process explains the responsibilities of AR Receipt distribution query on AR XLA GL SELECT glcc.segment1 co, glcc.segment2 loc, glcc.segment3 cc, glcc.segment4 acct, glcc.segment5 prod, glcc.segment6 chan,…
Read MorePeriod End Processing of Oracle Inventory and Cost management in oracle apps
1. Description Oracle Inventory provides the features you need to summarize costs related to inventory and manufacturing activities for a given accounting period and distribute those costs to the general ledger…
Read MoreQuery to get employee details who are not submitted the iExpense details for approval
Query to get employee details who are not submitted the iExpense details for approval Introduction This post is about to get employee details who are not submitted the iExpense…
Read MoreOpen Purchase Order Details(Standard Po)
Introduction This post is about to Open Purchase Order Details(Standard Po) in Oracle EBS R12. Script to Open Purchase Open Details (Standard PO) SELECT poh.type_lookup_code source_type, prh.segment1 pr_number,…
Read MoreCall Oracle package in Oracle BI Publisher 10g
Introduction This Post is about Oracle BI Publisher is just a reporting tool. From which we can download excel, CSV, XML, RTF, PDF reports. In which we can use only…
Read MoreOracle WIP_Repetitive Schedules_Setup Steps and Process Flow in R12.2
Repetitive Manufacturing in Work in Process Table of Contents? What is Repetitive Manufacturing? Setups required to perform Repetitive Manufacturing Transactions Create Repetitive Schedule WIP Material Issue to Repetitive Schedule WIP…
Read MoreORACLE WORK IN PROCESS SETUP DOCUMENT IN R12.2
Table of Contents? STEP 1: Setup Prerequisites Oracle Inventory Oracle Bills of Material Oracle Engineering Oracle Cost Management Oracle Project Manufacturing Oracle MRP/Master Scheduling and Supply Chain Planning STEP 2:…
Read More