Issues while executing Jobs - Rapid Mart Accounts Payable

[Former Member]

Hello,

We are implementing A/c Payable rapid marts at customer location.

We installed dataservices and above it installed RM AP XI3.0.

We successfully configured source and target DS.

When we validated the Jobs ,

we faced the following error :

[Query:SetLoadDateTime]

Invalid mapping expression for column <SetLoadDateTime.EXCHANGE_TYPE_ID>. Additional information: <Cannot parse expression.

Column <EXCHANGE_TYPE_ID> was not found in table <Effective_Date_1>. Please check the spelling of the referenced column and ensure such a column exists in the table.. (BODI-1112351)>. (BODI-1111081)

[Query:SetLoadDateTime]

Invalid mapping expression for column <SetLoadDateTime.FROM_CURRENCY_ID>. Additional information: <Cannot parse expression.

Column <FROM_CURRENCY_ID> was not found in table <Effective_Date_1>. Please check the spelling of the referenced column and ensure such a column exists in the table.. (BODI-1112351)>. (BODI-1111081)

[Query:SetLoadDateTime]

Invalid mapping expression for column <SetLoadDateTime.TO_CURRENCY_ID>. Additional information: <Cannot parse expression.

Column <TO_CURRENCY_ID> was not found in table <Effective_Date_1>. Please check the spelling of the referenced column and ensure such a column exists in the table.. (BODI-1112351)>. (BODI-1111081)

and some more errors with same query SetLoadDateTime.

We uploaded the file "fiscal_dates.dat" in the SAP server "
JUB02SAPJRD\BO_SHARE" ( which is used in DS setting )

as mentioned in the Installation log.

Would really appreciate any pointers wrt this issue.

Thanks and regards,

Vinay

[former_member202078]

1. Can you check whether the System User ID with which Data Services try to fetch the auxillay files placed folder?

2. How did you test the configurations? Have test run any job to test all the connectitivities required?