Wednesday, January 8, 2014

Oracle Advanced Supply Chain Planning - Planners

Oracle ASCP Planners

Planners are defined in EBS side, attached to the items in the individual orgs and then come over to the ASCP side as part of the collections.

Navigation-
Login to oracle applications.
Responsibility: Inventory
Setup > Planners
















SQL Query to derive planners from source Oracle ebs system-

SELECT * FROM MTL_PLANNERS;

SQL query to derive planners from Oracle ASCP -

SELECT * FROM MSC_PLANNERS; 










1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete