8 Mistakes which you should never do in DOP Finacle

8 Mistakes which you should never do in DOP Finacle

8 Mistakes which you should never do in DOP Finacle

1) Never close the browser window without logging out.

2) Never do any transaction in Supervisor login

3) Do not use complicated passwords

4) System could not get response from server

5) No multiple CIFs for same customer

6) Do not forget HCASHPND transaction after cashclosures.

7) Do not forget to verify transactions

8) Do not share your password

https://drive.google.com/file/d/0B5ceVEjyB3diSVdkam9vY194YWc/view

CSV PREPARE TOOL for SOs & CPCs

Working Procedure

Highlights:

Import Policy details from Excel(optional)

ST calculated automatically.

Total Receipt including ST calculated automatically.

Type of ST,i.e,type-1,2,3 shown automatically.

You can change ST details, Circle, PAO details as per your required.

You can export single policy for csv, bulk policies and date wise also which is your convenient.

All necessary formulas for CSV file format were used.

User friendly and highly graphical interface. 

Note: 

1) Rename the attached file as " OCR_TOOL.rar "

2) Extract it to D:\ drive only.i.e., "D:\OCR_TOOL\"

Find video, for setup guide and working procedure.

tool for ssa lot

https://drive.google.com/file/d/0B81TXzQRVmqLSUhIMnZTczVCWDA/view

VERIFICATION OF ALL ACCOUNTS IN FINACLE BEFORE END OF FINANCIAL YEAR INTEREST CALCULATION

Important instruction: verification before End of Year interest calculation 

We are nearing the end of the financial year when interest calculation and posting are due for SB accounts. 

Post Offices advised to verify all the accounts which have been modified but verification is pending since interest posting for such accounts will fail resulting in complaints and tickets being raised for non-posting of interest. 

Unverified accounts can be listed by respective offices using the HAFI menu. Following are the fields to be entered in HAFI for finding out unverified transactions: 

Procedure to view the unverified accounts

Invoke the menu HAFI and enter the following details as mentioned below
Enter the SOL ID ____________
Enter the Table Short Name as "GAM"
In the Ref NO files "give two balnk spaces"
Enter the General Ledger Subhead code as _________
Enter the function code as "M" 

Select the Authorized option as "Not authorized" as mentioned in the below screen shot 

Following are the Genearl Ledger Subhead codes 

SB - 30001
PPF - 33001
NSS87 -30021
NSS92 -30022
RD -30010
TD 1 YR - 30011
TD 2YR - 30012
TD 3YR - 30013
TD 5YR - 30014
TD EXCEPTION - 30015
MIS - 30016
MIS EXCEPTION - 30017
SCSS DEFENCE - 30018
SCSS VRS - 30019
SCSS GENERAL - 30020.

After entering all the details then click on Go then the system will show the list of unverified accounts as shown in the below figure. 

Note that if any verificaiton is pending in DOP Finalce application then the system will not calculate the interest for such unverified accounts.So kindly verify immediately. 

MAHIPUR SO , GOLIVE TODAY 29.01.2016

Mahipur SO under CBS plat form since 29.01.2016 . Inagurated by Bikash Kumar Pradhan , Ganeshwar Sahoo,Bibhu Prasad Mishra & Kabiraj Nayak , special thanks to all the CBS Team Puri Division.It's another grand success to the Dept. Of Posts.

JAVA

CLICK HERE

FINANCLE PRINTER SETTING

CLICK HERE

CBS WORK FLOW

CLICK HERE

Working Functional Keys in DOP finacle

Working Functional Keys in DOP finacle

The Functional / Shortcut keys are available in the Finacle software which is developed by Infosys. But the modified version of Finacle in DOP is limited to access the shortcut keys.

Some of the working keys are listed below 

In Date Field while Press the Ctrl + X to Enter the BOD/Current date. This option may not work in some of the fields which is not configured with above shortcut.

DOP Finacle Menu for Refund TDS Amount of SCSS Account

1. Invoke HRFTDS menu
2. Enter Report To - PM
3. Enter Refund CIF ID - SCSS A/C CIF ID
4. Enter From A/C ID
5. To A/C ID will appear automatically
6. Select Tran. Type - Transfer
7. Click on GO(F4)
8. Select the concerned month.
9. Click on Add each time for multiple months selection.
10. Enter Refund A/C ID for each selection

a) SOLID+0340 for cheque
b) Customer's SB A/C ID for SB Transfer

11.Click on SUBMIT(F10)

SQL PRIMARY KEY

SQL PRIMARY KEY Constraint on CREATE TABLE

The following SQL creates a PRIMARY KEY on the "P_Id" column when the "Persons" table is created:

MySQL:

CREATE TABLE Persons
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
PRIMARY KEY (P_Id)
)

SQL Server / Oracle / MS Access:

CREATE TABLE Persons
(
P_Id int NOT NULL PRIMARY KEY,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255)
)

To allow naming of a PRIMARY KEY constraint, and for defining a PRIMARY KEY constraint on multiple columns, use the following SQL syntax:

MySQL / SQL Server / Oracle / MS Access:

CREATE TABLE Persons
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
CONSTRAINT pk_PersonID PRIMARY KEY (P_Id,LastName)
)

Note: In the example above there is only ONE PRIMARY KEY (pk_PersonID). However, the VALUE of the primary key is made up of TWO COLUMNS (P_Id + LastName).

---

SQL PRIMARY KEY Constraint on ALTER TABLE

To create a PRIMARY KEY constraint on the "P_Id" column when the table is already created, use the following SQL:

MySQL / SQL Server / Oracle / MS Access:

ALTER TABLE Persons
ADD PRIMARY KEY (P_Id)

To allow naming of a PRIMARY KEY constraint, and for defining a PRIMARY KEY constraint on multiple columns, use the following SQL syntax:

MySQL / SQL Server / Oracle / MS Access:

ALTER TABLE Persons
ADD CONSTRAINT pk_PersonID PRIMARY KEY (P_Id,LastName)

Note: If you use the ALTER TABLE statement to add a primary key, the primary key column(s) must already have been declared to not contain NULL values (when the table was first created).

---

To DROP a PRIMARY KEY Constraint

To drop a PRIMARY KEY constraint, use the following SQL:

MySQL:

ALTER TABLE Persons
DROP PRIMARY KEY

SQL Server / Oracle / MS Access:

ALTER TABLE Persons
DROP CONSTRAINT pk_PersonID

SQL CREATE TABLE Syntax

The SQL CREATE TABLE Statement

The CREATE TABLE statement is used to create a table in a database.

Tables are organized into rows and columns; and each table must have a name.

SQL CREATE TABLE Syntax

CREATE TABLE table_name
(
column_name1 data_type(size),
column_name2 data_type(size),
column_name3 data_type(size),
....
);

The column_name parameters specify the names of the columns of the table.

The data_type parameter specifies what type of data the column can hold (e.g. varchar, integer, decimal, date, etc.).

The size parameter specifies the maximum length of the column of the table.

Tip: For an overview of the data types available in MS Access, MySQL, and SQL Server, go to our complete Data Types Reference.

The SQL SELECT TOP Clause

The SQL SELECT TOP Clause

The SELECT TOP clause is used to specify the number of records to return.

The SELECT TOP clause can be very useful on large tables with thousands of records. Returning a large number of records can impact on performance.

Note: Not all database systems support the SELECT TOP clause.

SQL Server / MS Access Syntax

SELECT TOP number|percent column_name(s)
FROM table_name;

SQL DELETE STATEMENT

The SQL DELETE Statement

The DELETE statement is used to delete rows in a table.

SQL DELETE Syntax

DELETE FROM table_name
WHERE some_column=some_value;

SQL UPDATE STATEMENT

The SQL UPDATE Statement

The UPDATE statement is used to update existing records in a table.

SQL UPDATE Syntax

UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;

insert into in SQL

The SQL INSERT INTO Statement

The INSERT INTO statement is used to insert new records in a table.

SQL INSERT INTO Syntax

It is possible to write the INSERT INTO statement in two forms.

The first form does not specify the column names where the data will be inserted, only their values:

INSERT INTO table_name
VALUES (value1,value2,value3,...);

The second form specifies both the column names and the values to be inserted:

INSERT INTO table_name (column1,column2,column3,...)
VALUES (value1,value2,value3,...);

SQL ORDER BY Syntax

SELECT column_name, column_name
FROM table_name
ORDER BY column_name ASC|DESC, column_name ASC|DESC;

IMPORTANT SQL COMMANDS

Some of The Most Important SQL Commands

• SELECT - extracts data from a database
• UPDATE - updates data in a database
• DELETE - deletes data from a database
• INSERT INTO - inserts new data into a database
• CREATE DATABASE - creates a new database
• ALTER DATABASE - modifies a database
• CREATE TABLE - creates a new table
• ALTER TABLE - modifies a table
• DROP TABLE - deletes a table
• CREATE INDEX - creates an index (search key)
• DROP INDEX - deletes an index

ABOUT SQL

What is SQL?

• SQL stands for Structured Query Language
• SQL lets you access and manipulate databases
• SQL is an ANSI (American National Standards Institute) standard

---

What Can SQL do?

• SQL can execute queries against a database
• SQL can retrieve data from a database
• SQL can insert records in a database
• SQL can update records in a database
• SQL can delete records from a database
• SQL can create new databases
• SQL can create new tables in a database
• SQL can create stored procedures in a database
• SQL can create views in a database
• SQL can set permissions on tables, procedures, and views

---

SQL is a Standard - BUT....

Although SQL is an ANSI (American National Standards Institute) standard, there are different versions of the SQL language.

However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.

---

Using SQL in Your Web Site

To build a web site that shows data from a database, you will need:

• An RDBMS database program (i.e. MS Access, SQL Server, MySQL)
• To use a server-side scripting language, like PHP or ASP
• To use SQL to get the data you want
• To use HTML / CSS

---

RDBMS

RDBMS stands for Relational Database Management System.

RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.

The data in RDBMS is stored in database objects called tables.

A table is a collection of related data entries and it consists of columns and rows.

ALTER DB QUARRIES

The ALTER TABLE Statement

The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.

SQL ALTER TABLE Syntax

To add a column in a table, use the following syntax:

ALTER TABLE table_name
ADD column_name datatype

To delete a column in a table, use the following syntax (notice that some database systems don't allow deleting a column):

ALTER TABLE table_name
DROP COLUMN column_name

To change the data type of a column in a table, use the following syntax:

SQL Server / MS Access:

ALTER TABLE table_name
ALTER COLUMN column_name datatype

My SQL / Oracle (prior version 10G):

ALTER TABLE table_name
MODIFY COLUMN column_name datatype

Oracle 10G and later:

ALTER TABLE table_name
MODIFY column_name datatype