My Oracle Support Banner

Update Sales Order Resequencer Group (Doc ID 3009853.1)

Last updated on MARCH 26, 2024

Applies to:

Oracle Communications Billing and Revenue Management - Version and later
Information in this document applies to any platform.


Update Sales Order resequencer Out Of the Box(OOB) works on group id= CUSTOMERPARTY_ACCOUNTID ($in.UpdateSalesOrderEBM/imp1:UpdateSalesOrderEBM/ns6:EBMHeader/ns6:Sender/ns6:ObjectCrossReference/ns6:SenderObjectIdentification/ns6:AlternateObjectKey/ns6:ID[@schemeID='CUSTOMERPARTY_ACCOUNTID' and @schemeAgencyID='COMMON']) (As per data it is seen this is Customer Account(CA) - that is parent in account hierarchy) along with sequenceMode=BestEffort and sequenceIDExpression= $in.UpdateSalesOrderEBM/imp1:UpdateSalesOrderEBM/ns6:EBMHeader/ns6:CreationDateTime , sequenceIDDataType=dateTime , maxRowsRetrieved=0 , timeWindow=1.

In the current project, customer have account hierarchy and also need to support child orders from Siebel (child orders are for the same CA account) , if any update sales order milestone for any order on that CA account is faulted , then next update sales order milestones for other orders on the same CA wont be published from Application Integration Architectures (AIA) to Siebel and will keep on running until the 1st fault is cleared via resubmitted or the lock is released from resequencer table.
In this scenario, where customer have thousands of child orders on the same Customer Account having same Billing Account but different Service Account and due to any environment issue if any update sales order milestone failed to connect to Siebel and faulted, customer need to identify that and resubmit to get the next updates getting complete - however it looks to be a big overhead for operations in production environment.
In this business use case: Can customer use SALESORDER_ID as group id for this resequencer?



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

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