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 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 MoreSTEP 1: CREATE ITEMS Responsibility: Inventory Navigation: Items > Master Items Select the Organization as “M1 – Seattle Manufacturing“ Create the below items; Item Item Template (Type) DYS_CAR Finished Goods…
Read MoreSetups Required: 1. Transaction Type: Create an order transaction type. Sales Document type should be “Sales Agreement“. Fulfillment flow: Sales Agreement – Generic Negotiation Flow: Negotiation Flow – Generic with…
Read MoreBack to Back Orders in Oracle Setups Required: Step1: Create Transaction type. Use Order Fulfillment flow as Order Flow – Generic. Use the Line flow and validate the workflow then…
Read More