My Oracle Support Banner

The date range for a child record must be within the date range of its parent record. (Doc ID 2471857.1)

Last updated on AUGUST 27, 2023

Applies to:

Oracle Fusion CX Sales Cloud Service - Version 11.13.18.05.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.18.05.0 version, Accounts, Contacts, Households

Error when sending request to web service crmService/CustomerAccountService.

ERROR
-----------------------
HZ_DE_INVALID_DATERANGE
HZ-120150
The date range for a child record must be within the date range of its parent record.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use web service crmService/CustomerAccountService.
2. Send the request:
<typ:processCustomerAccount>
<typ:changeOperation>Create</typ:changeOperation>
<typ:customerAccount>
<cus:PartyId>300000037978397</cus:PartyId>
<cus:AccountNumber>2018102603</cus:AccountNumber>
<cus:AccountTerminationDate>9999-05-20</cus:AccountTerminationDate>
<cus:AccountName>2018102603</cus:AccountName>
<cus:CreatedByModule>HZ_WS</cus:CreatedByModule>
<cus:CustomerAccountSite>
<cus:PartySiteId>300000037978398</cus:PartySiteId>
<cus:OrigSystemReference>300000037978398</cus:OrigSystemReference>
<cus:CreatedByModule>HZ_WS</cus:CreatedByModule>
<cus:SetId>300000018628978</cus:SetId>
<!---->
<!--cus:EndDate>9999-05-20</cus:EndDate-->
<cus:CustomerAccountSiteUse>
<cus:SiteUseCode>BILL_TO</cus:SiteUseCode>
<cus:PrimaryFlag>false</cus:PrimaryFlag>
<cus:CreatedByModule>HZ_WS</cus:CreatedByModule>
<cus:EndDate>9999-05-20</cus:EndDate>
<cus:OriginalSystemReference>
<par:OrigSystem>FUSION</par:OrigSystem>
<par:OrigSystemReference>201810260301</par:OrigSystemReference>
<par:OwnerTableName>HZ_CUST_SITE_USES_ALL</par:OwnerTableName>
<!---->
<!--par:EndDateActive>9999-05-20</par:EndDateActive-->
<par:CreatedByModule>HZ_WS</par:CreatedByModule>
</cus:OriginalSystemReference>
</cus:CustomerAccountSiteUse>
<cus:CustomerAccountSiteUse>
<cus:SiteUseCode>SHIP_TO</cus:SiteUseCode>
<cus:PrimaryFlag>true</cus:PrimaryFlag>
<cus:CreatedByModule>HZ_WS</cus:CreatedByModule>
<cus:EndDate>9999-05-20</cus:EndDate>
<cus:OriginalSystemReference>
<par:OrigSystem>FUSION</par:OrigSystem>
<par:OrigSystemReference>201810260302</par:OrigSystemReference>
<par:OwnerTableName>HZ_CUST_SITE_USES_ALL</par:OwnerTableName>
<!---->
<!--par:EndDateActive>9999-05-20</par:EndDateActive-->
<par:CreatedByModule>HZ_WS</par:CreatedByModule>
</cus:OriginalSystemReference>
</cus:CustomerAccountSiteUse>
</cus:CustomerAccountSite>
<cus:OriginalSystemReference>
<par:OrigSystem>FUSION</par:OrigSystem>
<par:OrigSystemReference>2018102603</par:OrigSystemReference>
<par:OwnerTableName>HZ_CUST_ACCOUNTS</par:OwnerTableName>
<!---->
<!--par:EndDateActive>9999-05-20</par:EndDateActive-->
<par:CreatedByModule>HZ_WS</par:CreatedByModule>
</cus:OriginalSystemReference>
</typ:customerAccount>
3. The error occurs

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get a successful response.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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