0 Replies Latest reply on Feb 20, 2015 2:02 AM by 2805987

    Restrict number of rows to be pulled from PeopleSoft's PS_LEDGER table while importing data in FDMEE

    2805987

      Hi,

       

      We need to know if FDMEE 11.1.2.3.520 product supports restricting number of rows to be pulled from PeopleSoft's PS_LEDGER table.
      All the records fetched from PS_LEDGER is getting loaded into TDATASEG table.

       

      Currently, it is trying to pull all the records based on the given "period", "version" and "year" combination. We are looking to restrict rows based on specific account/entity/program/subprogram combination.

       

      If this is can be done, will it be an out-of-the-box functionality or does it require any customization/import scripts/api.

      Admin guide does say we can use Jython to filter rows using import scripts. However, it seems to be limited to file not a table as a source.

       

      I have attached a document with the screenshots so that the issue is better understood !

       

      Thanks,
      Hari