Standard Operating Procedure (SOP) for generation of CBS file for APT 2.0

Standard Operating Procedure (SOP) for generation of CBS file for APT 2.0

Download SOP

Introduction

At present, CBS data can be fetched by APT 2.0 for SAME DAY Accounting only after SOL DAY END i.e. after HSCOD completion in Finacle by concerned CPCs. During the process, CBS data extraction was being done through a batch job, set up in HSCOD. During fortnight end, with huge volume of agent bulk list, HSCOD completion was getting delayed which in turn delayed extraction of CBS data. As such data fetch in APT 2.0 Treasury module had to wait for the CBS extraction.

In order to overcome this delay, CBS data extraction for SAME DAY Accounting has been delinked from HSCOD and a new menu CSMDAY is introduced in Finacle which can be executed by respective Post Office end itself.

New Process to be followed for CBS data generation at Finacle end from 02/08/2025

1. Supervisor role user of Post office concerned will execute HISCOD menu once the CBS transactions for the day are completed.
2. In case of any blocking validations, the same needs to be cleared by Post office concerned before executing HISCOD.
3. The New menu CSMDAY need to be Executed by Supervisor role user of concerned Post office once HISCOD is completed successfully. (Validations are built to ensure that the menu CSMDAY can’t be executed without HISCOD completion.)
4. This menu has 2 functions viz INQUIRE and EXECUTE.
5. INQUIRE will show the status of previous execution status of CBS file generation.
6. Ideally data extraction completion for previous day (if not holiday) will be shown.
7. Supervisor role user will invoke CSMDAY - EXECUTE option for generating CBS transactions data. On clicking submit option, result page will display the request submission status of the EXECUTE function.
8. In case, if the user invokes CSMDAY menu before initiating HISCOD for the SOL BOD Date, following error will be thrown.

Additional Notes:

• If the user tries to execute CSMDAY again for the same day, an error message will be displayed.
• Users shall use INQUIRE function to know the latest status of DATA Extraction before re-EXECUTING CSMDAY menu.
• If the user tries to Execute CSMDAY after completion of data extraction, an error will be thrown if data extraction is completed.
• Post offices should check whether the CBS data generation is completed for that particular day through INQUIRE option. An error message will be displayed if the data extraction is failed.
• In case if the data generation is failed due to any reason, Post offices need to re-Execute the menu CSMDAY – EXECUTE.
• Post offices can fetch CBS SAME DAY Accounting data in APT 2.0 end, only if the CBS data generation is completed successfully at Finacle end. Validations are built accordingly.
• This menu can be executed only by the supervisor of concerned SOL.
• It is re-iterated that CBS SAME DAY Accounting data will be generated only if CSMDAY menu is executed by SOLs concerned. This menu can be Executed even after HSCOD and till DC closure. This menu can be executed only for current date.
• Once this menu is executed, further Cash and Transfer transactions cannot be invoked.
• Cash and Transfer transactions will be enabled for all SOLs post DC closure.
• In case, if any post office desires to perform cash and transfer transactions, menu HOCST (Cash Transaction) and HOXFT (Transfer transaction) can be invoked by Supervisor role user only after SOL DATE change i.e. after HSCOD completion.
• This menu is not to be executed on holidays.
• Existing CBS SAME DAY Accounting data generation batches are removed from HSCOD. Post offices will not have any dependency on CPCs (HSCOD) for CBS same day accounting data generation.
• Appropriate errors will be passed to APT 2.0 end, if the user tries to fetch the data without executing CSMDAY menu in FINACLE or tries fetching data during data generation in Finacle.

NEW REPORTS

1. 4 New reports are deployed in Finacle for tallying CBS SAME DAY Accounting data in APT 2.0 daily account. These report(Today) can be generated only after execution of CSMDAY menu . For current date, consolidation and GL wise detailed report are to be generated in Finacle Production environment.
   • GL IT2.0 Transaction Report - Consolidated(Today)
   • GL IT2.0 Transaction Report - Detailed(Today)
2. For generation of previous day data, following reports from Finacle MIS server to be used
   • GL IT2.0 Transaction Report - Consolidated(Previous Day)
   • GL IT2.0 Transaction Report - Detailed(Previous Day)
3. Inputs fields for GL IT2.0 Transaction Report – Consolidated
   • Date - Mandatory field
   • Sol ID – Mandatory field (Report not available for SET ID)
   • BO Code – Non mandatory field
   • Channel Id – Non mandatory field
4. Detailed report can be generated GLwise only. GL is mandatory input field . Inputs fields for GL IT2.0 Transaction Report – Detailed Report
   • Date - Mandatory field
   • Sol ID – Mandatory field (Report not available for SET ID)
   • BO Code – Non mandatory field
   • Channel Id – Non mandatory field
   • GL Subhead Code– Mandatory field
5. CPRC reports can be generated in Finacle MIS server
6. Sample consolidation and detailed report attached for reference
• 126102-CONSOUDA
• TED-30062025-FINAL
• 12610200-Detailed Report- Final.pdf
• 60000298-CONSOUDATION-30062025-F