Cost Plan Population Process – Oracle/SQL
This workflow is run as a scheduled or immediate Job to populate Project Cost Plans. It can be configured to run on any desired set of projects. It can be configured to populate the Cost Plan of Record based on Allocations or based on Assignments.
Download Details
RegoXchange Content ID: EX1688
Submission Date:
Submitter:
Content Type: Clarity Studio
Related Modules: Financial Management
Company: Rego Consulting
Version Support
Versions Supported: 15.x, 16.x
Special Instructions
Special Instructions:
Set the Start Step’s Custom Script Parameter to either “Allocations” or “Assignments”.
Before running this workflow as a Job for the first time, you must modify the Start step as follows: in the section of the GEL script that begins with “<!– PULL QUERY OF COST PLANS TO UPDATE –>”, there is a SQL line “AND 1=2” that must be removed and replaced by SQL code to filter to only the projects you wish this workflow to affect.
If you are not able to perform this step, you may need to consult with a Rego Technical Resource for their assistance.
