Utilize the Project Cost Collection Flexfield to ensure that Creators can charge only the projects

Summary:

Based on the customer requirement, We want to change the parameter from 'Requester' to 'Creator' or Requisition Entered by.  As the customer is having two different persons for the above fields and they want to restrict based on the creator.  Kindly assist how to configure the same.

We found the below solution from requester point of view. We want to change it based on Creator's POV.

Content (please ensure you mask any confidential information):

Value Set Definition

Module: Cost Collection

FROM Clause: FUSION.PJC_PROJECTS_CCW_V P, FUSION.PJF_PROJECT_PARTIES TM

Value Column Name: P.PROJECT_NUMBER