Inventory Setup on Oracle EBS R12

By -

 Setting up Inventory in Oracle E-Business Suite (EBS) R12.3 involves several configuration and master data setup steps. Here's a step-by-step guide to set up Inventory in Oracle EBS R12.3:


Step 1: Define Inventory Organizations


Navigation: Inventory > Setup > Organizations > Organizations

Define the primary inventory organization and any additional organizations where you will manage inventory.


Step 2: Define Subinventories


Navigation: Inventory > Setup > Organizations > Subinventories

Create subinventories within each inventory organization to represent physical locations or storage areas.


Step 3: Define Locators (optional)


Navigation: Inventory > Setup > Organizations > Locators

If you enable the locator control, define locators within each subinventory to further identify the storage locations.


Step 4: Define Units of Measure (UOM)


Navigation: Inventory > Setup > Units of Measure > Units

Define the standard units of measure and their conversions (if applicable) for the items in inventory.


Step 5: Define Item Master


Navigation: Inventory > Items > Master Items

Define the item master records for each inventory item, specifying details like item type, description, UOM, and costing information.


Step 6: Define Item Categories (optional)


Navigation: Inventory > Items > Categories

If you use item categories to group similar items, define the item categories.


Step 7: Define Item Templates (optional)


Navigation: Inventory > Items > Templates

If you have a large number of similar items, define item templates to streamline item creation.


Step 8: Define Item Cross-References (optional)


Navigation: Inventory > Items > Cross-References

If you have alternative item numbers, define item cross-references to map them to the primary item number.


Step 9: Define Account Aliases (optional)


Navigation: Inventory > Setup > Account Alias

If you want to use account aliases for accounting entries, define the account aliases and their corresponding accounts.


Step 10: Define Inventory Transaction Reasons (optional)


Navigation: Inventory > Setup > Transactions > Reasons

If you require specific reasons for inventory transactions, define inventory transaction reasons.


Step 11: Set Up Subinventory Replenishment (optional)


Navigation: Inventory > Setup > Organizations > Replenishment

If you use subinventory replenishment, set up the replenishment rules and sources.


Step 12: Define Inventory Profile Options (optional)


Navigation: System Administrator > Profile > System

Set up inventory-specific profile options to configure system behavior.


Step 13: Define Inventory Accounting Periods


Navigation: Inventory > Setup > Organizations > Accounting Periods

Define accounting periods for inventory to control the posting of transactions.


Step 14: Set Up Item Costs (optional)


Navigation: Inventory > Setup > Costs > Standard Cost

If you use standard costs, set up item costs based on your costing method.


Step 15: Review Inventory Reports


Navigation: Inventory > Reports

Use various inventory reports to review stock levels, transactions, and other inventory-related information.


Comments

Post a Comment

Popular posts from this blog

Oracle DBA Queries

By -
 Useful Queries for Checking Concurrent Requests and Programs  Hi DBAs, As an Apps DBA we have to monitor the Concurrent jobs status and details frequently,This can be done with the help of the below queries. -- Concurrent Program Queries for Apps DBA: -- Query 1:For checking the locks in concurrent jobs  SELECT DECODE(request,0,'Holder: ','Waiter: ')||sid sess,inst_id,id1, id2, lmode, request, type FROM gV$LOCK  WHERE (id1, id2, type) IN (SELECT id1, id2, type FROM gV$LOCK WHERE request>0) ORDER BY id1,request; -- Query 2:For checking the concurrent programs running currently with Details of Processed time-- and Start Date  SELECT DISTINCT c.USER_CONCURRENT_PROGRAM_NAME,round(((sysdate-a.actual_start_date)*24*60*60/60),2) AS Process_time,  a.request_id,a.parent_request_id,a.request_date,a.actual_start_date,a.actual_completion_date,(a.actual_completion_date-a.request_date)*24*60*60 AS end_to_end,  (a.actual_start_date-a.request_date)*24*60*60 AS lag...
Read more

Setup of BOM (Bill of Material) on Oracle EBS R12

By -
Setting up Bill of Material (BOM) in Oracle E-Business Suite (EBS) R12.3 involves several configuration and master data setup steps. Here's a step-by-step guide to set up BOM in Oracle EBS R12.3: Step 1: Define BOM Parameters Navigation: Bills of Material > Setup > Parameters Define BOM parameters, such as the default BOM type, effective date, and organization. Step 2: Define BOM Item Attributes Navigation: Bills of Material > Setup > Attributes Define BOM item attributes, such as item categories and planning attributes. Step 3: Define BOM Structures Navigation: Bills of Material > Setup > BOM Structures Define BOM structures to represent different types of BOMs (e.g., Engineering, Production). Step 4: Create Bill of Material (BOM) Navigation: Bills of Material > Engineer > Bills > Bills Create the BOM by entering the header data (e.g., assembly item, BOM type) and adding the components along with their quantities and item attributes. Step 5: Define Compo...
Read more

Setup iSupplier in Oracle EBS R12

By -
 Setting up iSupplier Portal in Oracle E-Business Suite (EBS) R12.3 involves configuring the iSupplier module to enable self-service supplier management and collaboration. Here's a step-by-step guide to set up iSupplier Portal in Oracle EBS R12.3: Step 1: Enable iSupplier Portal Responsibility Navigation: System Administrator > Security > Responsibility > Define Enable the iSupplier Portal responsibility for users who need access to the iSupplier Portal application. Step 2: Define Supplier Registration and Profile Options Navigation: Purchasing > iSupplier Portal > Supplier Profile Options Set up supplier registration and profile options, such as registration attributes, contact information, and supplier types. Step 3: Set Up Supplier Registration Approval (Optional) Navigation: Purchasing > iSupplier Portal > Supplier Registration Approval If using supplier registration approval, configure the approval process and assign approvers. Step 4: Configure Supplier Q...
Read more