Skip to Content
author's profile photo Former Member
Former Member

Grants Master data and Line item update to DSO

Hi All,

In am working on Grants Management. I have activated the standard grants line item & Budget DataSource and DSO's

We have a master data table GMGR which has key as Grant Number(0GRANT_NBR) but the standard DSO's as mentioned above, do not have Grant number as keys but have Ledger number, and Ledger Item Number as keys.

I have 2518 line item records and 16 master data records. When I am combining both into a DSO with key as 0Grant_NBR. Only 16 records are getting updated as master Grant numbers are only 16 and the line items are not being updated can some one suggest, what is going wrong.

Appreciate your time.

Kind Regards

James

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jan 30, 2012 at 03:21 PM

    Hi,

    You need to check the key fields of your DSO.Because based on the unique combination of value only it is going to update a new record and with same combination its going to overwrite.

    Please try to make a proper selection of keyfields and after that everything will fall in place.

    Hope it helps.

    Regards,

    AL

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 31, 2012 at 05:31 AM

    Check the field map for 0GRANT_NBR.

    What is delta mode for that datasource in ROOSOURCE. If it ABR - change update property of DSO KF to Summation instead of Aggregation.

    Check rule groups at transformation level.

    Check weather data arrived to PSA or not.

    Plz update the status.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.