Monday, February 08, 2016

India Post releases booklet

Member (Planning), Postal Services Board, Shekhar Kumar Sinha, going through the booklet 'Aikya' brought out by India Post along with the First Day Cover and Commemoration Stamp on the International Fleet Review-2016 in Visakhapatnam on Sunday.—Photo: C.V. Subrahmanyam

India Post that released a First Day Cover and stamp to commemorate the International Fleet Review 2016 has gone one step ahead and published a booklet on the relevance of the event.

Releasing the booklet – Aikya – at a function here on Sunday, Member (Planning) Postal Services Board Shekhar Kumar Sinha appreciated the efforts taken by Visakhapatnam Post Master General Sharda Sampath and her team on putting together the information and photos on previous Fleet Reviews conducted in India and also the first edition of the International Fleet Review conducted in 2001.

The Philatelic Department had taken up activities beyond simple publication and sale of commemorative stamps and first day covers, he said.

The Philatelic Bureau was organising an annual letter writing contest for students in October. The India Post was asking the principals of schools to organise regular letter writing competitions to help in character building of students.

The wait for letter to be delivered once it is posted helps inculcate patience, secondly once the letter is in the post box one has to have faith in the Postal Department this inculcates a value of trust among the students, Mr Sinha explained.

He called upon the philatelists and philately organisations to actively encourage the next generation to take to the king of hobbies – Philately – and disseminate their passion to the next generation, he said.

Post Master General Visakhapatnam Region Sharda Sampath explained the efforts that went into compiling the book and acknowledged the cooperation of Command Education and Welfare Officer Commodore Amit Vikram, Captain Dorai Babu and Commander Murthy in getting the official information on past events.

While the underlying theme of IFR was unified through oceans marking unity among the navies, the organising of the event played a major role in bringing together different government departments, Post Master General Vijayawada Region M. Sampath remarked.


The booklet not only carries information on the event but also has a crossed stamped First Day Cover, it is available at the Philatelic Bureau outlets in the city.

Member (Planning) Postal Services Board Shekhar Kumar Sinha appreciates efforts taken by Visakhapatnam Post Master General Sharda Sampath and her team on putting together the information and photos on previous Fleet Reviews conducted in India and also the first edition of the International Fleet Review conducted in 2001

36 lakh central govt. employees to go on indefinite strike from March 10

Over 36 lakh central government employees including Railways, Postal and Defence will go on indefinite strike from March 10, against NDA-led BJP government’s anti-labour policies.

Mr. Shiva Gopal Mishra, General Secretary, All India Railwaymen’s Federation and Convenor, India Railwaymen’s Federation (AIRF) said that the Central government is not according any priority to resolve long pending demands of its employees.

Railway employees will go on strike on February 11 & 12 to press their long pending demands.

Source : http://www.siasat.com/

NCCPA National Secretariat meeting at New Delhi on 07.02.2016

The National Secretariat meeting of the NCCPA was held on 07.02.2016 at New Delhi in library hall AIRF. Chairman Comrade Shiv Gopal Mishra, Com. KKN Kutty, SG and other members of Secretariat were present. 

The meeting discussed about the present situation after submission of recommendations by 7th CPC and formation of ECoS under Cabinet Secretary 

Com. KR, GS, AIPRPA and Comrades H.L.Sidhu (Treasurer); I.S.Dabas (ASG) also represented AIPRPA in this meeting.

Postal Directorate writes to DDG (Tech) to solve difficulties of employees in CBS/CIS migrated offices

Department starts acting on the letter written by SG, NFPE to Hon'ble Minister Communications & IT regarding untold sufferings by the staff of CBS & CIS roll out offices
Letter No.10-01/2016-SR dated 03.02.2016

CEPT Solution for Invalid Column Name

Sub Account Error invalid column Name 'sbcbizauxser'
  1. Up-gradation to Meghdoot 7.9.4 is not done properly at the PO as mentioned in the Release document. 
  2. Treasury database upgradation (In General-Upgradation to any meghdoot Update) has to be done at the end of the day's work at the PO. Otherwise, it can be done after doing day begin in Subaccounts /Treasury applications on the next day morning. 
  3. This may not be followed at the PO while doing Up-gradation to Meghdoot 7.9.4. Hence, the issue. Run the Treasury07122015.exl file of Meghdoot Update 7.9.4 once again to settle the issue from today onwards. 

MM Modules connection write error and Solution

While accessing the MM Application it may shown the error message like Run-time error '2147467259(80004005)' : Connection write (Wrapper write error).
The above error due to non accessing the databases from its application. please do the following to recover the database.
1.Update your system with latest updates for windows and SQL. 
2.Delete the old records after taking backup. 
3.Shrink the database using the utility available in ftp. 
4.Run the following query after taking backup of counter database. 
ALTER DATABASE counter SET SINGLE_USER dbcc checkdb ('counter',REPAIR_REBUILD )
ALTER DATABASE counter SET multi_USER 

Non Updation of Status of Meghdoot v7.9.4 in Parcel Net MIS

Solution for Status upgradation of MM 7.9.4

Some of the offices were listed in Non Updation list under ParcelNet MIS due to the some technical issue. If MM7.9.4 upgraded successfully and need to update in Parcel Net MIS , do the following which is given by CEPT.
  1. Please ensure that your office details configured in r net related modules are same as your office details available in r net central master data as the RNet Communication software communicates with the Server based on the pincode, nd code and Office Type selected in Point of Sale. 
  2. Please login to https://services.cept.gov.in/parcelnet/ ...Go to Other Reports -> Offices Not Upgraded to Version 7.93 ....click on the "click here" hyper link to download the zipped file containing the scripts to be run. After downloading, unzip the file and run the scripts using the script tool . 
  3. Please see the MIS next day morning. 
If the upgrdation status is still not updated,

please send copy of R Net Communication folder and PoS office details configuration screen through google drive for analyzing the issue. 

Book of Information 2013-2014 - Department of Posts

DOP Book of Information 2013-14


Browser setting for Viewing documents from McCamish

1.Adding URL in Trusted Sites:

Step 1: Go to “Tools” à “Internet Options”
Step 2: Select“Security”tab and then select “Trusted Sites”. Click “Sites” button.
Step 3: Uncheck the “Require server verification (https :) for all sites in this zone”, if it is checked. 
Step 4: Add following URLs in the “Add this website to the zone” one by one.
http://ip.indiapost.gov.in/
http://dms.indiapost.gov.in/
http://plireports.indiapost.gov.in
Step 4: Click on Close

2.  Paste the below URL on address bar and then enter.

http://dms.indiapost.gov.in/WorkplaceXT/ContainerLogin.jsp
Step 1: Go to “View” à “Webpage Privacy Policy”.
Press “ALT” + “F” on the keyboard if “Menu Bar” is not available

Step 2: Select any of the dms URL and click on ‘Summary’
Step 3: Select the option ‘How should cookie be handled as ‘Always allow this site to use cookie’. Click OK
Step 4: Click on ‘Setting’ button:

Step 5: Reduce Privacy setting to Accept all Cookie.

Step 6: Click OK and Close browser and reopen with PLI McCamish URL to view the documents from McCamish if required.

eDarpan, January 2016, news letter from CEPT is published

e-darpan, January 2016, news letter from CEPT is published for information of employees of the Department. The news letter contains the following
  • Bulk Closure of Complaints
  • Auto Status Updates for Complaints in CCC
  • Meet the Programmer Video Conference.
  • Release of Post Info 1.3
  • Release of Meghdoot 7.9.4
View /Download the news letter January 2016 edition

Latest CSV Uploading Process - PLI/RPLI McCamish

1. Pre-requisites for successful file upload: 

1) Pay Deduction and Meghdoot cash files are to be uploaded separately. If a single file has policies for pay deduction and cash, the policies will be reported in error. 
2) The PAO code of the pay deduction file should be correctly updated in the pay deduction file.
3) Prior to uploading Pay Deduction file, collection for the special group should be done through the collection module. 
4) Naming convention to be followed before uploading any file, so that any particular file can be identified easily. Every file should be named as ‘Office name_Schedule month_PAO Code (PAO code or Meghdoot)_XX(running number from 01).csv 
5) Every file, should be restricted to 1000 records, so that the files can be processed quickly thereby reducing the waiting period.
6) In Case of pay deduction file upload the policy should be a part of the special group, any policy which is not a part of special group will be error out. Special group search to be done before creating a new special group. 
7) In cases of Death, Maturity, Surrender, Survival claims it is advised to ascertain the premium in the respective policies and in case premium has been either deducted through pay deduction or entries are present in PRB, then the user first makes use of File upload functionality to upload the premium and once the premium is updated in McCamish the user indexes the above said claims. 
8) The policy statuses supported in the file are: AP, VL, IL and PM.

2. Out of scope functionalities 

1. Loan repayment will not be handled through bulk upload 
2. Policies for which service requests like Death claim and surrender requests have been indexed will not be handled, unless the requests have been withdrawn 
3. For pay recovery policies, if any extra amount is collected by DoP, then the same will not be uploaded by the csv once these validations are effective. 
4. Excess premium related validations are effective only on the new uploads. Any extra premium which is already uploaded in the system will be handled either through collection screen or through excess premium while doing any claim calculation.


3. Collection – Pay Deduction

Ø Click on the collection icon on Dashboard

Ø On the collection screen, select the ‘Special Group’ radio button and then select the ‘Renewal’ radio button
Ø Search the special group for which collection has to be made
Ø Select the schedule month and enter the payment details
Ø Click on the submit button to complete the payment for the special group
  • If Payment made through Cheque then select Cheque/DD

  • If Payment is through Book Adjustment (PLI Recovery Schedule given by Accounts branch) then select 
  • Book Adjustment
Ø Once the collection for special group is made, the user can upload the Bulk Pay Deduction file

4. Pay Deduction File upload 

Ø The user can upload the pay Deduction and Meghdoot file from the ‘Bulk Policy Upload/Group Policy Maintenance’ icon present on the system administrator’s dashboard.
Ø Two options will be provided to the user to go ahead with the file upload process, 

1. Special Group Number – If the user clicks on special group search and enters a special group number, the load file screen along with the transaction details of the special group will appear. 

From here the user can upload the pay deduction file. 
2. Office code - If the user enters the office code and clicks search, then the user can upload the Meghdoot file.

4.1 Process for Pay Deduction File Upload 
Ø Search the special group by name or number. 

Ø The transaction details of the collection made against the special group will appear in a grid below. 
Ø The user can proceed to upload file by clicking on the Load File Screen button.

Ø On the load file screen the user has to enter the billing dates and upload the pay deduction file which has to be in CSV format only. 
Ø On clicking the submit button, the upload file request will be submitted and a confirmatory message will be displayed to the user. A batch process will process this file. 

Ø The user can view the historical files by clicking on the View History button. The status will be changed from pending to complete once the batch is executed. The upload, success and error files can be viewed by clicking on the hyperlinks respectively.


  • All the policies which are not migrated and are uploaded through the file will be kept in a separate error file at the end of the day. 

5. CSV Uploading for Cash Policies 

Ø To upload Meghdoot file, the user has to search by office code. 


Ø The load file button will appear, on clicking the button, the user will be taken to the file upload screen. 


Ø The user can upload the Meghdoot file which has to be in CSV format only. On clicking the submit button, the CSV file upload request will be submitted. 

Ø The system will do UI validations on the file and throw errors for the impacted rows. 
Ø A batch process will upload and process the collections mentioned in the CSV file. 
Ø The user can see the historical files from the History tab.

6. UI Validations 

  • When the user uploads the file, the system will do the initial checks of the file and throw errors for the incorrect records. 
  • System validations will be made for all the mandatory fields. If any mandatory field is left blank or the format is incorrect, a validation message with the error description and the corresponding row and column will be shown on the screen.
  • The file will not be uploaded until all the validations are corrected and records are updated. Once all validations are clear then the file will be uploaded and a message will be shown that the file is successfully saved. 
  • For Pay recovery policies system will match the total amount for the group in suspense against the total premiums in the file. If the suspense amount is less than the total of premiums in the file, then a validation message will be thrown – suspense amount, total amount in group collection suspense is less than the total premiums in the file. 
  • This file will be in pending status only till the batch will process these payments.

7. CSV fields and UI validations

 Field Name
Mandatory/Optional
Acceptable formats
Example
UI Error messages
CIRCLE_CODE
Optional
alphabets
PAO_CODE
Conditional Mandatory
Mandatory if the file belongs to special group policies
alpha-numeric
PAO_SUB_CODE
Optional
NULL
POLICY_NO
Mandatory
alpha-numeric
Policy number cannot be blank
NAME
Optional
Only alphabets
SUM_ASSD
Optional
Numeric
LOAN_AVAILED
Optional
Numeric
PREM_AMNT
Mandatory
Numeric
Premium amount can’t be blank
DATE_MATURITY
Optional
Numeric
DATE_ENTRY
Optional
Numeric
AGENT_CODE
Optional
alpha-numeric
SCH_MONTH
Optional
Numeric
FROM_DATE
Mandatory
Numeric
dd-mm-yyyy dd-mmm-yyyy
From date can’t be blank/
Invalid date
TO_DATE
Mandatory
Numeric
dd-mm-yyyy dd-mmm-yyyy
TO date can’t be blank/
Invalid date
LOAN_PRINCIPAL
Optional
Numeric
LOAN_INT
Optional
Numeric
               
TOTAL_RECEIPT
Mandatory
Numeric
Total receipt Cann’t be blank
DEFAULT_AMT
Optional
Numeric

TOTAL_PAYMENT
Optional
Numeric

DATE_PAYMENT
Optional
Numeric

RECEIPT_PAYMENT
Mandatory
alphabet

DATE_TRANSACTION
Mandatory
Numeric
dd-mm-yyyy dd-mmm-yyyy
Date_transaction can’t be blank/
Invalid date
Transaction date can’t future date
TRANSACTION_TYPE
Mandatory
alphabet
P - for Pay
C - for Cash
Transaction Type cannot be blank
REBATE_AMT
Optional
Numeric

INTERIM_PAYMENT_NO
Optional
NULL

First_Year_Tax
Integer
Optional
Can be null or numeric
1. If transaction date>= 1 Jan 2015 and either FY tax or Renewal tax is not updated, then error message to be displayed- Service tax is required
2. If data type is other than numeric – Only numeric value accepted
Renewal_Year_Tax
Integer
Optional
Can be null or numeric
1. If transaction date>= 1 Jan 2015 and either FY tax or Renewal
Tax_Type
Integer
Conditional Mandatory
(Required if first year tax/renewal year tax is present)
1 for first year tax
2 for renewal year tax
3 for first year as well as renewal year tax
1.If FY tax/Renewal tax is updated and Tax Type is blank, then display error message - Tax Type is required
2. If data type is other than numeric – Only numeric value accepted
1. If the file format is of more than 28 fields, then display message – Invalid file. This will be a UI validation. 
2. The total receipt will be inclusive of total premiums + Interest – Rebate 
3. McCamish does not calculate if rebate/interest is correctly calculated. The system matches the total premiums + interest – rebate with total receipt and returns error if this amount is not found matching. 

4. If the total number of records in Meghdoot file are more than 1000, then an error message will be shown – ‘Maximum number of records to be uploaded should not be more than 1000’.

8. Batch Validations

Error Description
Scenario
Payment Record Creation Error
When the amount field is other than acceptable values like 'Null' or '0' or a decimal this error would come
Payment Record Creation Error
When there is any issue with the format of date field this error would come. Acceptable date format is DD-MMM-YY or DD-MMM-YYYY or DD/MM/YYYY or DD/MM/YY
Policy Not Available
If policy number is missing
PaidToDate does not match with From_Date
From date is not match with policy, paidtodate +1
Invalid Policy Status for Applying Premium
Policy status is not PM, AP, AL
Policy not Part of given Special Group
Policy not Belongs to the Special Group
Feed File Premium Amount or Total Receipt is zero
Amount Paid Is Zero
Feed File From_Date or To_Date is null
Feed File i.e. from_date or to_date is null
From_Date is not First Day of month or To_Date is not last day of month
From_Date is not First Day of month or To_Date is not last day of month
Total_Amount not matching with interests and rebates
TotalAmount in Feed file is less than Actual TotalAmount calculated from Application
Error creating PendEvnt
System related errors
Error updating PendEvnt
System related errors
Error updating Suspense
System related errors

8.1 Other Error messages 
1. If the amount of service tax is incorrect, then display error message – Service tax amount incorrect. This will be done in batch processing. 
2. If tax type 1 is updated with renewal tax and tax type 2 is updated with first year tax or if tax type 3 is updated with first year tax or renewal year tax, then display error message – Tax Type incorrect. This will be done in batch processing. 
3. If the total receipt amount does not include service tax, then update error message in the file as – Total receipt amount does not include service tax. 
4. The Meghdoot / Bulk upload batch will do validations on the uploaded file to check if any excess premium is uploaded.
5. In case of excess premium, the record will be rejected and the policy record will be updated in the error file with the following error description – “Total Premium is more than the frequency premium”. 

9 Service tax related changes 

> New columns to be added for Service Tax and Sales tax in Meghdoot Upload File and Bulk Upload File. The file template which can be downloaded from the screen to be changed. 
> The last three columns of existing file will be utilized for these 3 new fields. 
> Either Service tax or Sales tax column to be validated if the Transaction date(Receipt Date) is after 1 Jan 2015 
> Value in this column needs to be saved in Data base without any calculations involved if uploaded through Meghdoot Upload 
> No Accounting will be done for the service tax/sales tax if uploaded through Meghdoot. 
> For Bulk Upload, service tax/sales tax amount should be calculated and validated as per issue circle and rate mentioned as per the upload date. 
> The total_receipt column in the file should include the service tax component as well. 

Error message to be updated in the file if the total receipt amount does not match. 
To upload service tax and sales tax through upload file, the file format will be modified and three new columns will be added- 
1. First Year Tax 
2. Renewal Year Tax 
3. Tax type 
The validations for these fields are covered in Section 8. 

11 Excess Premium Validations 

11.1 Existing Business Process 
According to the current business process if the user uploads extra premium through the csv upload, the required premium amount is adjusted towards the premium for the months selected and the rest is kept in policy suspense. 
This suspense amount will be used when the user tries to pay future premiums through collection screen. If no further premium payment is made then this amount is shown as excess premium when the policy is settled towards claims. 

11.2 Problem Statement 
Many times users are uploading excess amount through csv upload. There are various reasons for this error: 
1. User mistake while uploading files when incorrect amount is entered 
2. Extra premium uploaded when policy frequency is changed 

11.3 Proposed solution 
To stop uploading excess premium from the csv, new validations will be built in the batch. If any excess premium is entered in the file which is more than the frequency premium, then the record will be rejected in the batch. 
An examples is mentioned below to upload the file in the correct manner: 
1. Policy no - R-TN-TC-EA-288371 
2. Paid to Date – 30-JUN-2006 
3. Policy Issue date – 1-APR-2006 
4. Frequency 
§ Monthly - 01-OCT-04 to 30-JUN-15 
§ Quarterly from 01-JUL-15 
5. Monthly Premium - 164 
6. Frequency Premium - 491 

The above mentioned policy has two frequencies since it was migrated as monthly policy and then it got converted to quarterly. 
To upload the premium for this policy correctly, user should create two records in the file. One record will have premium record for only monthly premium payments. The second record should have only quarterly premium payment record. 
Ø For the record with only monthly premium. ‘To Date’ and ‘From Date’ should be selected accordingly. The total premium (Total Receipt) should be equal to the number of months multiplied by the monthly premium amount. 
Ø To upload the quarterly premium, user should create another record and the select the ‘To Date’ and ‘From Date’ based on the quarterly frequency. The premium amount should be equal to the number of quarters multiplied by the quarterly premium. 

In the example --- 
Monthly premium is Rs.164 and no. of months to be updated are 108. So in total receipt column 164*108 = Rs.17712 will be updated. 
Similarly when quarterly premium has to be updated, the quarterly premium amount which is Rs.491 is multiplied by the number of quarters. Hence it is 491*1 = Rs.491. 
Ø This similar method will be used when premium frequency is half-yearly or annual. 

12 Transferring from one special Group to another special group 

Ø In case the special group of the policy is changed, the same can be updated in the system by the pay Deduction file. 
Ø The premium collection should be done on the new special group and the file should be uploaded using this group number only. 
Ø The new PAO code can be entered in the pay deduction CSV file and the system will change the PAO code of the policy.

DOP Finacle Guide for Inquiry on Bank Cheques

India Post Finacle Guide for Inquiry on Outward Clearing cheques

There are some cases where we need to inquire on Bank cheques sent from PO for clearance whether they sent correctly or not, whether they are cleared at Bank or not, whether they are realized at PO or not. For that India post finacle guide explaining the step by step detailed procedure for inquiry on a particular instrument.

Step By Step Procedure in Detail - India Post Finacle Guide

1.Invoke HOIQ menu
2.Enter Instrument No. which is nothing but cheque number
3.Click on SUBMIT(F10)
4.System will display some parameters like
a) Instrument Amount
b) Sort Code
c) Bank Code
d) Status of the Cheque (Whether Regularized or Not) etc.,
5.Click on the View details Icon for
a) Instrument Date
b) Enterer User ID
c) Verified User ID
d) Entry Date
e) Verified Date
f) Regularization Date (If Already Regularized)
g) Bank Name etc.,

OROP to cost Rs7,483 crore a year: Manohar Parrikar

Defence minister Manohar Parrikar said the One Rank, One Pension (OROP) scheme for the armed forces would cost the government Rs.7,483 crore a year even as veterans opposed to the government’s formula are moving the Supreme Court.

Parrikar said on Sunday that the revised pensions had been credited into the accounts of retired armed forces personnel by 31 January. In case it had not been disbursed by January-end, the money will be given from February.

A group of agitating veterans led by retired Major General Satbir Singh have enlisted the services of senior lawyer Ram Jethmalani to fight their case in the Supreme Court. They want the government to implement OROP according to the terms laid down by Koshiyari Committee.

“Every person in the country has the right to approach the court,” Parrikar told reporters at Visakhapatnam, where an international fleet review by the Indian Navy is underway. He was addressing the media after inaugurating an international maritime conference.

The OROP arrears from 1 July 2014 to 31 December 2015 would total Rs.10,980 crore. Parrikar, however, said a few “minor” issues remained and these will be addressed in line with the common formula.

He added that the government has increased the OROP amount by 21%. The annual amount dedicated to OROP is 15 times the Rs.500 crore allocation made by the previous United Progressive Alliance government, the defence minister said.

Veterans have been pressing the government to implement OROP, which will ensure a uniform pension to armed forces retirees with the same rank and same length of service, for the past 43 years. Implementation of OROP will have a “significant impact” on the country’s fiscal bill, HSBC Bank Plc said in September 2015, estimating a burden to the exchequer of Rs.16,000 crore in fiscal year 2015-16.

Apart from OROP, the centre will also have to make provisions to implement Pay Commission recommendations for 10 million government employees. It might have to set aside Rs.1.1 trillion to implement the recommendations and OROP, finance minister Arun Jaitley was quoted as saying by the Press Trust of India.