EiS Projects Datamart Submit


This report/process populates Projects Measures for all valid projects/tasks on PA Period and GL Period levels in EiS Project datamart for given date of Range. These numbers are used for reporting purpose in Projects module. This process needs to be scheduled to run as a nightly job. It will consider Last Run Date as the Start Date of the datamart process to populate the Projects datamart with incremental data. The process is scheduled to do a nightly run. This can also be executed on demand (manually) as and when required. This process is run by Oracle E-Business Suite Developer/System Administrator.


To run EiS projects datamart submit:

  1. Navigate to Reports > All Reports.
  2. Search for EiS Projects Datamart Submit in all reports tab.
  3. Click on Run icon to navigate to Submit page.
  4. Click on Submit button to run the process.

EiS Projects Datamart Submit Parameters


Responsibility: Select a valid EBS responsibility from Responsibility drop down.


Start Date: This parameter has to be kept blank when the process is scheduled as Nightly job. System will consider Last Run Date of datamart as a Start Date. This parameter will be required to fetch valid projects for which project datamart will be populated.


End Date: This parameter has to be kept blank when the report is scheduled as Nightly job. System will consider Current System Date of datamart as the End Date.


NOTE:

  • Running the process manually with passing Start Date and End Date will check for the projects valid for given date of range. It will process for all valid PA and PA period for the list of projects fetched using given range of parameter and will populate the project datamart.
  • Last Run Date will be saved automatically when the processing will complete for current Run. In addition, Last Run Date can be changed to any Previous Date in Projects datamart settings.
  • To change Last run date manually, navigate to Setup > Projects > Settings. Change the Last Run Date manually and Save changes.


Threads: This parameter is required to run the process with multi-threading processing. It will invoke more number of threads for same process at the back end to complete the process fast and swiftly.


Debug: This parameter is required to debug the execution of initialization process. If this is passed as Yes, it will log additional information which is more relevant to System Administrator and Developers to debug the issues. User can run the report with default value as No.