Monday 31 August 2015

Oracle ASCP Organization Security

This feature restricts plan information access to authorized individuals. Oracle ASCP allow users to associate job responsibilities to organizations for security purposes.

The following diagram illustrates the procedure flow for assigning users and job responsibilities to organizations:
the picture is described in the document text


Define custom responsibility in the Planning Server.

Navigation --> System administrator -->Security -->Responsibility -->Define



Define users and assign responsibilities 

Navigation : system administrator -->Security -->User --> Define

 


Assign Organization to Responsibilities

navigation :Advanced Planning administrator -->admin -->Organization Security

Save the Work .

Now User having Responsibility "ASCP_Supply chain Planner" Can View/Update Plans for Organization "TST:AM1"
 

Wednesday 12 August 2015

Activities in Oracle Process Manufacturing


Activities are actions performed during production.

For Example a Steel Processing Facility May Break up a Shearing Line Operation Into De Coiling, Straightening, Trimming, Shearing, Levelling and Stacking .

Activities are set up to divide a manufacturing process into logical breakpoints.

By analyzing and refining the granularity of activities, businesses can improve their work methods and reduce time to manufacture so that activities performed in operations are completed in the shortest possible time with the least effort to deliver the appropriate level of quality.

Cost analysis codes are assigned to activities so that proper cost calculations are computed.

Navigation 

Process Engineer -->Setup --> Activities

   
Query to Retrive Data From Table :

SELECT ACTIVITY,
  COST_ANALYSIS_CODE,
  ACTIVITY_DESC,
  CREATED_BY,
  CREATION_DATE
FROM GMD_ACTIVITIES_VL
ORDER BY Creation_date DESC