Issues while executing Jobs - Rapid Mart Accounts Payable

33 Views

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