Skip to Content
0
Jun 20 at 07:00 PM

UJD_TEST_PACKAGE PROMPT BW

137 Views Last edit Jun 20 at 07:02 PM 2 rev

How to create the PROMPT file to include in this field within UJD_TEST_PACKAGE ?

The system being used is SAP BPC 10.0 with BW 7.3 an old standard version.

We are using a packet to integrate transactional data and as you can see in the image, the Work Status task is to be included as "Do not check work status". This was modified in the package instructions.

ORIGINAL INSTRUCTIONS

2022-06-20-14h36-45.png

NEW INSTRUCTIONS

2022-06-20-14h51-30.png

After this, the BW person made a change within the UJD_TEST_PACKAGE program manually by changing the PROMPT. I need to change the CHECKLCK to 0 as in the EPM package so it doesn’t check the working status.

2022-06-20-14h35-36.png

When executing the transactional data integration the following error arises;

2022-06-20-14h42-03.png

I’ve seen that PROMPT is a file, but I don’t know how I can get it. Could someone guide me in the right way to fix it?

The log that I download in UJFS was the last one that worked. But I do not know how I should assemble the PROMPT file to put in UJD_TEST_PACKAGE

<RESULT><PROMPT><![CDATA[%INFOPROV_INIT_NAME% ZBPC_C01_DELTA_INIT

%RUNLOGIC% 1

%CHECKLCK% 1

%KEYDATE% ]]></PROMPT><STATUS_STEP><![CDATA[/CPMB/MODIFY completed in 0 seconds

/CPMB/SOURCE_DELTA_IP completed in 8 seconds

/CPMB/INFOPROV_DELTA_CONVERT completed in 1 seconds

/CPMB/APPEND_LOAD_DELTA_IP completed in 197 seconds

/CPMB/CLEAR completed in 0 seconds]]></STATUS_STEP><MESSAGE><![CDATA[Task name SOURCE DELTA INFOPROVIDER:

User S_BWREMOTE run delta load from InfoProvider ZBPC_C01 with selection

<?xml version="1.0" encoding="utf-16"?><Selections><Selection Type="Selection"><Attribute><ID>0FISCPER</ID><Operator>3</Operator><LowValue>2015012</LowValue><HighValue>9999012</HighValue></Attribute></Selection><Selection Type="FieldList"><FieldID>0CHNGID</FieldID><FieldID>0CHRT_ACCTS</FieldID><FieldID>0COMP_CODE</FieldID><FieldID>0COSTCENTER</FieldID><FieldID>0CO_AREA</FieldID><FieldID>0CURRENCY</FieldID><FieldID>0CURTYPE</FieldID><FieldID>0FISCPER</FieldID><FieldID>0FISCPER3</FieldID><FieldID>0FISCVARNT</FieldID><FieldID>0FISCYEAR</FieldID><FieldID>0FUNC_AREA</FieldID><FieldID>0GL_ACCOUNT</FieldID><FieldID>0PART_PRCTR</FieldID><FieldID>0PCOMPANY</FieldID><FieldID>0PFUNC_AREA</FieldID><FieldID>0PROFIT_CTR</FieldID><FieldID>0PSEGMENT</FieldID><FieldID>0RECORDTP</FieldID><FieldID>0REQUID</FieldID><FieldID>0SEGMENT</FieldID><FieldID>0UNIT</FieldID><FieldID>0VALUATION</FieldID><FieldID>0VERSION</FieldID><FieldID>0VTYPE</FieldID></Selection></Selections>

Record count: 168

Task name CONVERT:

No 1 Round:

Reject count: 0

Record count: 168

Skip count: 120

Accept count: 216

Task name APPEND LOAD DELTA INFOPROVIDER:

Suppressed zero-value records: 107

Submit count: 216

Reject count: 0

model: FINANCE. Package status: SUCCESS]]></MESSAGE></RESULT>