Order Management Basis Setups

Oracle Order Management Setups

Oracle Order management is one of the most important part of the oracle EBS. The Order Management Application provides many flexible features enabling you to set up your system to begin processing order information. These orders can be created in Oracle Order Management Suite as well as in some other front-desk application. We can integrate these applications with Oracle Order Management for keeping a controlled track of orders and proper business flow. We can create different types of orders using this application can be for inventory stock items or for services.
You must define your business order policies, such as how you classify your orders, as well as various control features prior to processing orders within the application.

Important Setup Steps for Order Management

Click on the links to go to individual setup steps

Step	Optional or Required
1. Define multiple organizations in Oracle Inventory	required
2. Setup Multi-Org (Multiple Organization) Access Control	optional
3. Define key and descriptive flexfields	required under certain conditions
4. Define inventory organizations (warehouses), parameters, subinventories, and picking rules in Oracle Inventory	required
5. Define Profiles	required
6. Setting OM System Parameters	required
7. Define invoicing information, Payment Terms	required under certain conditions
8. Define your sales representatives	optional
9. Define Tax Features	required
10. Define Quickcodes	required under certain conditions
11. Define header and line processing flows	required
12. Define Document Sequences for Order Numbering	required
13. Define Order Import Sources	required under certain conditions
14. Define the units of measure	required
15. Define item information	required
16. Define the items that you sell	required
17. Define the configurations that you sell	required under certain conditions
18. Define price lists	required
19. Define customer profile classes	required under certain conditions
20.Define information on your customers	required
21. Define item cross references	required under certain conditions
22. Define your sourcing rules	optional
23. Define Order Management Transaction Types	required
24. Set up Cost of Goods Sold Accounting flexfield combination	required under certain conditions
25. Define Processing Constraints	optional
26. Define Defaulting Rules	optional
27.Define Credit Checking Rules	required under certain conditions
28. Define Automatic Holds	required under certain conditions
29. Define Attachments	optional
30. Define Freight and Special Charge Types	optional
31. Define shipping parameters	required

SQL Script to find Concurrent Request Details in Oracle

select req.request_id,
       req.argument_text,
       req.requested_start_date,
       req.actual_start_date,
       req.actual_completion_date,
      (select meaning
          from apps.fnd_lookup_values
         where lookup_type = ‘CP_STATUS_CODE’
           AND lookup_code = req.phase_code
           and start_date_active is not null) phase,
       (select meaning
          from apps.fnd_lookup_values
         where lookup_type = ‘CP_STATUS_CODE’
           AND lookup_code = req.status_code
           and start_date_active is not null) status,
       (usr.user_name || ‘ – ‘ || usr.DESCRIPTION) requested_by,
       fcpt.user_concurrent_program_name,
       (SELECT responsibility_name
          FROM apps.fnd_responsibility_tl
         WHERE responsibility_id = req.responsibility_id) resp,
       req.logfile_name,
       req.outfile_name
  from apps.fnd_concurrent_requests    req,
       apps.fnd_user                   usr,
       apps.fnd_concurrent_programs_tl fcpt,
       apps.fnd_concurrent_programs    fcp
 where req.concurrent_program_id = fcpt.concurrent_program_id
   and fcp.concurrent_program_id = fcpt.concurrent_program_id
   and usr.user_id = req.requested_by
   and req.request_id in (&req_id);