1

The "Project funding source" data entity (staging table ProjFundingSourceStaging) seems to require the "PartyNumber" field populating: when left blank for an import project, the error message below is logged.

 

"Results. The party ID specified does not exist. Results. validateWrite failed on data source 'ProjFundingSource (ProjFundingSource)'"

 

However, for records where the "FundingType" field is "Customer", it doesn't use that "PartyNumber" field for the customer lookup, but instead uses the "CustomerOrganization" field. This makes the message at best misleading, if not plain wrong: if the value isn't going to be used, it shouldn't fail validation when left blank.


Process:

  1. Ensure you have two customers, and identify their customer number & party number
  2. Ensure you have a project contract created
  3. Create a DMF input file for the Project funding source data entity specifying the project contract above & the customer number for one customer in the CustomerOrganization field and the party number for the other customer in PartyNumber
  4. Import through DMF
  5. Review the project contract
  6. Observe that the funding source added has used the CustomerOrganization field for the associated customer
  7. Create a copy of DMF input file, modifying it by removing the PartyNumber and changing the FundingSourceID
  8. Import through DMF
  9. Observe error The party ID specified does not exist. even though DMF isn’t going to use the party ID in question


STATUS DETAILS
New