EBS Functional

Query 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 More

Open 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 More

Call 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 More

Oracle 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 More

ORACLE 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

Datafix Script to clear the RCV stuck pending transactions for Receipts

Scripts 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 More

Bills Of Materials Setup Document with Costing

PROFILE 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

Discrete Jobs End to End Cycle with Cost Roll-up in Standard Cost Organization in R12.2

STEP 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 More

Blanket Sales Agreement with Approvals and Release in Oracle R12.2

Setups 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 More

Back to Back Sales Order Cycle Setups and Process Flow in R12.2

Back 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