0RECORDMODE field values updated incorrectly - 0FI_AP_4 data source

[former_member394400]

Dear All,

we have and issue with 0recordmode field in the datasource 0FI_AP_4 , as per our analysis the field has other values instead of the normal update image values like "X","S" etc.

Due to this it gives an error during activation at DSO level as shown below:

Record mode Y unknown (data record REQU_56LNKEF0PAMAN4M0ZVO3B1A8Y/000001/ 1895), activation failed [RSDRO118]

---

Process 000001 returned with errors [RSODSO_PROCESSING006]

---

Activation of M records from DataStore object 0FIAP_O03 terminated [RSM1102]

Has anyone faced a similar issue ? how is the 0recordmode field updated ?

[former_member210321]

Hi,

The records with Y , are delta load or full load?

Regards,

[D_Chia]

in the transformation screen, 0RECORDMODE for DSO is only shown when you have toggled Details View i think.

then you'll see the rule set view that shows the line from source box --> target box (with recordmode as a line within it)

any changes made recently in relation to this target field?

if there's nothing fishy in the graphic flow view ... perhaps check if any routines are written with logic to populate it within that transformation

[former_member394400]

Hi Chia,

Thanks for the input,

0RECODMODE field values are incorrect in the PSA itself. there were no changes recently and the mappings are correct.

[D_Chia]

if that is the case then it is obviously the application data itself which already got commited with such a value and it was extracted as-is to BW

OR

a logic in an enhancement in the source system which populated a related field which such 'invalid' value (as this relates to a standard DSRC... it is usually the 'cancellation' or 'reversal' field type of column in the data)

OR

the value within transaction data record is correct as per application but was not converted to a 0RECORDMODE compliant value eg.  in table level a field called CANCEL has value 'Y'... instead of transferring it directly to BW ... it's suppose to be converted to a valid value like 'X', etc.  this could be done at source (before it reaches PSA) .. or in BW transformation before it's mapped to 0RECORDMODE