1941497 - Checkpoints for Consolidation Issues for SAP Business Planning and Consolidation (BPC) [Standard | Embedded Model]

• 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 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 ownership PCTRL POWN   , 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