Error: 'The opportunity could not be imported because of an error in the child entity table MOO_IMP_REVN. (MOO-450120)' (Doc ID 1618760.1)

Last updated on FEBRUARY 16, 2017

Applies to:

Oracle Fusion Opportunity Management - Version 11.1.7.0.0 and later
Oracle Fusion Opportunity Management Cloud Service - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Goal

How to update a revenue line status from WON (closed status) to OPEN (open status) on an existing Opportunity record?

When attempting to change existing opportunity status from CLOSED to OPEN via file import, the following error occurs.

 

ERROR

The combination of attributes (STATUS_CODEACTUAL_CLOSE_DATE) is not valid. (MOO-450119) The opportunity could not be imported because of an error in the child entity table MOO_IMP_REVN. (MOO-450120) The value of the attribute CLOSE_REASON_CODE is not valid. You must provide a value that exists in the lookup type MOO_WIN_LOSS_REASON. (MOO-450107)

 

Data Input file used (csv format)
Opportunity Number Revenue Number Revenue Status Close date Sales Credit code Win Probability UOM Quantity Win/Loss Reason Actual Close date Inventory Item Id Inventory Org Id Product Group Id
6035 5117 5,500 OPEN 02-01-14 QUOTA 75 zzy 2 <blank> <blank> 300000000634389 300000000624383 <blank>
6028 5091 5,500 OPEN 02-01-14 QUOTA 75 zzy 3 <blank> <blank> 300000000634389 300000000624383 <blank>
7021 6041 5,500 OPEN 2/15/2014 QUOTA 75 zzy <blank> <blank> <blank> 300000000634389 300000000624383 <blank>
6044 5140 5,500 OPEN 02-01-14 QUOTA 75 zzy 5 <blank> <blank> 300000000634389 300000000624383 <blank>
<blank> 5141 5,500 OPEN 02-01-14 QUOTA 75 zzy 0 <blank> <blank> 300000000634389 300000000624383 <blank>
<blank> 5142 5,500 WON 02-01-14 QUOTA 75 zzy 7 GOOD_LEAD 02-01-14 300000000634389 300000000624383 <blank>
7028 6056 5,500 OPEN 2/17/2014 QUOTA 75 zzy 8 <blank> <blank> 300000000634389 300000000624383 <blank>
8016 6185 5,500 OPEN 02-11-14 QUOTA 75 zzy 0 <blank> <blank> 300000000634389 300000000624383 <blank>
8021 6195 5,500 OPEN 02-11-14 QUOTA 75 zzy 10 <blank> <blank> 300000000634389 300000000624383 <blank>

 

Mappings

Opportunity Number Opportunity OptyNumber

revnOpportunity Number OpportunityRevenue OptyNumber
Revenue Number OpportunityRevenue RevnNumber
Revenue OpportunityRevenue RevnAmt
Status OpportunityRevenue StatusCode
Close date OpportunityRevenue Effective Date
Sales Credit code OpportunityRevenue SalesCreditTypeCode
Win Probability OpportunityRevenue WinProb
UOM OpportunityRevenue UomCode
Quantity OpportunityRevenue Qty
Win/Loss Reason OpportunityRevenue CloseReasonCode
Actual Close date OpportunityRevenue ActualCloseDate
Inventory Item Id OpportunityRevenue InventoryItemId
Inventory Org Id OpportunityRevenue InventoryOrgId
Product Group Id OpportunityRevenue ProdGroupId

 



Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms