My Oracle Support Banner

EPBM 9.1: Error Message : Invalid Parameter 1 for function CreateRecord.(2,116) when Creating Order if Organization Hierarchy is set to 1. (Doc ID 1554256.1)

Last updated on FEBRUARY 04, 2019

Applies to:

PeopleSoft Enterprise FIN Pay/Bill Management - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.


 When Creating Order under Staffing there is an error Message"Invalid Parameter 1 for function CreateRecord.(2,116)" if setup used for Organization Hierarchy is set to 1. No issue occurs if it was set to 2 .

Setup steps :

-Navigate to :Installation options > Project Costing: Check the box : "Enable Organization”
-Navigate to : Setup Financials > Product Related > Project Costing >General Options >Organization Hierarchy: Set the field  “Number of chartfields” as : 1 . Then Save.

Replication Steps:


  1. Navigation : Staffing > Order and Assignment > Add /update orders.
  2. Add order with the following example information :  e.g:Field  "Branch"=CA001, Field  "User order type" = STFTM
  3. Enter Order Information then Click on tab: "Resource Request" and complete the information .
  4. Make sure to set Field "Order Status" to Unfilled under tab : Order and then Click "Save"

Actual Result:

The following error message appears:

Invalid Parameter 1 for function CreateRecord.(2,116) FUNCLIB_PC.FUNCLIB.FieldFormula Name:GetSetidClause
Called from SA_ORGPRJ_DEFN.PRJ_LEVEL2_CF_VAL.FieldChange Statement:4 Occurred during Project Owning creation (18071,217)FO_UTILITIES.CI.CIHandler.OnExcute Name:errorHandler
Called from:FO_UTILITIES.CI.CIHandler.OnExcute Name:Save
Called from:FO_ORDERS.BUSINESS_OBJECTS.Order.OnExculte Name:CreatePSAOwn

Expected result:

When creating order and having set the Organization Hierarchy to level "1"  then Pay/Bill Management should automatically creates a project.

Issue impact :

Staffing forces the Project Organization to be on levels "2" where the business process requires to be on Level "1"

The 1st level the GL BU and the 2nd level is the department.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.