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 laterInformation 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 |