iStore Info

ERP, Manufacturing, AI & Enterprise Transformation

Recent Posts

Showing posts with label Oracle EBS. Show all posts
Showing posts with label Oracle EBS. Show all posts

Oracle EBS Average Cost Update Formula

Average Cost Update Formula Average Cost =    ( Transaction Value+Current Inventory value)                            (Transaction ...

Query to Find Requisition Number from Purchase Order Number

Query to find the purchase order number from requisition number: SELECT DISTINCT pha.segment1 FROM po_headers_all pha,po_distributions_all ...

Deploying “Create Employee” API as REST Service in Oracle EBS Apps

Deploying “Create Employee” API as REST Service : 1.  Go to Integrated SOA Gateway --> Integration Repository The belo...

RMA (Return Material Authorization) or Customer Returns Concept in Oracle Apps

RMA functionality allows the user to return the goods delivered to customer against Sales Order. Return from customer can occur for variou...

BOM Interface Tables in Oracle EBS

BOM Interfaces Tables 1. BOM_BILL_OF_MTLS_INTERFACE 2. BOM_INVENTORY_COMPS_INTERFACE 3. BOM_REF_DESGS_INTERFACE 4. BOM_SUB_COMPS_INTER...

Oracle BOM Setup Check List

The following table lists setup steps for Setting up Bill of Material in Oracle Apps. Step No. Required Step Title Application ...

Oracle Apps Inventory Question and Answers - Part1

Q. Once an item is assigned to an organization, is it possible to remove this association at a later time? A. If you have assigned an item...

What is Charge Type Field in BOM ?

You can determine how each resource is charged in Work in Process. When an operation completes, Work in Process records the units applied ...