1. User Guide
  2. Data Loaders
  3. Ledger Data Loader
  4. Setup for the LEDGER_STAT load utility
  5. Executing LEDGER_STAT Load Procedure

5.11.2.9 Executing LEDGER_STAT Load Procedure

You can execute this procedure either from SQL*Plus or from within a PL/SQL block or from Batch Maintenance window within OFSAAI framework.

To run the procedure from SQL*Plus, login to SQL*Plus as the Schema Owner. The procedure/batch requires the following 9 parameters:

  • BATCH_ID- Any unique number to identify the execution run.
  • MIS_DATE- Date on which the loading is done expressed in YYYYMMDD format.
  • TABLE_NAME- STG_GL_DATA(Type III) or any other load table (TYPE I or TYPE II)
  • TABLE_TYPE- FISCAL_ONE_MONTH or FISCAL_RANGE (TYPE I or TYPE II)
  • CALENDAR_MONTHS (TYPE III)
  • UPDATE_MODE- ADD/REPLACE
  • INSERT_ONLY- Y/N
  • START_DATE- Calendar start date in YYYYMMDD
  • END_DATE- Calendar end date in YYYYMMDD

The input parameter logic for the Type III, Type II and Type I tables.