Skip to Content
avatar image
T. Vierhout

BPC Delta load, rejected records are not loaded in the subsequent run

Oct 18, 2017 at 02:22 PM | 111 Views

Situation at one of my clients:

The have a new account in the account structure. This is loaded during the nightly loads into BW. However, this load failed, the account is now not in BPC. During the delta load, the records for this account have been rejected. This all works fine. However, in the delta load I have flagged KEEP_REJECT_DATA to be 1. We add the missing account to BPC, but the next time the delta load is executed, the missing records are not loaded into BPC.

Is there something else I need to configure in order for this to work?

SAP Business Planning and Consolidation, version for SAP NetWeaver
delta load
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Vadim Kalinin
    Oct 18, 2017 at 02:31 PM

    Can you provide a full details on your Delta load?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    T. Vierhout
    Oct 18, 2017 at 02:54 PM

    Sure.

    We are loading data from a cube with financial data, which has 0ACCOUNT in it as an object. We filter on:

    Fiscal year between 2017 and 9999
    Currency type = 10

    For the options, when executing the package, we have selected:
    Run default logic = 0
    Check work status = No
    Keep rejected data = Yes, keep the rejected data for the next delta loading

    Below is the script that is called in the data manager package:

    PROMPT(INFOPROVINITNAME,%INFOPROV_INIT_NAME%,"Please select delta initialization")
PROMPT(RADIOBUTTON,%RUNLOGIC%,"Select whether to run default logic for stored values after importing",1,{"Yes","No"},{"1","0"})
PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when importing data.",1,{"Yes, check for work status settings before importing","No, do not check work status settings"},{"1","0"})
PROMPT(KEYDATE,%KEYDATE%,"Key date",0)
PROMPT(RADIOBUTTON,%KEEPREJDATA%,"IF Keep Rejected Data",0,{"Yes, Keep the rejected data for the next delta loading","No, Do not keep the rejected data for the next delta loading"},{"1","0"})
INFO(%TEMPNO1%,%INCREASENO%)
INFO(%TEMPNO2%,%INCREASENO%)
INFO(%KEYDATE%,)
TASK(/CPMB/SOURCE_DELTA_IP,OUTPUTNO,%TEMPNO1%)
TASK(/CPMB/SOURCE_DELTA_IP,INFOPROV_INIT_NAME,%INFOPROV_INIT_NAME%)
TASK(/CPMB/SOURCE_DELTA_IP,BYPASS_COMPRESS,0)
TASK(/CPMB/SOURCE_DELTA_IP,KEEP_REJECT_DATA,%KEEPREJDATA%)
TASK(/CPMB/INFOPROV_DELTA_CONVERT,INFOPROV_INIT_NAME,%INFOPROV_INIT_NAME%)
TASK(/CPMB/INFOPROV_DELTA_CONVERT,OUTPUTNO,%TEMPNO2%)
TASK(/CPMB/INFOPROV_DELTA_CONVERT,SUSER,%USER%)
TASK(/CPMB/INFOPROV_DELTA_CONVERT,SAPPSET,%APPSET%)
TASK(/CPMB/INFOPROV_DELTA_CONVERT,SAPP,%APP%)
TASK(/CPMB/INFOPROV_DELTA_CONVERT,INPUTNO,%TEMPNO1%)
TASK(/CPMB/INFOPROV_DELTA_CONVERT,KEYDATE,%KEYDATE%)
TASK(/CPMB/APPEND_LOAD_DELTA_IP,INPUTNO,%TEMPNO2%)
TASK(/CPMB/APPEND_LOAD_DELTA_IP,RUNLOGIC,%RUNLOGIC%)
TASK(/CPMB/APPEND_LOAD_DELTA_IP,CHECKLCK,%CHECKLCK%)
TASK(/CPMB/APPEND_LOAD_DELTA_IP,INFOPROV_INIT_NAME,%INFOPROV_INIT_NAME%)
TASK(/CPMB/APPEND_LOAD_DELTA_IP,PREPROCESSMODE,0)
TASK(/CPMB/APPEND_LOAD_DELTA_IP,TARGETMODE,0)
TASK(/CPMB/APPEND_LOAD_DELTA_IP,KEYDATE,%KEYDATE%)
    With kind regards,

    Tim

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    T. Vierhout
    Aug 02 at 06:47 AM

    I was able to fix the issue by applying the following notes:

    https://launchpad.support.sap.com/#/notes/2154655

    https://launchpad.support.sap.com/#/notes/2400369

    Add comment
    10|10000 characters needed characters exceeded