How to break consolidation into inidividual transaction.

How to break consolidation into inidividual transaction.

Environment:

iVend Version 6.6 with SAPB1 9.2

Problem Statement:

How to break consolidation into individual transaction.

Symptoms:

Not Applicable

Resolution/Work Around:

Follow the below steps.
1. Take the SAP database backup
2. Stop the Replication on all stores and HO
3. Stop the Integration Service
4. Change the UseTransactionConsolidation to False in CfgEnterprise table

UPDATE CfgEnterprise
SET UseTransactionConsolidation = 0
WHERE UseTransactionConsolidation = 1

5. Change the IsConsolidated to False in ConTrxTransactionMapping table

UPDATE ConTrxTransactionMapping
SET IsConsolidated = 0
WHERE ConsolidatedTransactionKey = 'Put Consolidated Transactionkey'
AND IsConsolidated = 1

6. Mark the stuck event as success

UPDATE RepIntegrationLog
SET Flag = 1, Status = 0, ErrorMessage = 'Manual adjustment'
WHERE SourceType = 200 
AND SourceKey =  'Put Consolidated Transactionkey' 
AND Status = 1

7. Open the individual events

UPDATE RepIntegrationLog SET Flag = 0 
WHERE SourceType = 143 AND Flag = 1 
AND SourceKey IN 
(SELECT TransactionKey FROM ConTrxTransactionMapping 
WHERE     ConsolidatedTransactionKey =  'Put Consolidated Transactionkey')

8. Start the Integration Service
9. Once all the transactions are cleared from the integration monitor then reset the consolidation flag to true

UPDATE CfgEnterprise 
SET UseTransactionConsolidation = 1 
WHERE UseTransactionConsolidation = 0

10. Restart the Replication Service on all stores and HO

Recommendations /Suggestion:

The above activity must be done in non business hours and the integration/replication monitors must be cleared.



    • Related Articles

    • Break Consolidation into Inidividual Transactions

      ** Internal Notes for Support Team Only** Steps The below activity must be done in non business hours and the integration/replication monitors must be cleared. 1. Take the SAP database backup 2. Stop the Replication on all stores and HO 3. Stop the ...

    • Quote's and Sales orders (Source Type 143) are ignored when transaction consolidation in on

      ********************* For Internal use for Citixsys *********************** Version 6.5 and not the version-specific Issue Quote's and Sales orders (Source Type 143) are ignored by the iVend API (GetQueueWithoutStatusUpdate()) when transaction ...

    • Getting Error when configuring iVend to enable Transaction roll-up (Integration Consolidation)

      Issue: When configuring the iVend Enterprise to enable Transaction roll-up (Integration Consolidation) then getting the error "Could not save the business object". Below is the screenshot for the same: Resolution: One of the reasons for the above ...

    • Transaction Rollup/Consolidation "Could not save the business Object"

      Environment: iVend Version 6.6 7747 with SAPB1 9.2 Problem Statement: While enabling transaction Roll-up in the iVend Enterprise. It displays the error message on screen “Could not save the business Object”. iVend Enterprise MC Log file displayed the ...

    • Kit Item Break

      Product version: iVend 6.6 latest patch Problem statement: We have created items as Kit. These items in the Kit are individually selling items also. In some cases we just need to open the kit and sold these items individually In these cases how we ...