-

 SCM

---

Supply Chain Planning:

Demand Management

Supply Planning

Sales and Operations Planning

Supply Chain Collaboration


Inventory Management:

Materials Management

Cost Management

Financial and Supply Chain Orchestration


Manufactering:

Discrete Manufacturing

Process Manufacturing

Mixed-Mode Manufacturing

Production Scheduling

Project-Driven Manufacturing

Contract Manufacturing


Maintenance:

Asset management

Smart Operations

Maintenance planning and execution

Maintenance cost management

Parts inventory management

Project-specific maintenance

Service logistics and depot repair for asset-based service



Order Management

Omnichannel Order Management

Rapid order fulfillment

Pricing management

Product and service configuration

Global order promising

Channel Revenue Management


Logistics:

Transportation Management

Global Trade Management

Warehouse Management


Product Life-Cycle Management:

Innovation Management

Product Development

Quality Management

Configurator Modeling

Product Master Data Management


Procurement: 

Procure-to-Pay

Supplier Management

Sourcing

Contracts

Business Network


Fusion Data Intelligence:

Identify cost-saving opportunities

Predict future outcomes

Find opportunities for spend consolidation and greater supplier value

Improve customer satisfaction through perfect order execution

Gain inventory visibility across locations

Integrated with Oracle Cloud SCM applications



Sustainability

Procurement

EPM Planning

Logistics

----------------

SCM used industries

Automotive

Communications

Consumer Goods

Healthcare

High Tech

Life Sciences

Industrial Manufacturing

Oil and Gas

Restaurants

Retail

Travel and Transportation

Wholesale Distribution

----------------

New in SCM 

Supply Chain Command Center

Oracle AI for SCM

Sustainable Supply Chain

Unlock Continuous Innovation

Perfect Delivery - Order Fulfillment

Comments

Post a Comment

Popular posts from this blog

Oracle SQL

-
SQL Course Content Topic_Details  1. DB,DBMS,RDBMS,ORDMBS & DB development lifecycle Click Here 2. About Oracle Click Here 3. Client/Server Click Here 4. About SQL Click Here 5. Data, data definitions, schema, and SQL Developer tool and DB install process. Click Here 6. Creating a User/Schema/Account in Oracle DB. Click Here 7. Data types in Oracle. Click Here 8. Creating,inserting a Table in Oracle DB. Click Here 9. Operators in Oracle DB. Click Here 10. Displaying data from Oracle DB. Click Here 12. Where Clause Click Here 13. In,between,Like,Is Operators Click Here 14. Alias, All_users,User tables. Click Here 15.Order by, Distinct,fetch clauses ...
Read more

SubQueries

-
Single Row_SubQuery -------------------- Single-Row Sub-Queries Returns one value SELECT <columns> FROM <table_name> WHERE <col_name> <OP> (SELECT STMNT); > , >=, <, <=, =. <> A single-row subquery in Oracle SQL is a subquery (a query nested inside another query) that returns only one row. The main/outer query uses the inner query result as its conditions If single row sub-query returns more than one row then you will get an error ORA-01422: exact fetch returns more than requested number of rows) It can be used in Select, Where, Having clauses Single Row_SubQuery -------------------- --1. Find who is getting highest salary in the employee table? select max(sal) from emp; select *from emp where sal=(select max(sal) from emp); select max(salary) from employees; select *from employees where salary=(select max(salary) from employees); --2.Find second maximum salary emp? select *from emp where sal=( select max(sal) from emp where sal!=(select max(sa...
Read more

With Clause

-
 WITH Clause  ====================================== What? With Clause is a Sub-Query factoring or (Common Table Expressions-CTEs) This features is introduced in Oracle 9i.Using this feature: We assign query result set to a temporary tables. We can access data from temporary tables in main Select clause as many times we require with out repeating the sub-queries. When? Usage of (2,3 level-Nested Queries) can  be minimized or avoided when using With Clause. If we use sub-queries up to 1 level then performance may be good but when we use 2 level or 3 level sub-queries then there may chance of performance issues when we try to fetch large large volume of data. How to implement CTEs ====================== SELECT deptno,        Sum(sal) total_sal FROM   emp GROUP  BY deptno; --fetch sum of sal for each dept. SELECT Avg(total_sal) FROM  (SELECT deptno,               Sum(sal) total_sal     ...
Read more