I am getting the error ( field integrity exception: Type, Quantity, unknown ) while creating an opportunity line item schedule in a flow in production. I am unable to reproduce this issue in sandbox.

Below is the excerpt from the error email I am getting. Usually I get this error when Revenue field value is not passed. As you can see, I am getting the error though I am passing valid value into Revenue field. Could anyone throw some insights as to what could have caused this error?

Create one OpportunityLineItem record where:
Description = {!OppLineItemRecord.Description} (closed)
OpportunityId = {!newOpportunityID} (0061R00000tkU49QAE)
PricebookEntryId = {!OppLineItemRecord.PricebookEntryId} (01u36000009qcuHAAQ)
ServiceDate = {!DynamicAssignmentDate} (November 1, 2019)
Spend_End_Date__c = {!OppLineItemRecord.Spend_End_Date__c} (December 31, 2019)
Transitions_helper__c = in transition
A record is ready to be created when the next screen, pause, or local action is executed or when the interview finishes.
{!newOppLineItem} = 00k1R00003eJeMJQA0

Create one OpportunityLineItemSchedule record where:
Description = {!RSdescriptionText} (Transitioned from opp: 0061R00000pF5LfQAK due to sales rep transition)
OpportunityLineItemId = {!newOppLineItem} (00k1R00003eJeMJQA0)
Revenue = {!SplitRSsecondRevenue} ($57,362.64)
ScheduleDate = {!DynamicAssignmentDate} (November 1, 2019)
Type = Revenue
Failed to create record.

Error Occurred: This error occurred when the flow tried to create records: FIELD_INTEGRITY_EXCEPTION: field integrity exception: Type, Quantity, unknown (invalid quantity/revenue for given type). You can look up ExceptionCode values in the SOAP API Developer Guide.```
  • 1
    Check if Revenue is getting overwritten from some automation, if something is trying to nullify Revenue after insertion os schedule, you might run into this error. Also, If you have both the Revenue and Quantity schedule, you need to provide both Quantity and Revenue. Also, check these field values on the line items HasRevenueSchedule and HasQuantitySchedule . – rahul gawale Nov 6 '19 at 8:29
  • We don't have trigger/process/workflow rule on Opportunity line item schedule object. We don't have Quantity schedule enabled. So I am expecting different error message since quantity schedules is disabled. Am I missing anything else? – Suneel Nov 6 '19 at 14:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.