1941497 - Checkpoints for Consolidation Issues for SAP Business Planning and Consolidation (BPC) | SAP Real-time Consolidation (RTC)

• This KB is addressing the trouble-shooting of Consolidation process in SAP Business Planning and Consolidation (BPC), version for SAP NetWeaver or version for SAP BW/4HANA
• Component for reporting cases:
• Embedded Model: BW-PLA-BPC-TDL
  
• Standard Model: EPM-BPC-NW-TDL
• RTC model: FIN-RTC
• Find BPC model info in:
• SE16: Embedded Model: RSBPCA_APPL
• SE16: Standard Model: UJA_APPL
• If above tables are empty, it indicates BPC is not in use. 
   
• For other group reporting in consolidation/elimination process in non-BPC products: 
• Possible Componentss:
• FIN-CS : SAP S/4HANA Cloud - Group Reporting - Consolidation Process - Consolidation Monitor
• FIN-SEM-BCS: SAP S/4HANA - Business Consolidation (SEM-BCS)
  
  
• Consolidation process/task successful, but results are incorrect or wrong in SAP Business Planning and Consolidation (BPC) | SAP Real-time Consolidation (RTC) model:
• Consolidation results are incorrect.
• No results in the consolidation model.
• Consolidation result is doubled when you run the same period twice.
• Consolidation tasks via consolidation monitor or data manager packages do not generate expected results.
• Business rules are not triggered.
• No consolidation data is written into S/4HANA RTC Tables: ACDOCC.
   
• Error Task Status:
• Error "INVALID MEMBER [ENTITY]"
• "AMDP SQL error - code(287): cannot insert NULL or update to NULL" in consolidation monitor
   
• Poor performance via consolidation monitor or data manager package

Read more...

• SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver (Standard Model or Embedded Model)
• SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver (Standard Model or Embedded Model)
• SAP Business Planning and Consolidation 11.0, version for SAP BW/4HANA (Standard Model or Embedded Model)
• SAP Business Planning and Consolidation 11.1, version for SAP BW/4HANA (Standard Model or Embedded Model)
• SAP Real-time Consolidation (RTC) in SAP S/4HANA (BPC Embedded Model)
• SAP S/4HANA 1610
• SAP S/4HANA 1709
• SAP S/4HANA 1809
• SAP S/4HANA 1909
• SAP S/4HANA 2020

SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver ; SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver ; SAP Business Planning and Consolidation 11.0, version for SAP BW/4HANA ; SAP Business Planning and Consolidation 11.1, version for SAP BW/4HANA

checkpoint, BPCNW, Elimination rule，Intercompany Elimination， Elimination， Business Rules，Consolidation Run，Eliminations and Adjustments，Legal Consolidation，Consolidation Monitor, Ownership Monitor， Parallel consolidation， TSV_TNEW_PAGE_ALLOC_FAILED， "CL_UJP_CONSOLIDATION"，  STRING_SIZE_TOO_LARGE in "CL_SQL_STATEMENT， ENABLE_PARALLEL_EXECUTION， MAX_SESSION_COUNT， PARALLEL_SERVER_GROUP， ENABLE_PARALLEL_CONS， LARGE_VOLUME_FACTOR， RZ12， parallel_generators， PARALLEL_EXECUTION， RUN_PROGRAM CONSOLIDATION， RUN_PROGRAM US_ELIM，VARSCP，  FLOW, VARSCPMETH:  flow for method change， VARSCPPERC:  flow for percentage change， VARSCPNEW:   flow for new incoming companies， VARSCPLEAV:  flow for leaving/sold companies，  Currency dimension， Intercompany， OWN_PERIOD， Incremental Consolidation， CONS_INTEGRATION_ENABLED， integration flag, UJ0_PARAM_APP ,  'DATASRC_TYPE' , 'IS_CONVERTED' , OWN_PERIOD , STORE_GROUP_CURR , STORE_ENTITY , wrong, currency conversion error, ownership, data, delete, entity, RTC, embedded, BPC 11, BW/4HANA, Error while executing elimination business rules   , KBA , incorrect consolidation data is doubled , structure ownership , bpc nw consolidation kba consolidation c , consolidating , elimination level , consols , consolidation , troubleshooting , dm , slow , ie , perf , too long , conso , inter comp elim , dim , EPM-BPC-NW-TDL , Business Rules back-end , BW-PLA-BPC-TDL , Consolidation , EPM-BPC-NW-CC , Consolidation Central , EPM-BPC-BW4-CON , BPC/4 - Consolidation, Controls, Journals , FIN-RTC , Real-Time Consolidation , How To