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 MoreDescription: 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 More1. 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 Introduction This post is about to get employee details who are not submitted the iExpense…
Read MoreIntroduction 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 MoreIntroduction 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 MoreRepetitive 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 MoreTable 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 MoreScripts used for clearing the RCV stuck pending transactions Scenario: While receiving or correcting a PO, some time the transactions get stuck with out Processing due to delay in running…
Read MorePROFILE OPTIONS IN BILLS OF MATERIALS Profile Option User System Administrator Requirements User User Resp App Site Required? Default Value BOM: Check for Duplicate Configuration – Optional No BOM: Component…
Read More