0% found this document useful (0 votes)

23 views51 pages

Solutions

Uploaded by

Raushan Kumar

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as TXT, PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

23 views51 pages

Solutions

Uploaded by

Raushan Kumar

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as TXT, PDF, TXT or read online on Scribd

You are on page 1/ 51

User Status Check

select USERNAME,ACCOUNT_STATUS from dba_users where USERNAME in

('SYSTEM','TBAADM');----satara uat --- sdc026 ---- fin@123 sdc027 mod@12

===================================================================================
==========================================================

Jr Bank level che HBKOD complete zla ki B N N hote nasel tar

HBJSTM madhun
job id : PSSCD madhe S 3 N <cs> aase asel tar update karche S 3 Y <cs> yacha madhe.

===================================================================================
=====================================================
sol bactch job status

select
db_stat_code,sol_cls_flg,sol_restartability_flg,sol_cls_date,sol_bod_date,count(*)
from tbaadm.sol where del_flg='N' group by db_stat_code,sol_cls_flg,
sol_restartability_flg,sol_cls_date,sol_bod_date order by 1;

select dc_stat_code,dc_cls_flg,dc_restartability_flg,dc_cls_date,db_stat_date from

tbaadm.gct; sdc120 sk@1234

batch jobs failed ====

find . -name *.com
vi com file------> take b2k_session_id-------->ps -ef|grep b2k id----->kill pi id
find . -name "*.log*" |xargs grep '414820447929'
ps -ef|grep icbx*
ps -aef | grep "bab"

Cron comment

crontab -e

===================================================================================
======================================================

ccd_isc@infosys.com
exebatch -i /home/finadm/EABGST_02.list -n 20 babx4070 "${B2K_SESSION_ID}" @s Y
Your Request ID is 1115776

exebatch -i /home/finadm/VP/EABR/sol.lst -n 1 babx4070 $B2K_SESSION_ID @s Y

---

7506318036

select
sol_id,db_stat_code,sol_cls_flg,sol_restartability_flg,sol_cls_date,sol_bod_date
from tbaadm.sol where del_flg='N' and db_stat_code='Y' and
sol_cls_flg='Y' and sol_restartability_flg='N';
select
sol_id,db_stat_code,sol_cls_flg,sol_restartability_flg,sol_cls_date,sol_bod_date
from tbaadm.sol where del_flg='N' and db_stat_code='B' and
sol_cls_flg='N' and sol_restartability_flg='N';

select
sol_id,db_stat_code,sol_cls_flg,sol_restartability_flg,sol_cls_date,sol_bod_date
from tbaadm.sol where del_flg='N' and db_stat_code='P' and
sol_cls_flg='F' and sol_restartability_flg='N';

select
sol_id,db_stat_code,sol_cls_flg,sol_restartability_flg,sol_cls_date,sol_bod_date
from tbaadm.sol where del_flg='N' and db_stat_code='I' and
sol_cls_flg='Y' and sol_restartability_flg='N';

select
sol_id,db_stat_code,sol_cls_flg,sol_restartability_flg,sol_cls_date,sol_bod_date
from tbaadm.sol where del_flg='N' and db_stat_code='P' and
sol_cls_flg='Y' and sol_restartability_flg='N';

select
sst.set_id,sol.db_stat_code,sol.sol_cls_flg,sol.sol_restartability_flg,sol.sol_cls_
date,sol.sol_bod_date,count(sst.sol_id),count(sol.sol_id) from
tbaadm.sst,tbaadm.sol where sol.sol_id = sst.sol_id and sol.del_flg='N' and
((sst.set_id like 'EODB%') OR (sst.sol_id='10011') OR (sst.sol_id='10002') OR
(sst.sol_id='90000')) and sst.set_id not in('ALL','INTREV','MEOD1','TEOD1') group
by
sst.set_id,sol.db_stat_code,sol.sol_cls_flg,sol.sol_restartability_flg,sol.sol_cls_
date,sol.sol_bod_date order by 1

-----------------------------------------------------------------------------------
------------------------------------

* flg P F N resolvation *

select * from tbaadm.bjs where job_group ='PRSCD' AND sol_id='10011' and JOB_ID in
('PRSL1','PRSL2');

update tbaadm.bjs set NEXT_EXEC_DATE='30-NOV-2023' where JOB_ID in

('PRSL1','PRSL2') AND sol_id='10011';
COMMIT;

select sol_restartability_flg,db_stat_code,sol_cls_flg,sol_bod_date,sol_cls_date
from tbaadm.sol where sol_id='10069';

-----------------------------------------------------------------------------------
-----------------------------------------------

Batch Job Monitering

SELECT DISTINCT B.JOB_GROUP,B.JOB_DESC,B.JOB_FREQ_TYPE,B.NEXT_EXEC_DATE

FROM TBAADM.SOL A,TBAADM.BJS B
WHERE A.DEL_FLG='N' AND A.BANK_ID='01' AND A.SOL_ID=B.SOL_ID
AND B.DEL_FLG='N' AND B.BANK_ID='01' AND EXEC_DB_STAT_CODE!='U'
ORDER BY B.JOB_FREQ_TYPE,B.JOB_GROUP
;19444

===================================================================================
=============================================================
bropack
bropg

select count(1) from tbaadm.bjs where del_flg='N' and next_exec_date='1-DEC-2023'

and job_group='DKOLD';

count BR.NET

select count(1) from custom.brnet_upl where

file_name='GLTRNMASS_02122023_010.txt';

select count(tran_id) from tbaadm.dtd where del_flg='N' and tran_particular like

'HANDOVER FROM BR.NET : 02-12-2023';

==================================================================
flag Y Y N

select sol_id,next_exec_date,job_id,job_freq_type from tbaadm.bjs where

sol_id='10011' and job_group='PRSCD' and job_freq_type='D'
order by next_exec_date;

update tbaadm.bjs set next_exec_date='08-12-2023' where del_flg='N' and

sol_id='10011' and job_freq_type='D' and job_group='PRSCD';---09-12-2023
commit

select * from tbaadm.bjs where sol_id ='10203' and job_group in ('PRSCD','PSSCD')

AND JOB_ID NOT IN ('PRSL1','PRSL2','PSSCD')
AND JOB_FREQ_TYPE ='D';

update tbaadm.sol set sol_cls_date='03-DEC-2023',sol_bod_date='04-DEC-

2023',db_stat_code='B',sol_cls_flg='N',sol_restartability_flg='N' where
sol_id='10203';
commit;
===============================================================================

Dormant Account sathi

select * from tbaadm.dtd_S5515221_05122023;

create table tbaadm.dtd_S5515221_05122023 as select * from tbaadm.dtd where trim
(tran_id)='S5515221' ;

select * from tbaadm.dtd where trim (tran_id)='S5515221' ;

commit;
update tbaadm.dtd set GL_SUB_HEAD_CODE='59018', acid='5115',
cust_id=NULL,sol_id='10000',iso_flg='D' where trim (tran_id)='S5515221' and
trim (PART_TRAN_SRL_NUM)='1';
GL_SUB_HEAD_CODE='59018', acid='5115', cust_id=NULL,sol_id='10000',iso_flg='D'

===================================================================================
=======================

NFFT AND RTGS

select mt_no,in_out_ind,STATUS,count(*) from tbaadm.smh where

execution_date=(select db_stat_date from tbaadm.gct) and paysys_id='NEFT' GROUP BY
MT_NO,in_out_ind,STATUS;

select mt_no,in_out_ind,STATUS,count(*) from tbaadm.smh where

execution_date=(select db_stat_date from tbaadm.gct) and paysys_id='RTGS' GROUP BY
MT_NO,in_out_ind,STATUS;

===================================================================================
=============================

BR.NET Issue Transaction.

select * from tbaadm.dtd where trim (tran_id) in

('S6126268','S6129813','S6203702')and TRAN_DATE='07-12-2023' and
TRAN_PARTICULAR='HANDOVER FROM BR.NET : 07-12-2023';

select * from tbaadm.dth where trim (tran_id) in

('S6126268','S6129813','S6203702');

select * from tbaadm.dtd where TRAN_PARTICULAR='HANDOVER FROM BR.NET : 07-12-2023'

and trim (tran_id) in ('S6203702');--trim (tran_id) in
('S6126268','S6129813','S6203702')and TRAN_DATE='07-12-2023' and
TRAN_PARTICULAR='HANDOVER FROM BR.NET : 07-12-2023';
create table tbaadm.dth_sf8122023 as select * from tbaadm.dth where trim (tran_id)
in ('S6126268','S6129813','S6203702');
commit;

update tbaadm.dtd set del_flg='Y' where trim (tran_id) in ('S6203702')and

TRAN_DATE='07-12-2023';
update tbaadm.dth set del_flg='Y' where trim (tran_id) in
('S6126268','S6129813','S6203702');
commit;

===================================================================================
=============================
Fino Transaction query

FINOSERVO_WFT_010524133202
(1)
select * from FIMASTER.fip_message_log_table
where REQUEST_UUID like 'FINO%'
AND MESSAGE_STATUS <>'S'
AND TO_DATE(FIP_TRAN_CREATE_TIME) = (select TO_DATE(db_stat_Date)from tbaadm.gct);

(2)
insert into Fino_Error_Backup
select * from FIMASTER.fip_message_log_table
where REQUEST_UUID like 'FINO%'
AND MESSAGE_STATUS <>'S'
AND TO_DATE(FIP_TRAN_CREATE_TIME) = (select TO_DATE(db_stat_Date)from tbaadm.gct);

commit;

(3)
DELETE FROM FIMASTER.fip_message_log_table
WHERE REQUEST_UUID like 'FINO%'
AND MESSAGE_STATUS <>'S'
AND TO_DATE(FIP_TRAN_CREATE_TIME) = (select TO_DATE(db_stat_Date)from tbaadm.gct);

===================================================================================
==============================

select * from tbaadm.dtd where tran_id=' S6476751' and tran_date='08-dec-2023' and

pstd_flg='N' and del_flg='Y';

select count(*) from tbaadm.dtd where tran_id=' S6436582' and tran_date='08-dec-

2023' and pstd_flg='N' and del_flg='Y';

select * from tbaadm.dth where tran_id=' S6476751' and tran_date='08-dec-2023';

select * from tbaadm.dtd where tran_id=' S6476751' and tran_date='08-dec-2023';

create table custom.dtdS6476751 as (select * from tbaadm.dtd where tran_id='

S6476751' and tran_date='08-dec-2023' and pstd_flg='N');
create table custom.dthS6476751 as (select * from tbaadm.dth where tran_id='
S6476751' and tran_date='08-dec-2023');

select * from custom.dtdS6476751;

select * from custom.dthS6476751;

Update tbaadm.dtd set del_flg='Y' where tran_id=' S6476751' and tran_date='08-dec-

2023' and pstd_flg='N';

Update tbaadm.dth set NUM_TRAN_DELETED = (select count(*) from tbaadm.dtd where

tran_id=' S6476751' and tran_date='08-dec-2023' and pstd_flg='N'),
num_tran_vfd=0
where tran_id=' S6476751' and tran_date='08-dec-2023';

===================================================================================
==================================
Ladgen

SELECT COUNT(*) FROM(

select
g.foracid,g.acct_name,g.schm_code,g.sol_id,g.acct_opn_date,g.clr_bal_amt,e.INTEREST
_CALC_UPTO_DATE_DR,l.ei_schm_flg,flow_id,flow_amt
,lr_int_freq_start_dd,LAST_INT_DR_TRAN_DATE,next_int_run_date_dr,flow_start_date,ne
xt_dmd_date,l.dis_amt,l.oflow_amt,l.last_adj_date,l.prin_dmd_os
,l.int_dmd_os,l.ochg_dmd_os,past_due_flg,num_of_flows ,NUM_OF_DMDS, c.chrge_off_flg
from tbaadm.eit e, tbaadm.lrs r, tbaadm.gam g, tbaadm.lam l, tbaadm.gac c
where g.acid= e.entity_id and e.entity_id =r.acid
and g.acid=c.acid and r.acid=l.acid
and c.chrge_off_flg !='Y'
and l.payoff_flg !='Y'
--and g.clr_bal_amt <0
and g.schm_type='LAA' and g.acct_cls_flg !='Y' and g.del_flg<>'Y' and
g.entity_cre_flg ='Y'
and r.flow_id in ('EIDEM','PRDEM')
and NEXT_DMD_DATE =(select db_stat_Date from tbaadm.gct) --(select db_stat_Date
from tbaadm.gct) -- Change as DMD date if executing on other date
and INTEREST_CALC_UPTO_DATE_DR < (select db_stat_Date from tbaadm.gct)-1--(select
db_stat_Date from tbaadm.gct)-1 -- Change as DMD-1 date if executing on other date
and g.sol_id <>'90000'
union all
select
g.foracid,g.acct_name,g.schm_code,g.sol_id,g.acct_opn_date,g.clr_bal_amt,e.INTEREST
_CALC_UPTO_DATE_DR,l.ei_schm_flg,flow_id,flow_amt,
lr_int_freq_start_dd,LAST_INT_DR_TRAN_DATE,next_int_run_date_dr,flow_start_date,nex
t_dmd_date,l.dis_amt,l.oflow_amt,l.last_adj_date,l.prin_dmd_os
,l.int_dmd_os,l.ochg_dmd_os,past_due_flg,num_of_flows ,NUM_OF_DMDS, c.chrge_off_flg
from tbaadm.eit e, tbaadm.lrs r, tbaadm.gam g, tbaadm.lam l, tbaadm.gac c
where g.acid= e.entity_id and e.entity_id =r.acid
and g.acid=c.acid and r.acid=l.acid
and c.chrge_off_flg !='Y'
and l.payoff_flg !='Y'
--and g.clr_bal_amt <0
and g.schm_type='LAA' and g.acct_cls_flg !='Y' and g.del_flg<>'Y' and
g.entity_cre_flg ='Y'
and r.flow_id in ('INDEM')
and NEXT_DMD_DATE =(select db_stat_Date from tbaadm.gct)-- Change as DMD date if
executing on other date
and INTEREST_CALC_UPTO_DATE_DR < (select db_stat_Date from tbaadm.gct)-1 -- Change
as DMD-1 date if executing on other date
and g.sol_id <>'90000'
)
--GROUP BY SOL_ID
;

-------------------------------

SELECT B.SOL_ID,B.FORACID,A.entity_type, A.entity_id, A.interest_ind,

A.interest_type, A.supercede_flg,A.end_date,COUNT(*)
FROM TBAADM.IDT A,TBAADM.GAM B
WHERE A.entity_id=B.ACID
AND A.interest_ind ='D'
AND A.interest_type = 'N'
--AND A.supercede_flg = 'N'
AND A.entity_cre_flg = 'Y'
AND A.start_date <= TO_DATE( '04-12-2023 00:00:00' , 'DD-MM-YYYY HH24:MI:SS')
AND A.end_date >= TO_DATE( '04-12-2023 00:00:00' , 'DD-MM-YYYY HH24:MI:SS')
AND A. entity_id IN (select ACID from tbaadm.lrs where NEXT_DMD_DATE='05-dec-
2023')
--AND entity_id='ZZ3992386'
and a.BANK_ID = '01'
GROUP BY B.SOL_ID,B.FORACID,A.entity_type, A.entity_id, A.interest_ind,
A.interest_type, A.supercede_flg,A.end_date
HAVING COUNT(*)>1
;

-------------- update max srl num as UPERCEDE_FLG='Y' ----------

select * from tbaadm.idt where entity_id='ZZ4115383' AND INTEREST_TYPE='N' order

by SERIAL_NUM desc

UPDATE TBAADM.IDT SET SUPERCEDE_FLG='Y' WHERE SERIAL_NUM='00300' AND

entity_id='ZZ4115383' AND INTEREST_TYPE='N'

===================================================================================
==============================================

B N N/ M N N FLG aasel tar tick checkbox and submit

select sol_id,next_exec_date,job_id from tbaadm.bjs where del_flg='N' and

sol_id='10011' and job_freq_type='D' and job_group='PSSCD' order by next_exec_date;
select sol_id,next_exec_date,job_id from tbaadm.bjs where del_flg='N' and
sol_id='10011' and job_freq_type='D' and job_group='PRSCD' order by next_exec_date;

update tbaadm.bjs set NEXT_EXEC_DATE ='12-12-2023' where del_flg='N' and

sol_id='10011' and job_freq_type='D' and
job_group='PSSCD';

commit;
5
-----------------------------------------------------------------------------------
-------------------------
* jr transaction Post/Verfiy aasel tari pan blocking det aasel eod la tar he check
karun update karyche*

select * from tbaadm.dtd where trim (tran_id)='DC2887';

select * from tbaadm.dth where trim (tran_id)='DC2887';

cr - 2
dr 1

update tbaadm.dth set NUM_DR_TRAN_PSTD=1,NUM_TRAN_VFD=3 where trim

(tran_id)='DC2887';
===================================================================================
=============

Batch job Monitoring

SELECT A.SOL_ID,A.JOB_ID,A.JOB_DESC,A.JOB_GROUP,A.JOB_EXEC_DATE,
A.JOB_STATUS,TO_CHAR(A.EXEC_START_TIME,'DD-MM-YYYY HH12:MI:SS' ) EXEC_START_TIME,
TO_CHAR(A.EXEC_END_TIME,'DD-MM-YYYY HH12:MI:SS' ) EXEC_END_TIME,
to_char(to_date('1970-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss')+(EXEC_END_TIME -
EXEC_START_TIME ),'hh24:mi:ss')
FROM TBAADM.BJM A
WHERE A.BANK_ID='01'
--and a.JOB_GROUP='PSSCD'
and a.sol_id='10011'
and a.JOB_STATUS='F'
AND TRUNC(RCRE_TIME)='12-12-2023'
;
SELECT A.SOL_ID,A.JOB_ID,A.JOB_DESC,A.JOB_GROUP,A.JOB_EXEC_DATE,
A.JOB_STATUS,TO_CHAR(A.EXEC_START_TIME,'DD-MM-YYYY HH12:MI:SS' ) EXEC_START_TIME,
TO_CHAR(A.EXEC_END_TIME,'DD-MM-YYYY HH12:MI:SS' ) EXEC_END_TIME
FROM TBAADM.BJM A
WHERE A.BANK_ID='01'
and a.JOB_GROUP='PSSCD'
and a.sol_id='50808'
AND TRUNC(RCRE_TIME)='12-12-2023'
;

select * from tbaadm.bjm where JOB_GROUP='PRSCD' and TRUNC(RCRE_TIME)='12-12-2023'

and sol_id='50846';
select * from tbaadm.bjm where JOB_GROUP='PSSCD' and TRUNC(RCRE_TIME)='12-12-2023'
and sol_id='50846';
select * from tbaadm.bjm where JOB_GROUP='DKOLD';
select * from tbaadm.bjm where JOB_GROUP='PSDCD';
select * from tbaadm.bjm where JOB_GROUP='PRDCD';

===================================================================================
======================================

transaction check

select * from tbaadm.dtd where pstd_flg='N' and entry_user_id='92337';

select * from tbaadm.dtd

select * from tbaadm.htd where sol_id='10002' and tran_date='13-12-2023' and
entry_user_id='92337';

select * from tbaadm.hth where tran_id=' S7782001' and tran_date='13-12-2023';

===================================================================================
=========================================================

RNRD BATCH JOB

RSTT Record daily mornig 7 am to check (31 decamber la he comment karyche stop
karyche 8 PM la sakali manually run karyche)

If you found anu record with status <> "S" then run the cron manually and recheck
the status. If still status is not moving we need to inform the same to bank.

select rstt.*,to_char(lchg_time,'dd-mm-yyyy hh24:mi:ss'),to_char(rcre_time,'dd-mm-

yyyy hh24:mi:ss') from tbaadm.rstt where rcre_time >sysdate -1 and STATUS_FLAG
<>'S' order by lchg_time desc;

If query return 0 rows then it is fine no need to take any actionn. if query return
any data then run the below cron
/finacle/SURPROD/BE/Finacle/FC/app/cust/01/INFENG/com/C_QB_NEFT_BatchJob.com

and check below path for cron completion status

/finacle/SURPROD/BE/Finacle/FC/app/cust/01/INFENG/com/C_QB_NEFT_BatchJob.com

===================================================================================
=================================================================

--TDSCM

select * from tbaadm.TDSI ---- Record should be null ( record is comming then
HTDSCALC menu )

------------------------

--TDCLS ( record is comming then HCAACTD menu )

select SOL_ID,ACID,AUTO_RENEWAL_FLG,CLS_VALUE_DATE,CLOSE_ON_MATURITY_FLG from

tbaadm.TAM WHERE MATURITY_DATE='11-04-2024' AND CLOSE_ON_MATURITY_FLG='Y'
AND CLS_VALUE_DATE IS NULL; ----Change Date and output should be Null ----E2490

If found, then change Execution date in HBJSTM and verify it.

Then execute Batch Job in HBJE for pending SOL ids.
---------------------------

--TDREN ( record is comming then HTDREN menu )

select b.SOL_ID,a.foracid, B.OPEN_EFFECTIVE_DATE, b.MATURITY_DATE, b.ACID,

b.AUTO_RENEWAL_FLG,b.CLS_VALUE_DATE
from tbaadm.TAM b, TBAADM.GAM a
WHERE a.acid=b.acid
AND b.AUTO_RENEWAL_FLG='U'
--AND b.CLOSE_ON_MATURITY_FLG='N'
AND b.MATURITY_DATE='11-04-2024'
and b.CLS_VALUE_DATE IS NULL; --- Change Date and output should be Null

===================================================================================
===============================================================================
===================================================================================
======================================================

Batch Job FAIL run Check

Sun 12/17/2023 3:31 AM

SELECT A.SOL_ID,A.JOB_ID,A.JOB_DESC,A.JOB_GROUP,A.JOB_EXEC_DATE,
A.JOB_STATUS,TO_CHAR(A.EXEC_START_TIME,'DD-MM-YYYY HH24:MI:SS' ) EXEC_START_TIME,
TO_CHAR(A.EXEC_END_TIME,'DD-MM-YYYY HH24:MI:SS' ) EXEC_END_TIME
FROM TBAADM.BJM A
WHERE A.BANK_ID='01'
and a.sol_id='10000'
and a.job_status='S'
AND TRUNC(RCRE_TIME)='17-12-2023'
;

To check the list of transaction

select TO_CHAR(RCRE_TIME,'DD-MM-YYYY HH24:MI:SS' ) as

time,SI_SRL_NUM,TRAN_PARTICULAR, ENTRY_USER_ID,
TO_CHAR(ENTRY_DATE,'DD-MM-YYYY HH24:MI:SS' ) as ENTRY_DATE,
TO_CHAR( PSTD_DATE,'DD-MM-YYYY HH24:MI:SS' ) as POSTING_DATE,PSTD_USER_ID,
VFD_USER_ID, VFD_DATE
PART_TRAN_TYPE, GL_SUB_HEAD_CODE, ACID, VALUE_DATE, TRAN_AMT,TRAN_DATE, TRAN_ID
,SI_SRL_NUM, SI_ORG_EXEC_DATE, PR_SRL_NUM,SI_SRL_NUM, SI_ORG_EXEC_DATE,
PR_SRL_NUM,htd.*
from tbaadm.htd where TRAN_PARTICULAR like '%NEFT SETTLEMENT FOR DAY%' and
tran_date='16-12-2023';

===================================================================================
====================================================================

Sun 12/17/2023 2:40 AM

To check the status of transactions count for the day.

select * from tbaadm.htd where tran_particular like '%NEFT SETTLEMENT FOR DAY%' and
tran_date='15-12-2023';

To check the list of s.i executed need to find out the si serial number.

SELECT B.SI_SRL_NUM, E.SOL_ID,E.FORACID,E.ACCT_NAME,

B.SI_FREQ_TYPE,
B.SI_FREQ_START_DD,
B.NEXT_EXEC_DATE,
B.SI_END_DATE,
B.RMKS_FREE_TEXT,
C.AMT_IND,
A.PART_TRAN_TYPE,
C.FIXED_AMT
FROM TBAADM.PYRH A , TBAADM.SIH B, TBAADM.ADM C,TBAADM.PYRD D,TBAADM.GAM E
WHERE B.SI_SRL_NUM = A.PR_B2K_ID
AND A.AMT_DRV_SRL_NUM = C.AMT_DRV_SRL_NUM
AND A.PR_SRL_NUM = D.PR_SRL_NUM
AND D.ACID=E.ACID
AND E.FORACID='' ;
-----------------------------------------------------------------------------------
-------------------------------------------------

To check the list of transaction

select TO_CHAR(RCRE_TIME,'DD-MM-YYYY HH24:MI:SS' ) as

===================================================================================
=====================================================

Unposted /Unverified Transaction

select distinct d.tran_id,d.TRAN_DATE,d.dth_init_sol_id,d.entry_user_id ,

e.emp_name, e.sol_id emp_sol_id from tbaadm.dtd d,TBAADM.GET E
where d.PSTD_FLG='N' and d.DEL_FLG ='N' AND d.ENTRY_USER_ID=E.EMP_ID
--and DTH_INIT_SOL_ID<>'10000' order by DTH_INIT_SOL_ID

===================================================================================
=========================================

Next execution date need to be check

SELECT DISTINCT B.JOB_GROUP,b.job_id,B.JOB_DESC,B.JOB_FREQ_TYPE,B.NEXT_EXEC_DATE

FROM TBAADM.SOL A,TBAADM.BJS B
WHERE A.DEL_FLG='N' AND A.BANK_ID='01' AND A.SOL_ID=B.SOL_ID
AND B.DEL_FLG='N' AND B.BANK_ID='01' AND EXEC_DB_STAT_CODE!='U'
and NEXT_EXEC_DATE not between '12-12-2023' and '14-12-2023'
ORDER BY B.JOB_FREQ_TYPE,B.JOB_GROUP
;

===================================================================================
===============================

batchjob monitor

SELECT A.SOL_ID,A.JOB_ID,A.JOB_DESC,A.JOB_GROUP,A.JOB_EXEC_DATE,
A.JOB_STATUS,TO_CHAR(A.EXEC_START_TIME,'DD-MM-YYYY HH12:MI:SS' ) EXEC_START_TIME,
TO_CHAR(A.EXEC_END_TIME,'DD-MM-YYYY HH12:MI:SS' ) EXEC_END_TIME
FROM TBAADM.BJM A
WHERE A.BANK_ID='01'
and a.JOB_GROUP='PRSCD'
and a.sol_id='50846'
AND TRUNC(RCRE_TIME)='12-12-2023'
;

select * from tbaadm.bjm where JOB_GROUP='PRSCD' and TRUNC(RCRE_TIME)='12-12-2023'

and sol_id='50846';
select * from tbaadm.bjm where JOB_GROUP='PSSCD';
select * from tbaadm.bjm where JOB_GROUP='DKOLD';
select * from tbaadm.bjm where JOB_GROUP='PSDCD';
select * from tbaadm.bjm where JOB_GROUP='PRDCD';

===================================================================================
===============================

=================================================== sql Query for Monitor

======================================

-------------------- DETAILS ------------

SELECT
SOL_ID,SOL_DESC,SOL_BOD_DATE,SOL_CLS_DATE,DB_STAT_CODE,SOL_CLS_FLG,SOL_RESTARTABILI
TY_FLG FROM TBAADM.SOL WHERE DEL_FLG='N'ORDER BY SOL_ID ;

--------------------------SUMMARY ----------------

SELECT 'SOL' SOL , COUNT(*)

NOS_SOL,SOL_BOD_DATE,SOL_CLS_DATE,DB_STAT_CODE,SOL_CLS_FLG,SOL_RESTARTABILITY_FLG
FROM TBAADM.SOL WHERE DEL_FLG='N'
GROUP BY SOL_BOD_DATE,SOL_CLS_DATE,DB_STAT_CODE,SOL_CLS_FLG,SOL_RESTARTABILITY_FLG
UNION ALL
SELECT 'DC' SOL , 1
NOS_SOL,DB_STAT_DATE,DC_CLS_DATE,DC_STAT_CODE,DC_CLS_FLG,DC_RESTARTABILITY_FLG
FROM TBAADM.GCT ;

--------------------------------- Monitor batch job Process

------------------------------

-------------- CHECK GROUP OF BATCH JOB ---------------

SELECT DISTINCT
A.SOL_ID,A.SOL_DESC,B.JOB_GROUP,A.SOL_CLS_DATE,A.SOL_BOD_DATE,B.NEXT_EXEC_DATE
FROM TBAADM.SOL A,TBAADM.BJS B
WHERE A.DEL_FLG='N' AND A.BANK_ID='01' AND A.SOL_ID=B.SOL_ID
AND B.DEL_FLG='N' AND B.BANK_ID='01' AND EXEC_DB_STAT_CODE!='U'
AND B.JOB_FREQ_TYPE='D'
AND A.SOL_ID='10000'
ORDER BY A.SOL_ID

--- OUTPUT ----

HSCOD
SOL_CLS_DATE SOL_BOD_DATE
NEXT_EXEC_DATE
10000 CENTRAL BACK OFFICE BELAPUR PRSCD 10-12-2023 11-12-2023
11-12-2023
10000 CENTRAL BACK OFFICE BELAPUR PSSCD 10-12-2023 11-12-2023
12-12-2023

10000 CENTRAL BACK OFFICE BELAPUR PRDCD 10-12-2023 11-12-2023

11-12-2023
10000 CENTRAL BACK OFFICE BELAPUR PSDCD 10-12-2023 11-12-2023
12-12-2023
10000 CENTRAL BACK OFFICE BELAPUR DKOLD 10-12-2023 11-12-2023
12-12-2023

============================

-------------------------- EOD / BOD Process

------------------------------------------
a) AT SOL LEVEL
Menu - HSCOD

Y Y N --------------- EOD Process not started --

DB_STAT_CODE FROM Y TO I -- PRSCD
I Y D --------------- Eod started batch job initiated at sol level

**** I Y N --------------- Sol initiated but failed

***** check logs

P Y D --------------- SOL Verifying Batch Job --

DC_STAT_CODE FROM I TO P -- PRSCD

***** P F N failed
***** P Y N --------------- Sol Verifying but failed
***** check logs and Branch validation

Y Y N --------------- EOD Process not started

M N D --------------- All batch job running , sol date CHANGE --

DB_STAT_CODE FROM M TO N -- PSSCD
N N D --------------- Sol running for closure
******** M N N failed

B N N ----- HSCOD Activity completed

Menu - HSCOLD

Y Y N ----- Sol Closure Done succesfully

b) AT BANK LEVEL

HBKOD

B N N ----- HBKOD Activity completed

HBKOLD

Y Y N ----- BANK Closure Done succesfully

----------------- ERROR AT ------------------

SELECT distinct JOB_ID,NEXT_EXEC_DATE,JOB_GROUP FROM TBAADM.BJS WHERE

del_flg='N'
AND JOB_FREQ_TYPE='D'
AND JOB_GROUP ='PSSCD'
AND SOL_ID='10203'
ORDER BY NEXT_EXEC_DATE

update TBAADM.BJS set NEXT_EXEC_DATE='05-12-2023' WHERE TRIM(JOB_ID) IN

('FREZC','TXOD','PSSCD')
AND SOL_ID='10203'

HSCOD WITH TICK

=================================================== Unix Commands

======================================

---------------------- vi shortcuts -------------

vi <filename> — Open or edit a file

/<find text> ---> Enter ------------- find text or sentence

/string search forward for occurrence of string in text

?string search backward for occurrence of string in text
n move to next occurrence of search string
N move to next occurrence of search string in opposite directio

:q! — Quit vi and do not save changes.

---------------------------- unix Commands ---------------------------

shift+<window>+g ----------- end of page

find . -name fatal.log ------ find fatal file name

grep -l "MCBL0960009||30-11-2023 00:00:00|01-12-2023 00:00:00" *.LST ---- fine

message from file name

grep -l "MCBL0960009||30-11-2023 00:00:00|01-12-2023 00:00:00" .

ls -t ------------- list of file names

df -gt -------------- check space %

topas -------------- Topas Monitor for host no of process running

ps -------------- search PID process running on server

ps -p 16056734 -n COMM= ------ list of Running Process

kill -9 pid ---------- kill specific process ID

===================================================================================
==============================================================

BJS Query

SELECT DISTINCT B.JOB_GROUP,B.JOB_DESC,B.JOB_FREQ_TYPE,B.NEXT_EXEC_DATE

FROM TBAADM.SOL A,TBAADM.BJS B
WHERE A.DEL_FLG='N' AND A.BANK_ID='01' AND A.SOL_ID=B.SOL_ID
AND B.DEL_FLG='N' AND B.BANK_ID='01' AND EXEC_DB_STAT_CODE!='U'
ORDER BY B.JOB_FREQ_TYPE,B.JOB_GROUP
;

===================================================================================
================================================================

GL Tallied Query

SELECT SOL_ID,SUM(NET_GL) DIFF FROM (

SELECT D.SOL_ID,B.GL_SUB_HEAD_CODE,SUM( (C.TOT_DR_BAL*-1)+C.TOT_CR_BAL ) NET_GL
FROM TBAADM.GSH B,TBAADM.GST C,TBAADM.SOL D
WHERE B.SOL_ID=C.SOL_ID
AND B.GL_SUB_HEAD_CODE=C.GL_SUB_HEAD_CODE
AND B.CRNCY_CODE=C.CRNCY_CODE
AND B.SOL_ID=D.SOL_ID
AND trunc(sysdate) BETWEEN C.TRAN_DATE AND C.END_TRAN_DATE
AND ( (C.TOT_DR_BAL*-1)+C.TOT_CR_BAL )<>0
GROUP BY D.SOL_ID,B.GL_SUB_HEAD_CODE
) GROUP BY SOL_ID having SUM(NET_GL) <>0;

===================================================================================
=====================================================

HLADGEN Query

select a.sol_id, a.foracid, a.schm_code, a.acct_opn_date, a.clr_bal_amt,

b.NEXT_DMD_DATE
from tbaadm.gam a, tbaadm.lrs b where a.acid = b.acid and a.acct_cls_flg = 'N'
and b.NEXT_DMD_DATE = '05-12-2023' AND A.CLR_BAL_AMT != '0' order by 1,3;
===================================================================================
==========================================================

SI duplication Issue in 10000 Branch roj ratri 12 :00 AM la karyche

As we have observed we are facing SI duplication issue and we have proposed below
work around as of now kindly follow this process before initiating EOD for 10000
sol. Kindly initiate EOD for 10000 branch after 12.15 (Do not initiate eod before
12.15 for branch 10000).

@L Jothi Krishnan @Tarun Das <tarun.das@miscot.com> Kindly suggest if any changes

are required in below workaround process.

Step 1
Check if next execution date for below 4 si has changed to BODDate +1. Use
below query to check the same.

select * from tbaadm.sih where sol_id='10000' and si_freq_type='D' and si_SRL_NUM

in (
' DC33441',
' DC33617',
' DC33616',
' DC33440');

If date has changed we can proceed to initiate eod for branch 10000.If Next
execution date is same as bod date for all or for any one si then we have to go
for step 2.

Step 2:
Check if transaction are created for the sis in dtd where the next execution
date has not been changed yet.
select * from tbaadm.dtd where si_srl_num in (
' DC33441',
' DC33617',
' DC33616',
' DC33440')
and tran_date ='17-12-2023'
and entry_user_id='FINADM';

History

select * from tbaadm.siht where si_SRL_NUM in (

' DC33441',
' DC33617',
' DC33616',
' DC33440') and
EXEC_DATE='15-12-2023';

If we found the transaction has created and next execution date is not changed then
we 'll manually change the date in SIH table. We can proceed to initiate eod for
10000 after the date updation.

If date has not been changed and there is no transaction available for today's date
in dtd then we can run the below cron manually and check if the date has changed
now. If yes proceed with the eod process for 10000 sol.

If still the date is not changing, then enable traces for the script and run the
cron and check for any error.

In worst case we 'll manually change the next execution date to boddate+1 and then
we can proceed for eod of 10000 branch. so that these si can be executed post date
change by SI004 job id.

How to Run cron manually?

sh /finacle/SURPROD/BE/Finacle/FC/app/cust/01/INFENG/com/NEFT_RTGS_SI.com

SI duplicate transaction check

select * from tbaadm.dtd where si_srl_num in (

' DC33616'
)
and tran_date ='01-01-2024';
--and entry_user_id='FINADM';

===================================================================================
======================================================

BR.NET count

select count(tran_id) from tbaadm.htd where del_flg='N' and tran_particular like

'HANDOVER FROM BR.NET : 18-12-2023';

select count(tran_id) from tbaadm.dtd where del_flg='N' and tran_particular like

'HANDOVER FROM BR.NET : 18-12-2023';

select * from custom.brnet_upl where file_name='GLTRNMASS_19122023_010.txt' and

tran_id is null;

===================================================================================
============================================================
MIS Read only sathi

Before MIS read only mod check count the same both query.

SELECT count(1) FROM TBAADM.HTD HTD WHERE tran_date='05-MAY-24'; ---This date is

T-1 i.e yesterday's date.

SELECT count(1) FROM TBAADM.HTH HTH WHERE tran_date='05-MAY-24'; ---This date is

T-1 i.e yesterday's date.

After create Read only mod.

sudo -u oracle /home/oracle/SRD/MISREPORT/script/SURMISSTB_database_sync.sh

below command are made to move MIS DB in readonly mode and execute after completion
of CBS EOD^M

sudo -u oracle
/home/oracle/SRD/MISREPORT/script/stop_MRP_and_SURMISSTB_database_open_read_only.sh
Note :- If any error occur during execution kindly run the script manually or set
cron

===================================================================================
===========================================================
TB Out COUNT

select sum(tran_date_bal) from tbaadm.eab where (select db_Stat_date-1 from

tbaadm.gct) between eod_Date and end_eod_Date;

===================================================================================
===========================================================
check set

select * from tbaadm.sst where sol_id in(

'50601',
'50602',
'50605',
'10019',
'10082',
'10000',
'10024',
'10018',
'50049',
'10084',
'10083',
'10085',
'10075',
'10165'
) and del_flg<>'Y' and set_id not in
('MEOD2','MEOD1','ALL','TEOD1','INTREV','TEOD4','TEOD12','INTREV1','EOD6','TEOD5')
order by set_Id,sol_id asc;

===================================================================================
===============================================
Fino trasction

select gam.sol_id,GAM.foracid, tbaadm.lrs.*

from tbaadm.LRS lrs, tbaadm.gam gam
where NEXT_INT_DMD_DATE='02-01-2024'
and gam.acid=lrs.acid
and gam.schm_type='LAA'
and gam.sol_id='10011';

===================================================================================
=====================================

fino check

mail aala fino cha tar 10.20.80.13/14 la check karyche.

[SURPRODWAS]/finweb/SURPROD/FE/common/log/fsb/fsbhttp>

[SURPRODWAS]/finweb/SURPROD/FE/common/log/fsb/fsbhttp>grep -il 669760000064 *2024-

05-17*
[SURPRODWAS]/finweb/SURPROD/FE/common/log/fsb/fsbhttp>grep -il 669760000064 *2024-
05-16
Log file check

[SURPRODWAS]/finweb/SURPROD/FE/common/log/fsb/fsbhttp>grep -il 669760000064

logfile.backup

ya step need

aasel tar deletd karyche.

===================================================================================
========================================

select DB_stat_DAte,dc_cls_date,dc_stat_code,dc_restartability_flg,dc_cls_flg from

tbaadm.gct;

select count(1) from tbaadm.bjm where job_id=' BKTD' and run_for_date='31-12-2023'

and JOB_STATUS='S';

===================================================================================
==================================

I Y N madhi aasel tar he karyche without tick karun lavyche

select * from tbaadm.bjs where sol_id='50813' and job_group='PRSCD' and

JOB_FREQ_TYPE='D';-- job_id in('PRSL1','PRSL2');--50813
update tbaadm.bjs set next_exec_date='02-01-2024' where job_id='PRSL2' and
JOB_FREQ_TYPE='D' and sol_id='50813' and del_flg='N' and
NEXT_EXEC_DATE='31-12-2023';
commit;

===================================================================================
=====================================
NEFT/RTGS SOD

select * from tbaadm.cpod;

===================================================================================
====================================

ENABLE\DISABLE

alter trigger crmuser.TR_RISKPROFILE_ACCOUNT disable;

alter trigger custom.C_ACCOUNTS_SMSEMAIL_UPDATE disable;
alter trigger crmuser.TR_CCMG_ACCOUNT disable;

alter trigger crmuser.TR_RISKPROFILE_ACCOUNT enable;

alter trigger custom.C_ACCOUNTS_SMSEMAIL_UPDATE enable;
alter trigger crmuser.TR_CCMG_ACCOUNT enable;
D

select * from all_triggers where TRIGGER_NAME in

('TR_RISKPROFILE_ACCOUNT','C_ACCOUNTS_SMSEMAIL_UPDATE','TR_CCMG_ACCOUNT');
===================================================================================
===============================================

User Role Change

update FINFADM.URM_USER_ROLE_TBL set role_id='tlr2' where user_id='30639';

update FINFADM.URM_UPR_CORESERVER set role_id='tlr2' where user_id like '30639%';
commit;

===================================================================================
=============================================

EOD Monitering

select
db_stat_code,sol_cls_flg,sol_restartability_flg,sol_cls_date,sol_bod_date,count(*)
from tbaadm.sol where del_flg='N'
group by
db_stat_code,sol_cls_flg,sol_restartability_flg,sol_cls_date,sol_bod_date order by
1;

select
sst.set_id,db_stat_code,sol_cls_flg,sol_restartability_flg,sol_cls_date,sol_bod_dat
e,count(*) from
tbaadm.sol,tbaadm.sst where sol.del_flg='N' and set_id like 'EODB%' and sst.sol_id
= sol.sol_id
group by
set_id,db_stat_code,sol_cls_flg,sol_restartability_flg,sol_cls_date,sol_bod_date
order by 1;

===================================================================================
==============================================
P Y D stuck

update tbaadm.sol set sol_restartability_flg='N' where del_flg='N' and

db_stat_code='P' and
sol_cls_flg='Y' and sol_restartability_flg='D' and sol_id='10086';
commit;

===================================================================================
==========================================

Ladgen Fatal / failed then check fatal acid id and update. (ORA-01422: exact
fetch returns more than requested number of rows) ya error la
note:- serial no kami vala old vala gycha

select * from tbaadm.idt where entity_id='ZZ4028381' and end_date='04-01-2024' and

INTEREST_TYPE='N';

update tbaadm.idt set SUPERCEDE_FLG='Y' where entity_id='ZZ4028381' and

end_date='04-01-2024' and INTEREST_TYPE='N' and SERIAL_NUM='00532';--old kami no
vala gycha serial no
commit;

===================================================================================
============================================
RRN check
cbcupi

ls -lrt|grep -n 20

grep -il M2P2024010713443050478776 LISRVR_ASYNC_CDCI_SWIF07012024

grep -il 414206152923 LISRVR_ASYNC_CDCI_SWIF*21052024*
===================================================================================
===============================================

Value date [30] aasel tar transaction post karta na tar he karyche

select NUM_OF_BACK_DAYS_ALLOWED from tbaadm.gct;

update tbaadm.gct set NUM_OF_BACK_DAYS_ALLOWED='30' ;
commit;

===================================================================================
==========================================

Unposted Transaction

select distinct d.tran_id,d.TRAN_DATE,d.dth_init_sol_id,d.entry_user_id ,

e.emp_name, e.sol_id emp_sol_id from tbaadm.dtd d,TBAADM.GET E
where d.PSTD_FLG='N' and d.DEL_FLG ='N' AND d.ENTRY_USER_ID=E.EMP_ID
order by DTH_INIT_SOL_ID;

===================================================================================
==========================================================
Batch Job check failed job group

select * from tbaadm.bjs where job_id='APYCC' and next_EXEC_DATE='16-07-2023' AND

del_flg='N' and sol_id in (select sol_id from tbaadm.sol where del_flg='N');

select job_id,next_EXEC_DATE,count(sol_id) from tbaadm.bjs where JOB_GROUP in (

'PSSCD')
and JOB_FREQ_TYPE='D'
and
sol_id in (select sol_id from tbaadm.sol where del_flg='N') and
next_EXEC_DATE<'25-01-2024'
and del_flg<>'Y'
group by job_id,next_EXEC_DATE;

select job_id,next_EXEC_DATE,count(sol_id) from tbaadm.bjs where job_id in (

' BKTD',
'INTTD',
'TDSCM',
'TDCLS',
'TDREN')
and
sol_id in (select sol_id from tbaadm.sol where del_flg='N') -- next_EXEC_DATE<>'25-
01-2024'
group by job_id,next_EXEC_DATE;

select * from tbaadm.bjs where job_id='INTTD' and sol_id in (select sol_id from
tbaadm.sol where del_flg='N') and next_exec_date <> '24-01-2024' and del_flg='N';
===================================================================================
======================================================

BROPG Batch job failed then use this query

Execute below query and note account numbers

select
a.sol_id, a.foracid, a.schm_code, a.acct_opn_date,
a.clr_bal_amt,b.INTEREST_RATE,b.ACCOUNT_PEGGED_FLG,b.NEXT_PEG_REVIEW_DATE
from tbaadm.gam a, tbaadm.eit b
where a.acid = b.entity_id
and a.acct_cls_flg = 'N'
and b.ACCOUNT_PEGGED_FLG = 'Y'
and b.NEXT_PEG_REVIEW_DATE <'26-JAN-2024' --- enter batch job failed date
--and b.INT_TBL_CODE_SRL_NUM = max()
AND A.CLR_BAL_AMT != '0';

Login in finacle and go to menu 'HBROPEG'

Enter Account number, sol id and Review Date (failed date) >> Submit

===================================================================================
==========================================================
unposted channel transaction

select * from tbaadm.dtd where del_flg<>'Y' and pstd_flg<>'Y' and ENTRY_USER_ID

in ('FIVUSR','CDCI','FINADM','SYSTEM');
select * from tbaadm.dth where tran_id=' DC1261';
===================================================================================
========================================================
Frzee acount

select * from tbaadm.gam where FORACID='50123710030001';---50123710030001

50123710030001 50123710030001 halm

select * from tbaadm.adt where acid='ZZ555962';

--update tbaadm.gam set FREZ_CODE='T' where FORACID='50123710030001' and
FREZ_CODE=' ';

--commit;

create table migadm.gam_50123710030001 as select * from tbaadm.gam where

FORACID='50123710030001';

===================================================================================
====================================

[2:45 AM] Santhosh V

select * from tbaadm.bjs where job_id in ('PRDC1','PRDC2','PSDCD','DCCOP');
[2:49 AM] Santhosh V
select lchg_user_id from tbaadm.gct;
[2:53 AM] Santhosh V
select * from tbaadm.hol where cal_b2k_type='DC' and mmyyyy='012024';
[2:54 AM] Santhosh V
select * from tbaadm.hol where cal_b2k_type='DC' and cal_b2k_id='DC' and
mmyyyy='012024';
[3:16 AM] Santhosh V
50651
[3:16 AM] Santhosh V
50665
[3:17 AM] Santhosh V
10232
[3:17 AM] Santhosh V
10241
[3:17 AM] Santhosh V
50672
[3:31 AM] Santhosh V
select * from tbaadm.sol where not exists (select 1 from tbaadm.hol where
cal_b2k_type='BRANCH' and cal_b2k_id=sol_id and mmyyyy='022024');

===================================================================================
==========================================================
Monthly batch jobs check

select * from tbaadm.bjm where job_id in ('ACABL',

'AFDIC',
'AINCE',
'AINTC',
'ALMAD',
'ALPOD',
'ALRPD',
'ARDDN',
'ASIFN',
'ASINT')
and job_exec_date='01-02-2024';

===================================================================================
========================================================

grep -il 669100000164 120324.log

grep -il 404019389058 LISRVR_ASYNC_CDCI_SWIF*090224*.log
grep -il 404019389058 *2024-02-09* 10011 10011590180076

===================================================================================
==========================================

NEFT fail check

SELECT * FROM TBAADM.SMH WHERE execution_date in ('30-NOV-2023','01-DEC-2023')

and in_out_ind='O'
and mt_no='N07'
and status='E';

select rstt.*,to_char(lchg_time,'dd-mm-yyyy hh24:mi:ss'),to_char(rcre_time,'dd-mm-

yyyy hh24:mi:ss')
from tbaadm.rstt where rcre_time >sysdate -1 and STATUS_FLAG <>'S' order by
lchg_time desc;

SELECT rcre_time,status,smh.* FROM TBAADM.SMH WHERE execution_date in ('17-FEB-

2024','18-FEB-2024')
and in_out_ind='I' and paysys_id='RTGS' ORDER BY 1 desc;
--and mt_no='N07'
--and status='E';I== N02

SELECT rcre_time,status,smh.* FROM TBAADM.SMH WHERE execution_date in ('17-FEB-

2024','18-FEB-2024')
and in_out_ind='I'
and mt_no='N02' ORDER BY 1 desc;
--and status='E';
===================================================================================
=============================================
Rephasment step
putty 80.11
cd morning report
cd sfmt report gycha aapla directory la txt file.
1.hccs for sol change.
2.hrephase info fill.
3.hpr resone copy and past txt file.
===================================================================================
===================
Production
10.20.80.13/10.20.80.14 frontend
10.20.80.11/10.20.80.12 backend
10.20.81.11/10.20.81.12 database

UAT Putty
10.20.84.11 backend
10.20.84.14 frontend
10.20.85.11 database

Preprod
10.20.92.11 backend
10.20.92.14 frontend
10.20.93.11 database

===================================================================================
================================

NEFT/RTGS check query

select rcre_time,mt_no,status,REASON_FOR_FAILURE,smh.* from tbaadm.smh where

execution_date='20-02-2024' and paysys_id='RTGS' and in_out_ind='I' order by 1
desc;

select rcre_time,mt_no,status,REASON_FOR_FAILURE,smh.* from tbaadm.smh where

execution_date='20-02-2024' and paysys_id='RTGS' and in_out_ind='O' order by 1
desc;

select rcre_time,mt_no,status,REASON_FOR_FAILURE,smh.* from tbaadm.smh where

execution_date='20-02-2024' and paysys_id='NEFT' and MT_NO in ('N02','N07') and
in_out_ind='I' order by 1 desc;

select rcre_time,mt_no,status,REASON_FOR_FAILURE,smh.* from tbaadm.smh where

execution_date='20-02-2024' and paysys_id='NEFT' and MT_NO in ('N07','N06') and
in_out_ind='O' order by 1 desc;

===================================================================================
======================================================

CRM CHECK /Adhar card detail

select * from CRMUSER.entitydocument where orgkey='230221825';

REFERENCENUMBER='110000674545';

select * from crmuser.accounts where orgkey='230221828';

select * from CRMUSER.accounts where UNIQUEIDNUMBER='110000674545';

select orgkey from crmuser.accounts where UNIQUEIDTYPE='UDYAM AADHAR';

===================================================================================
=========================================================
FIVUSR

select entry_date,pstd_date from tbaadm.dtd where entry_user_id='FIVUSR' order by

pstd_date desc;

select count(1),max(pstd_date),max(entry_date) from tbaadm.dtd where

entry_user_id='FIVUSR'; order by pstd_date desc;

===================================================================================
=========================================================

PIDEM & OCDEM

select * from tbaadm.ldt where acid in (select acid from tbaadm.gam where foracid
='217010000728') AND
DMD_FLOW_ID IN ('PIDEM','OCDEM');---CHANGE ACCOUNT NUMBER

---Update tbaadm.Ldt set DMD_EFF_DATE='24-NOV-2023' WHERE acid in

(select acid from tbaadm.gam where foracid ='217010000728') AND
DMD_FLOW_ID='PIDEM';

--Update tbaadm.Ldt set DMD_EFF_DATE='30-NOV-2023' WHERE acid in

(select acid from tbaadm.gam where foracid ='217010000728') AND
DMD_FLOW_ID='OCDEM';

===================================================================================
=====================================================================

Neft I/w return N07 failed records query.

select * from tbaadm.SMH where IN_OUT_IND='O' and MT_NO in ('N07') AND

EXECUTION_DATE='01-DEC-2023';

select
SOL_ID,STATUS,mt_no,PAYSYS_ID,utr,IN_OUT_IND,Tran_id,TRAN_DATE,TRAN_AMT,EXECUTION_D
ATE,STP_FLG,RECEIVER_BIC,REASON_FOR_FAILURE from tbaadm.smh
where utr in (
'SURYN23335477629',
'SURYN23335477630',
'SURYN23335477631',
'SURYN23335477632',
'SURYN23335477633',
'SURYN23335477634',
'SURYN23335477635',
'SURYN23335477896',
'SURYN23335477897');

select
SOL_ID,STATUS,mt_no,PAYSYS_ID,utr,IN_OUT_IND,Tran_id,TRAN_DATE,TRAN_AMT,EXECUTION_D
ATE,STP_FLG,RECEIVER_BIC,REASON_FOR_FAILURE from tbaadm.smh
where utr in (SELECT UTR FROM TBAADM.SMH WHERE execution_date in ('31-DEC-
2023','01-JAN-2024')
and in_out_ind='O'
and mt_no='N07'
and status='E');

correct

select
SOL_ID,STATUS,mt_no,PAYSYS_ID,utr,IN_OUT_IND,Tran_id,TRAN_DATE,TRAN_AMT,EXECUTION_D
ATE,STP_FLG,RECEIVER_BIC,REASON_FOR_FAILURE from tbaadm.smh
where execution_date = (Select db_stat_date from tbaadm.gct)
and in_out_ind='O'
and mt_no='N07'
and status='E';

N07 O/w Failed:-

N07 O/w Transmitted:-

select
utr,mt_no,status,tran_amt,tran_id,tran_date,execution_date,reason_for_failure,rcre_
time,last_transmitted_on
from tbaadm.smh where status='T' and mt_no='N07' and execution_date =(select
db_stat_date from tbaadm.gct)
and to_char(rcre_time,'dd-MM-yyyy HH24')<=to_char(sysdate-(3/24),'dd-MM-yyyy
HH24');

===================================================================================
====================================================================
sqlplus system/manager@SURPROD

RPCS s9953253

select gam.SOL_ID,gam.foracid, alt.lien_amt, alt.B2K_TYPE,

gam.CLR_BAL_AMT,alt.LCHG_TIME,gam.lien_amt
from tbaadm.GAM gam, tbaadm.ALT alt
where gam.acid=alt.acid
and alt.B2K_TYPE = 'PCRLN'
and gam.CLR_BAL_AMT!='0'
AND gam.ACCT_CLS_FLG='N'
and gam.CLR_BAL_AMT>gam.lien_amt
AND alt.LIEN_AMT!='0';

select count(*)
from tbaadm.GAM gam, tbaadm.ALT alt
where gam.acid=alt.acid
and alt.B2K_TYPE = 'PCRLN'
and gam.CLR_BAL_AMT!='0'
AND gam.ACCT_CLS_FLG='N'
and gam.CLR_BAL_AMT>gam.lien_amt
AND alt.LIEN_AMT!='0';

select
utr,mt_no,status,tran_amt,tran_id,tran_date,execution_date,reason_for_failure,rcre_
time,last_transmitted_on
from tbaadm.smh where status='E' and mt_no in('N06') and execution_date=(select
db_stat_date from tbaadm.gct)
and (reason_for_failure like 'F27 NACK message received%' or reason_for_failure
like '%EOD%' or
reason_for_failure is null);

===================================================================================
====================================================================

select * from tbaadm.sol where not exists (select 1 from tbaadm.hol where
cal_b2k_type='BRANCH' and cal_b2k_id=sol_id and mmyyyy='032024') and del_flg='N';

where TRANSACTIONID='FINOR52024022800001259';
desc CUSTOM.c_nrtgs ;

select * from tbaadm.hol where cal_b2k_type='DC' and cal_b2k_id='DC' and

mmyyyy='032024';
-----------------------------------------------------------------------------------
-----
FINOR52024022800001259
FINOR52024022800001260
FINOR52024022800001261
FINOR52024022800001262
FINOR52024022800001270
FINOR52024022800001271
FINOR52024022800001272
-------
FINOR52024022800001308
FINOR52024022800001309
FINOR52024022800001310
FINOR52024022800001311
FINOR52024022800001312
FINOR52024022800001313
-----------------------------------------------------------------------------------
--------
NEFT/RTGS

select * from CUSTOM.c_ngrtgs where TRANSACTIONID ='FINOR52024022800001260';,

'FINOR52024022800001261','FINOR52024022800001262','FINOR52024022800001270','FINOR52
024022800001271','FINOR52024022800001272','FINOR52024022800001308','FINOR5202402280
0001309','FINOR52024022800001310');

27 cr
select * from tbaadm.smh where utr in
('FINOH24059001260','FINOH24059001261','FINOH24059001262','FINOH24059001270','FINOH
24059001271','FINOH24059001272','FINOH24059001308');

select * from tbaadm.smh where execution_date='28-02-2024' and MT_NO='R42' and

in_out_ind='I';
select * from tbaadm.smh where execution_date='28-02-2024' and
TRAN_AMT='100000000' and PAYSYS_ID='RTGS';

select rcre_time,mt_no,status,REASON_FOR_FAILURE,smh.* from tbaadm.smh where

execution_date='28-02-2024' and paysys_id='NEFT'
and MT_NO in ('N02','N07') and in_out_ind='I' order by 1 desc;

select ROUTING_REF_NUM FROM TBAADM.SMH where SMH.BANK_ID= '01' and SMH.UTR=

'SURYN24059885747';

===================================================================================
=======================================================================

Tresury Transaction count check

select count(tran_id) from tbaadm.dtd where sol_id='10002';---32 543

select * from tbaadm.tut where tran_id='12-03-2024';--and sol_id='10002';

===================================================================================
=====================================================================

How to check com file is running or no

10.20.80.11

[SURPROD]/finreports/CDCI_LOGS/92339/01[25-03-24]> find . -name *.com

10.20.80.12

[SURPROD]/finacle/SURPROD/BE/Finacle/FC/app/CDCI_LOGS/92339/01[25-03-24]>find . -
name *.com

===================================================================================
=============================================================================

RESTRICT_MODIFY_IND cha or aapla jar modify kiva add karun det nasel tar he karyche

select RESTRICT_MODIFY_IND from tbaadm.dtd where tran_id=' S8924429';---

RESTRICT_MODIFY_IND=2
select RESTRICT_MODIFY_IND from tbaadm.dth where tran_id=' S8924429';---
RESTRICT_MODIFY_IND=2

select * from tbaadm.bjs where sol_id='10106' and del_flg='N';

update tbaadm.dtd set RESTRICT_MODIFY_IND='2' where trim(tran_id)='S8924429'; and
RESTRICT_MODIFY_IND='';
update tbaadm.dth set RESTRICT_MODIFY_IND='2' where tran_id=' S8924429'; and
RESTRICT_MODIFY_IND='';
commit;
ALTER TRIGGER CUSTOM.C_MDVT_DTD_TRIGGER_MVIEW enable;

===================================================================================
============================================================================

select mt_no,status,in_out_ind,count(*) from tbaadm.smh where

execution_date=(select db_stat_date-1 from tbaadm.gct) and mt_no
in('N02','N07','N06')
group by mt_no,status,in_out_ind;
/
IF status in M for N02,N07 Neft inward
1.we have to check PAYSYS user fatal error and identify issue.
2.we have to check tran id created or not.
3.we have to check receiver account amount credited or not.
4.If amount not credited we have to check and update with below query
update tbaadm.smh set status='R' where utr='' and status='M';
commit;
5.we have to check again transaction processed or not and account credited or not.
/
If status E and reason_for_failure ='MESSAGE TRANSMITION FAILED DUE TO EOD' for
neft O/w N06,N07
1.we have to check execution_date.
2.update query
update tbaadm.smh set status='R',execution_date='' where utr='' and
status='E';
commit;
/
N07 Failed

select
utr,mt_no,status,tran_amt,tran_id,tran_date,execution_date,reason_for_failure,rcre_
time,last_transmitted_on
from tbaadm.smh where status='T' and mt_no in('N07') and execution_date=(select
db_stat_date-1 from tbaadm.gct)
and to_char(rcre_time,'dd-MM-yyyy HH24')<=to_char(sysdate-(3/24),'dd-MM-yyyy
HH24');
/
N06/N07 O/w failed due to EOD

select
utr,mt_no,status,tran_amt,tran_id,tran_date,execution_date,reason_for_failure,rcre_
time,last_transmitted_on
from tbaadm.smh where status='E' and mt_no in('N06','N07','N10') and
execution_date=(select db_stat_date-1 from tbaadm.gct)
and (reason_for_failure like 'F27 NACK message received%' or reason_for_failure
like '%EOD%' or
reason_for_failure is null)

===================================================================================
===================================================================================
===
This error has been shown

Error Messages
W0205 - Both credit and debit are not allowed for accounts under this scheme.
[ S7646210/ 124]
W0205 - General validation failed[ S7646210/ 124]
W0205 - Both credit and debit are not allowed for accounts under this scheme.
[ S7646210/ 125]
W0205 - General validation failed[ S7646210/ 125]

select
TRAN_DATE,PART_TRAN_TYPE,PART_TRAN_SRL_NUM,ACID,tran_amt,ENTRY_USER_ID,PSTD_USER_ID
from tbaadm.dtd where tran_id=' S7646210';

update tbaadm.dtd set ACID='ZZ519686' where tran_id=' S7632867' and

ACID='ZZ3625948' and PART_TRAN_SRL_NUM=' 113';

commit;

===================================================================================
===================================================================================
======

RTGS transamitted check

select * from tbaadm.smh where paysys_id='RTGS' and execution_date='05-05-2024' and

status='R' and mt_no='R41';
select * from tbaadm.smh where paysys_id='RTGS' and execution_date='05-05-2024' and
status='R' and mt_no='R42';
select * from tbaadm.smh where paysys_id='RTGS' and execution_date='05-05-2024' and
status='E' and mt_no='R41';
select * from tbaadm.smh where paysys_id='RTGS' and execution_date='05-05-2024' and
status='E' and mt_no='R42';

===================================================================================
===================================================================================
========

VL post link

/home/finadm/qbss

===================================================================================
==================================='

This fatal error genertaed then sol this

{[The EAB record [ZZ2221781,10-05-2024] has the end EOD date prior to the EOD date
[10-05-2024].}

update tbaadm.eab set END_EOD_DATE='31-12-2099' where acid='ZZ2221781' and

END_EOD_DATE='10-05-2024' and EOD_DATE='10-05-2024'
and TRAN_DATE_BAL=0;
commit;
create table tbaadm.eab11052024 as select * from tbaadm.eab where acid='ZZ2221781';

===================================================================================
===================================================================================
==============

SI transactions deleted

select * from tbaadm.dtd where tran_sub_type='SI' and pstd_flg='N';

--update tbaadm.dtd set del_flg='Y' and tran_sub_type='SI' and pstd_flg='N';
--update tbaadm.dth set del_flg='Y' and tran_sub_type='SI';
--commit;

===================================================================================
===================================================================================
============

Inward zone open colsed

select * from tbaadm.izh where zone_stat!='Z';

update tbaadm.izh set zone_stat='Z' where zone_stat!='Z';

===================================================================================
================================================================
Table Lock Query/resource is busy try again

1 query

select a.sid||'|'|| a.serial#||'|'|| a.process

from v$session a, v$locked_object b, dba_objects c
where b.object_id = c.object_id
and a.sid = b.session_id
and OBJECT_NAME=upper('&TABLE_NAME');

alter system kill session '49,45509' immediate;

2 query

select
c.owner,
c.object_name,
c.object_type,
b.sid,
b.serial#,
b.status,
b.osuser,
b.machine
from
v$locked_object a ,
v$session b,
dba_objects c
where
b.sid = a.session_id
and
a.object_id = c.object_id;
Pick the SID and Serial Number and pass to below query and execute the same.

alter system kill session '50,63155';

===================================================================================
===================================================================================

Account is locked

select USERNAME,ACCOUNT_STATUS from dba_users where USERNAME in

('SYSTEM','TBAADM');

ALTER USER USER_NAME ACCOUNT UNLOCK;---- user_name cha jadi je account lock zle ahe
te takyche ex tbaadm

Unable to connect to database: Invalid username/password; logon denied issue.

/finacle/SATUAT/BE/Finacle/FC/app/CDCI_LOGS/SDC129> bauu9093
Username: sqldevloper che (system)
Password: sqldevloper che (dccb24)

===================================================================================
===================================================================================

Invalid date/ day aasi error aali tar putty la (LADGEN and RACLR batch job)

check karyche eit table ani lam table la

---EIT table la yala date aahet ka pahiche

select
Accrued_Upto_Date_Cr,Accrued_Upto_Date_Dr,Booked_Upto_Date_Cr,Booked_Upto_Date_Dr,I
nterest_Calc_Upto_Date_Cr,Interest_Calc_Upto_Date_Dr
from tbaadm.eit where Entity_Id='AA5109157';

LAM table la date same nko pahije

select Ei_Perd_Start_Date,Ei_Perd_End_Date from tbaadm.lam;

STEP 01 - Take all accounts for ei_perd_start_date=ei_perd_end_date create a one

table.

create table migbkp.lameidate as select * from tbaadm.lam where acid in (select

acid from tbaadm.gam where sol_id in ('1015',
'1077',
'1049',
'1001',
'1201',
'1128',
'1242') and ei_perd_start_date=ei_perd_end_date) ;

select * from migbkp.lameidate ;

STEP 02 - Take the migbkp.lameidate backup table and take the exatct account open
date from gam table and create one backup table like "migbkp.surajsi"
create table migbkp.surajsi as select acct_opn_date,acid from tbaadm.gam where acid
in (select acid from migbkp.lameidate);

select * from migbkp.surajsi;

STEP 03 - Before updating the lam table take backup of lam table like
"migbkp.lam19jul2024"

create table migbkp.lam19jul2024 as select * from tbaadm.lam;

STEP 04-Finalyy do the below update like.

UPDATE TBAADM.LAM SET EI_PERD_START_DATE=(SELECT ACCT_OPN_DATE FROM MIGBKP.SURAJSI

WHERE SURAJSI.ACID=LAM.ACID)
WHERE EXISTS(SELECT ACCT_OPN_DATE FROM MIGBKP.SURAJSI WHERE SURAJSI.ACID=LAM.ACID);
commit;

===================================================================================
===================================================================================
==

LAACL batch job

BUFMAN error gam table bole tar

check gam table clr_bal_amt =0 aasel loan sathi tar te check karyche

This regards to batch job : LAACL failure.

In 5 SOLs we have observed the below :

1) Loan A/cs opened back dated but not disbursed till now.

2) Loan A/c opened back dated but not yet authorised.

3) Loan A/cs opened back dated, done disbursement but disbursement was not
authorised.

All above problematic A/cs having zero balance since long & system was trying for
closure of said loan A/cs thru LAACL Batch Job & getting failed.

===================================================================================
===================================================================================
========

EAB table record match

HEABR menu
===================================================================================
============
User activate / Devactive

select * from tbaadm.upr where User_Id='SDC029' ;

Update Tbaadm.Upr Set Del_Flg='N' Where User_Id='SDC029' ;

commit;
===================================================================================
===================================================================================
===
SYNONYM

CREATE OR REPLACE EDITIONABLE SYNONYM "TBAADM"."EVENT_TIMER" FOR

"FINBATCHPERF"."B_EVENT_TIMER";

CREATE OR REPLACE EDITIONABLE SYNONYM "TBAADM"."B_EVENT_TIMER_MD" FOR

"FINBATCHPERF"."EVENT_TIMER_MD";

CREATE OR REPLACE EDITIONABLE SYNONYM "TBAADM"."EVENT_TIMER" FOR

"FINBATCHPERF"."B_EVENT_TIMER";

CREATE OR REPLACE EDITIONABLE SYNONYM "TBAADM"."MAPPER_TABLE" FOR

"FINBATCHPERF"."B_MAPPER_TABLE";

CREATE OR REPLACE EDITIONABLE SYNONYM "TBAADM"."TBA_MAPPER_TABLE" FOR

"FINBATCHPERF"."B_MAPPER_TABLE";

===================================================================================
===================================================================================
====
A databaseerror [-50] occurred and The call to sequence drop batch job failed

update tbaadm.gct set dc_alias='MD';

commit;

===================================================================================
===================================================================================
======

--The call to contra posting job failed.---

Select * From Finfadm.Urm_Upr_Coreserver Where User_Id

In('CDCI','UBSADMIN','FIVUSR','UBSROOT','PAYSYS','SYSTEM','BJMS','FINCOR','PAYSYS_D
EF','CRM1');;

Update Finfadm.Urm_Upr_Coreserver Set Del_Flg='N' Where User_Id

In('CDCI','UBSADMIN','FIVUSR','UBSROOT','PAYSYS','SYSTEM','BJMS','FINCOR','PAYSYS_D
EF','CRM1');
commit;

===================================================================================
===================================================================================
===

Invalid day/date-------Invalid Length in Date

LAM EISTARTDATE AND END DATE UPDATE (LOAN batch jobs)

Select * From Tbaadm.Lam;

Select * From Tbaadm.Lam Where Acid In (Select Acid From Tbaadm.Gam) and
ei_perd_start_date=ei_perd_end_date;---69207
create table migbkp.lam1augst24 as select * from tbaadm.lam where acid in (select
acid from tbaadm.gam) and ei_perd_start_date=ei_perd_end_date ;

create table migbkp.surajgam as select acct_opn_date,acid from tbaadm.gam where

acid in (select acid from migbkp.lam1augst24);

create table migbkp.lam01aug24 as select * from tbaadm.lam;

Update Tbaadm.Lam Set Ei_Perd_Start_Date=(Select Acct_Opn_Date From Migbkp.Surajgam

Where Surajgam.Acid=Lam.Acid)
Where Exists(Select Acct_Opn_Date From Migbkp.Surajgam Where
Surajgam.Acid=Lam.Acid);
commit;

create index idx_ac on migbkp.surajgam(acid);

Invalid day/date

SBACCA Batch job has failed because of ALL Accrued_Upto_Date_Dr,booked_upto_date_dr

date are null

select count(1) from tbaadm.eit where entity_id in (select acid from tbaadm.gam
where schm_type in ('SBA','CAA')) and accrued_upto_date_dr is null;--1917794

select count(1) from tbaadm.eit where entity_id in (select acid from tbaadm.gam
where schm_type in ('SBA','CAA')) and booked_upto_date_dr is null;

select counT(1) from tbaadm.eit where entity_id in (select acid from tbaadm.gam
where schm_type in ('SBA','CAA')) and interest_calc_upto_date_dr is null;

create table migbkp.opendate as select a.acid,a.acct_opn_date-1 from tbaadm.gam a

where a.acid in (select entity_id from tbaadm.eit where accrued_upto_date_dr is
null ) and a.schm_type in ('SBA','CAA');

alter session set nls_date_format='DD-MM-YYYY';

create table migbkp.opendate as Select a.Acid as acid,a.Acct_Opn_Date-1 as

Acct_Opn_Date From Tbaadm.Gam a Where Acid In (Select Entity_Id From Tbaadm.Eit
Where Accrued_Upto_Date_Dr Is Null ) And Schm_Type In ('SBA','CAA');

select * from migbkp.opendate;

Create Index Idx_Acp On Migbkp.Opendate(Acid);

Create Index Idx_Ap On Migbkp.Opendate(Acct_Opn_Date);

Update /+ parallel(10) / Tbaadm.Eit Set Accrued_Upto_Date_Dr=(Select

Acct_Opn_Date From Migbkp.Opendate B Where B.Acid=Eit.Entity_Id)
Where Exists(Select Acct_Opn_Date From Migbkp.Opendate B Where
B.Acid=Eit.Entity_Id);
commit;

Update /+ parallel(10) / Tbaadm.Eit Set booked_upto_date_dr=(Select Acct_Opn_Date

From Migbkp.Opendate B Where B.Acid=Eit.Entity_Id)
Where Exists(Select Acct_Opn_Date From Migbkp.Opendate B Where
B.Acid=Eit.Entity_Id);
Commit;

Update /+ parallel(10) / Tbaadm.Eit Set interest_calc_upto_date_dr=(Select

Acct_Opn_Date From Migbkp.Opendate B Where B.Acid=Eit.Entity_Id)
Where Exists(Select Acct_Opn_Date From Migbkp.Opendate B Where
B.Acid=Eit.Entity_Id);
Commit;
===================================================================================
===================================================================================
===

All schm code table

select * from tbaadm.gsp;

===================================================================================
=========

All session kill

select * from tbaadm.lgi;

===================================================================================
===================================================================================
==

The license limit has exceeded the allocated size for number of branches.

deactivate the branhes

===================================================================================
=======================================================

Minimum value date cha issue aala tar

Select Min_Value_Date From Tbaadm.Gam Where Foracid='100130380000002';

Select Min_Value_Date From Tbaadm.Gam Where Foracid='100101610380001';
Select Min_Value_Date From Tbaadm.Gam Where Foracid='100101610380001';
Update Tbaadm.Gam Set Min_Value_Date='30-JUN-2023' Where Foracid='100101610380001';
commit;

===================================================================================
====================================================

PMSBY and PMJBY batch jobs

1) PMY for the menu for the new register

2) UUTR is the second menu for the utr no update
PMPM
3) Total for batch jobs
a)PMSBY
b)PMJBY
c)SBRNL
d)JBRNL
This is for batch jobs
4) Tables
a)PMSBY ----- tbaadm.IN_sby;
b)PMJBY ----- tbaadm.IN_jby;
tbaadm.IN_sspt;

Note: 1)freecode2 yacha flg Y pahije

2) free code 1 A: active
E: expire
===================================================================================
===================================================================================
===

Teller account Zero balance

Select * From Tbaadm.Gam Where Foracid='100301110010003';

update Tbaadm.Gam set Clr_Bal_Amt='0' Where Foracid='100301110010003';
Select * From Tbaadm.Tacd Where Teller_Acct='100301110010003' And Tran_Date='03-
JUL-24';
update Tbaadm.Tacd set Bank_Id='02' Where Teller_Acct='100301110010003' And
Tran_Date='03-JUL-24';
Select * From Tbaadm.Tach Where Teller_Acct='100301110010003' And Tran_Date='03-
JUL-24';
Update Tbaadm.Tach Set Bank_Id='02' Where Teller_Acct='100301110010003' And
Tran_Date='03-JUL-24';
commit;

===================================================================================
===================================================================================
======

Database Error Message - ^ORA-12899: value too large for column

"TBAADM"."DAILY_TRAN_DETAIL_TABLE"."TRAN_PARTICULAR" (actual: 51, maximum: 50)^

desc TBAADM.DAILY_TRAN_DETAIL_TABLE;

alter table TBAADM.DAILY_TRAN_DETAIL_TABLE modify TRAN_PARTICULAR varchar2 (51

CHAR);

===================================================================================
=====================================================================

SI che Entered transactions direct delete in batch jobs check Del_Tran_If_Not_Pstd

='Y', e2533
If Y then correct and if N then update as Y

select Distinct Del_Tran_If_Not_Pstd from tbaadm.sih;

===================================================================================
======================================================================

DROP SEQUENCE TBA_FTTRAN_NUM_SEQ_20240603_MD;

/
create sequence TBAADM.TBA_FTTRAN_NUM_SEQ_20240603_MD minvalue 1 maxvalue 99999999
increment by 30 start with 1 nocache noorder nocycle NOKEEP NOSCALE global ;
commit;
/
drop public SYNONYM TBA_FTTRAN_NUM_SEQ_20240603_MD;
/
CREATE PUBLIC SYNONYM TBA_FTTRAN_NUM_SEQ_20240603_MD FOR
TBAADM.TBA_FTTRAN_NUM_SEQ_20240603_MD;
commit;
/
select TO_CHAR(TBA_FTTRAN_NUM_SEQ_20240603_MD.NEXTVAL) from DUAL;
/
grant select on TBAADM.TBA_FTTRAN_NUM_SEQ_20240603_MD to TBAGEN,tbaadm,tbautil;
commit;
/
--DROP SEQUENCE TBAADM.TBA_FTTRAN_NUM_SEQ_20232020_WB;
/
delete from tbaadm.lgi where user_id= 'FIVUSR';
/
select * from all_sequences where sequence_name like '%TBA_FTTRAN_NUM_SEQ%';

===================================================================================
==========================================================================

MVCD close 0r OPEN

1) MVCD menu
2) close
physical blance match to regular blance
3) nahi zale tar
HXFER menu madhun
DR- valut no
CR - Teller no devun transaction karyche (transaction karycha aadi mvcd cancl
karyche)
===================================================================================
==========================================================================

Menu not shown that time check mop id this table rcords.

select * from finfadm.urm_menu_tbl where menu_id='HCFTP';

select * from FINFADM.URM_MENU_DESC_TBL where menu_id='HCFTP';
select * from FINFADM.URM_ROLE_MENU_TBL where menu_id='HCFTP';

select * from tbaadm.mno where mop_id in ('HCFTP');

select * from tbaadm.mod where mop_id in ('HCFTP');
select * from tbaadm.mod_txt where mop_id in ('HCFTP');
select * from tbaadm.oat where mop_id in ('HCFTP');

select * from finfadm.urm_menu_tbl where menu_id='CIWREJ';

select * from FINFADM.URM_MENU_DESC_TBL where menu_id='CIWREJ';
select * from FINFADM.URM_ROLE_MENU_TBL where menu_id='CIWREJ';

select * from tbaadm.mno where mop_id in ('CIWREJ');

select * from tbaadm.mod where mop_id in ('CIWREJ');
select * from tbaadm.mod_txt where mop_id in ('CIWREJ');
select * from tbaadm.oat where mop_id in ('CIWREJ');

===================================================================================
============================================================================

standing instruction che jar eneter status vale auto delete zale pahije ya sathi
batch job baro baro
select del_tran_if_not_pstd from tbaadm.sih;

del_tran_if_not_pstd this flg is Y then this is not stuck the entered status
transactions.

update tbaadm.lgi set bod_Date='23-sep-2024',dc_bod_date='23-sep-

2024',operating_date='23-sep-2024' where user_id='FIVUSR';
commit;

hi query aahet

===================================================================================
================================================================

If any core file is generated in batch job then they stuck the EOD process.

ALL set madhun 1201 delete kele aasel tar pan bank level start hote nahi

===================================================================================
=================================================================

Remove blocking validation

select * from tbaadm.smvt where blocking_val='Y' and val_id in ('042','043');

Select Val_Id, (Select Msg_Literal From Tbaadm.Mmsg Where Msg_Id=Val_Mmsg_Id) From

Tbaadm.Smvt Where Blocking_Val='Y';

Bufman error: -1; Table: TACD; Operation: I\r\nKey: [107101110010001/INR/05-11-

2024 00:00:00/RGLR/010/01

create table migadm.tacd_04102 as select * from tbaadm.tacd where Tran_Date='04-10-

2024';

Select * From Tbaadm.Tacd Where Teller_Acct='teller account no' And Tran_Date='04-

10-2024';

delete from Tbaadm.Tacd Where Teller_Acct='teller account no' And Tran_Date='04-10-

2024';

===================================================================================
========================================================================

exact fetch returns more than requested number of rows^ fatal error

select TBA_IN_CORE_CUST_TBL.* FROM tbaadm.TBA_IN_CORE_CUST_TBL WHERE cust_id=

'4105225';

Update Tbaadm.Tba_In_Core_Cust_Tbl Set Bank_Id='02' Where Cust_Id= '4105225' And

Rownum <= 1;
commit;

table does not exits then this query

===================================================================================
===========================================

select * from tbaadm.bkc; ---3015

Select * From Tbaadm.brbic; ---516851

Select * From Tbaadm.ndt; ---513944

select * from dba_datapump_jobs;

Grant All On Tbaadm.Bct To Modus1;

Grant All On Tbaadm.Bkc To Modus1;
Grant All On Tbaadm.Brbic To Modus1;
Grant All On Tbaadm.Ndt To Modus1;

===================================================================================
=================================================================

Insufficient Privilages.

GRANT CONNECT, RESOURCE, DBA TO system;

GRANT CREATE SESSION GRANT ANY PRIVILEGE TO system;

Owner chenage

root User

chown finadm:finadm filename------>sepcific file

chown -R finadm:finadm directory_name ---------->directory_name

bauu error account lock.

select * from dba_users where ACCOUNT_STATUS='LOCKED';

select * from dba_users where USERNAME='TBAADM';

select * from dba_users where USERNAM;

alter user tbaadm identified by tbaadm account unlock;

commit;

===================================================================================
======================================================================

Partitioned account details query

A.FORACID "CUSTOMER ACCOUNT NUMBER",

C.FORACID "PARTITION A/C", C.ACCT_NAME,

sum(CASE WHEN B.PART_TRAN_TYPE = 'D' THEN b.TRAN_AMT*-1 ELSE b.TRAN_AMT END)

balance

FROM TBAADM.GAM A, TBAADM.ACPART B, TBAADM.GAM C

WHERE A.ACID = B.B2K_ID

AND B.PARTITIONED_ACID = C.ACID

AND B.PARTITIONED_ACID in (select acid from tbaadm.gam where bacid = '39058001')

AND A.FORACID IN (SELECT FORACID FROM TBAADM.GAM WHERE SCHM_CODE IN

('1307','1309','1310','1311','1312','1313'))

AND B.PSTD_FLG = 'Y'

group by A.FORACID, C.FORACID,C.ACCT_NAME

===================================================================================
==================================================================================

CASH TRANSACTION QUERIES

select gam.cif_id,gam.foracid,
htd.Tran_date,htd.Tran_id,htd.part_tran_srl_num,htd.Tran_amt,htd.LCHG_USER_ID,htd.L
CHG_TIME,htd.RCRE_USER_ID,htd.RCRE_TIME,htd.bank_id
from TBAADM.HTD,TBAADM.GAM where HTD.TRAN_TYPE='C' and HTD.TRAN_SUB_TYPE='NP' and
HTD.PART_TRAN_TYPE='D' and HTD.CUST_ID is not null and HTD.DEL_FLG='N'
and htd.PSTD_FLG='Y'and htd.acid=gam.acid and htd.tran_date between '25-10-24' and
'30-10-24'
union all
select
gam.cif_id,gam.foracid,htd.Tran_date,htd.Tran_id,htd.part_tran_srl_num,htd.Tran_amt
,htd.LCHG_USER_ID,htd.LCHG_TIME,htd.RCRE_USER_ID,htd.RCRE_TIME,htd.bank_id from
tbaadm.htd, tbaadm.gam where exists (select 1 from tbaadm.rtt where
rtt.dcc_id='ATM' and rtt.cmd='CWDR' and rtt.tran_date=htd.tran_date
and RTT.TRAN_ID=HTD.TRAN_ID)and HTD.PSTD_FLG='Y' and HTD.DEL_FLG='N' and
HTD.CUST_ID is not null and HTD.PART_TRAN_TYPE='D' and HTD.ACID=GAM.ACID and
htd.tran_date between '25-10-24' and '30-10-24';

===================================================================================
===================================================================================
=================

Payment System messages pending for transfer Execute

select * from tbaadm.smh where Execution_Date>='05-11-2024' and In_Out_Ind='O' and

Status='R';

----->> Taking service restart for NEFT and RTGS

Select * From Tbaadm.Sst ;

select * from tbaadm.stid;

===================================================================================
===================================================================================
===============
---Command to clear the archival log of the satara DC database ---

PFB for the command to clear the archival log from the satara DC database at ip
10.1.23.71.

(Below is the sample)

To Clear the archival logs

rman target /

`Recovery Manager: Release 19.0.0.0.0 - Production on Mon Oct 14 12:47:57 2024

Version 19.3.0.0.0

connected to target database: SATPROD (DBID=2924438785)

RMAN>crosscheck archivelog all;

RMAN> delete archivelog until time 'SYSDATE-1';

YES

===================================================================================
===================================================================================
==========

-----------------Regarding rmsock commond------------------

root@ASUYCBCCAPDC02:/#netstat -Aan | grep LISTEN | grep 21198 ---------

PORT_NUM=21198

f100100000a043b8 tcp4 0 0 192.168.80.12.32846 192.168.80.11.1191

ESTABLISHED

root@ASUYCBCCAPDC02:/#rmsock f100100000a043b8 tcpcb

The socket 0xf100100000a04008 is being held by proccess 10289590 (mmfsd).

root@ASUYCBCCAPDC02:/#ps -ef | grep 10289590

root 10289590 4915814 0 06:03:02 - 0:35 /usr/lpp/mmfs/bin/mmfsd

root 14287524 14025134 0 11:50:29 pts/8 0:00 grep 10289590

root@ASUYCBCCAPDC02:/#kill -9 10289590

===================================================================================
===================================================================================
=========

---------------Command to clear the archival log of the satara DC database

----------------------- 10.1.23.71

rman target /

`Recovery Manager: Release 19.0.0.0.0 - Production on Mon Oct 14 12:47:57 2024

Version 19.3.0.0.0

connected to target database: SATPROD (DBID=2924438785)

RMAN>crosscheck archivelog all;

RMAN> delete archivelog until time 'SYSDATE-1';

YES

===================================================================================
===========================================================

Unverified Inv. Transactions List

HIMC menu for nv. Transactions verifications

select * from tbaadm.IN_aidu where User_Name like '%MUKHYAMANTRI MAZI LA%';

===================================================================================
===================================================================
Vendor payment table (CBVGSTT)

Select * From Custom.Vendor_Mod_Tbl;

Select * From Custom.Vendor_Mst_Hist_Tbl;
Select * From Custom.Vendor_Mst_Tbl;
Select * From Custom.Vendor_Tran_Tbl;

===================================================================================
=========================================================================

Database Error Message - ^ORA-01422: exact fetch returns more than requested number
of rows^
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
DBLayer Error Code = ^[DBL-2112]^ Operation: ^[S]^
Database Query - ^[select referencenumber from CRMUSER.ENTITYDOCUMENT where doccode
like 'PAN 0x0.0000000000008p-1022nd orgkey in (select cif_id from tbaadm.gam where
f
oracid ='112911010000003')]^
Bind Variables - ^NULL^
select cif_id from tbaadm.gam where foracid ='112911010000003';

Select * From Crmuser.Entitydocument where Orgkey='40000658';

Remove duplicate Pan Card Record

===================================================================================
===============================================================================

Scheme/Register General Parameter Maintenance

HSRGPM menu

===================================================================================
============================================================================

DATABASE ERROR :
Database Error Message - ^ORA-01654: unable to extend index
SYSTEM.IDX_EAB_TRAN_DATE_BAL by 12137 in tablespace SYSTEM

select * from dba_data_files where Tablespace_Name ='SYSTEM';

select df.tablespace_name "Tablespace",

totalusedspace "Used MB",

(df.totalspace - tu.totalusedspace) "Free MB",

df.totalspace "Total MB",

round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace))

"Pct. Free"

from

(select tablespace_name,

round(sum(bytes) / 1048576) TotalSpace

from dba_data_files

group by tablespace_name) df,

(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name

from dba_segments

group by tablespace_name) tu

where df.tablespace_name = tu.tablespace_name ;

and df.tablespace_name like '%IDX_B2K_SYSTEM%';-- in ('FI');

select * from dba_data_files where tablespace_name in ('IDX_B2K_SYSTEM');--

-------------------------
ANSWER----------------------------------------------------------------

alter TABLESPACE "IDX_B2K_SYSTEM" add DATAFILE

'/findata1/SATUAT/DB/IDX_B2K_SYSTEM_7_SATUAT.dbf' Size 15G autoextend on; -----UAT

alter tablespace "ACCT_TRANS" add datafile

'/dboracle/SATPROD/DB/ACCT_TRANS_1_SATPROD.dbf' size 3G autoextend
on;-------------PRODUCTION

===================================================================================
================================================================================

Account closing Issue (Saving a/c).

Scheme maintance: --- HGSPM

Office account replicate--- HOACR
GL Replicate: HGLSHR

select * from tbaadm.gsh where Gl_Sub_Head_Code ='61091';

Update Tbaadm.Gsh Set Del_Flg ='N' Where Gl_Sub_Head_Code ='61091';

update tbaadm.gss set del_flg ='N' where Gl_Sub_Head_Code ='61091';
commit;

Select * From Tbaadm.Aph Where Bacid ='61091001';

Select * From Tbaadm.gam Where Bacid ='61091001';
select * from tbaadm.gss where Gl_Sub_Head_Code ='61091';

===================================================================================
================================================
MVCD not close then remove this table records (There is nothing to verify error
aala tar)

tbaadm.GENERIC_MOD_TBL

MVCD close /verify not done beacuse of date change in EOD process and they stuck
eod closing time .

====>> copy the tbaadm.tach table old open status record mens you your not close 2
jan 24 rcord then export this record and past and only change the
transaction date and commit the record in 3 jan 24
same process follow in tbaadm.tacd table entity_cre_flg ='Y' this records export
and past and change the tran date and insert and commit records .
same process foll by vault.

next you go MVCD menu and close this teller acount and verify.

===================================================================================
==========================================================================

finacle.debug

DBLAYER=Y
DBSELECT=Y
DBQUERY=Y
DBINSERT=Y
SRVINFO=Y
DBCURSOR=Y
===================================================================================
============================================================

Gl balacne

Select Sol_Id,Acct_Name,Schm_Code,Gl_Sub_Head_Code,
(Select Tran_Date_Bal From Tbaadm.Eab Where Eab.Acid = Gam.Acid And Eod_Date='12-
DEC-2024') As Balance,Clr_Bal_Amt
From Tbaadm.Gam where sol_id='1201' and acct_ownership ='O' and Clr_Bal_Amt!='0'
order by GL_SUB_HEAD_CODE ;

lien check karyche aasel tar

select * from tbaadm.alt where acid='AA2741546';

===================================================================================
============================================================================
Sol Monitor query

select min(TO_CHAR(EXEC_START_TIME,'DD-MM-YYYY
HH12:MI:SS')),max(TO_CHAR(EXEC_END_TIME,'DD-MM-YYYY HH12:MI:SS')),
to_char(to_date('1920-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss')+(max(EXEC_END_TIME)
- min(EXEC_START_TIME) ),'hh24:mi:ss'),sol_id
from tbaadm.bjm where sol_id='1201' and exec_db_stat_code!='U' and exec_start_time
like '%22-01-25%' group by sol_id ;

select sol_id, min(TO_CHAR(EXEC_START_TIME,'DD-MM-YYYY HH12:MI:SS'))As

Start_Time,max(TO_CHAR(EXEC_END_TIME,'DD-MM-YYYY HH12:MI:SS')) As End_Time,
to_char(to_date('1920-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss')+(max(EXEC_END_TIME)
- min(EXEC_START_TIME) ),'hh24:mi:ss') as Total_Time
from tbaadm.bjm where exec_db_stat_code!='U' and exec_start_time like '%06-02-25%'
and sol_id in( select sol_id from tbaadm.sol
where db_stat_code='Y' and sol_cls_flg='Y' and sol_restartability_flg='N')
group by sol_id ;

===================================================================================
====================================================================
Batch Job taking time .

First go commonenv.com.com path

/etc/b2k/SATPROD/FINCORE/com[23-01-25]>vi commonenv.com

SRFF0014_NUM_RECCOUNT=1000
export SRFF0014_NUM_RECCOUNT

SRFF0014_NUM_JOB=20
export SRFF0014_NUM_JOB

export SRFF0014_SUM_LOG=Y

add this filed in this commonenv file

Note: SRFF0014 ------>which batch job taking time this batch job take FILE_NAME
like CLDPR batch job file_name is srff0014

This changes add 2 node app server.

===================================================================================
==================================================================================
1)Denomination issue if date change but tailer accounts not close ya other branches
are verify the trailer account no then follow this steps

select
b.tran_id,b.teller_acct,a.tran_particular,a.entry_user_id,a.vfd_user_id,a.sol_id,b.
sol_id from tbaadm.dtd a,tbaadm.tach b where a.entry_user_id!=a.vfd_user_id and
a.lchg_user_id!=a.rcre_user_id and a.vfd_user_id!='SYSTEM' and a.tran_id= b.tran_id
and b.status='O' and b.vault_bal='0'
and b.sol_id!=a.sol_id and b.del_flg!='Y' and b.reg_amt!='0'
group by
b.tran_id,b.teller_acct,a.tran_particular,a.entry_user_id,a.vfd_user_id,a.sol_id,b.
sol_id;

select b.tran_id,b.teller_acct,a.entry_user_id,a.vfd_user_id,a.sol_id,(b.sol_id)
Verify_Sol_id from tbaadm.dtd a,tbaadm.tach b where a.entry_user_id!=a.vfd_user_id
and
a.lchg_user_id!=a.rcre_user_id and a.vfd_user_id!='SYSTEM' and a.tran_id= b.tran_id
and b.status='O' and b.vault_bal='0'
and b.sol_id!=a.sol_id and b.del_flg!='Y' and b.reg_amt!='0'
group by b.tran_id,b.teller_acct,a.entry_user_id,a.vfd_user_id,a.sol_id,b.sol_id;

select b.tran_id,b.teller_acct,a.entry_user_id,a.vfd_user_id,a.sol_id,(b.sol_id)
Verify_Sol_id from tbaadm.dtd a,tbaadm.tach b where a.entry_user_id!=a.vfd_user_id
and
a.lchg_user_id!=a.rcre_user_id and a.vfd_user_id!='SYSTEM' and a.tran_id= b.tran_id
and b.status='O' and b.vault_bal='0'
and b.sol_id!=a.sol_id and b.del_flg!='Y' and b.reg_amt!='0' and b.ts_cnt='0'
group by b.tran_id,b.teller_acct,a.entry_user_id,a.vfd_user_id,a.sol_id,b.sol_id;

select b.tran_id,b.teller_acct,a.entry_user_id,a.vfd_user_id,a.sol_id,(b.sol_id)
Verify_Sol_id from tbaadm.dtd a,tbaadm.tach b where a.entry_user_id!=a.vfd_user_id
and
a.lchg_user_id!=a.rcre_user_id and a.vfd_user_id!='SYSTEM' and b.tran_id= a.tran_id
and b.status='O' and b.vault_bal='0'
and b.sol_id!=a.sol_id and b.del_flg!='Y' and b.reg_amt!='0' and b.ts_cnt='0' and
a.tran_date=b.tran_date
group by b.tran_id,b.teller_acct,a.entry_user_id,a.vfd_user_id,a.sol_id,b.sol_id;

select b.tran_id,b.teller_acct,a.entry_user_id,a.vfd_user_id,a.sol_id,s.sol_desc,
(b.sol_id) Verify_Sol_id,
(select s.sol_desc from tbaadm.sol s where s.sol_id=b.sol_id) Verify_Sol_Desc
from tbaadm.dtd a,tbaadm.tach b,tbaadm.sol s
where a.entry_user_id!=a.vfd_user_id and
a.lchg_user_id!=a.rcre_user_id and a.vfd_user_id!='SYSTEM' and b.tran_id= a.tran_id
and b.status='O' and b.vault_bal='0'
and b.sol_id!=a.sol_id and b.del_flg!='Y' and b.reg_amt!='0' and b.ts_cnt='0' and
a.tran_date=b.tran_date and a.sol_id=s.sol_id
group by
b.tran_id,b.teller_acct,a.entry_user_id,a.vfd_user_id,a.sol_id,s.sol_desc,b.sol_id,
s.sol_desc;

a)first check tailer account no clr balance amt in tbaadm.gam table.

b)second check tbaadm.tach table to tailer account no reg_amt and total cash amt.
c)check denomination in tbaadm.tacd table all denomination are correct.
d) If denomination are correct the update the reg_amt and total cash amt in
tbaadm.tach table same like tbaadm.gam table clr_bal_amt.
Note: For this updation only issue for closing valut then this step is follow.
-----------------------------------------------------------------------------------
------------------------------------------------------------------------
2)which branche are verify the transaction this branches valut are not open then
follow this step.

a)first check valut account no close ya open. if account close then check
denomination.
b)first export the insert query for issue valut no for the perticular date and
change the tran_date as next working date and import records and
this record del_flg is N and status is O and import in tbaadm.tach table.
c)after import record close the current date valut status and del_flg is update
like status is C and del_flg is Y in tbaadm.tach table.
d)same step follow in tbaadm.tacd table export the denomination perticulare date
and import the records and this records tran_date is next working date
e)after import records del_flg is Y in current date in tbaadm.tacd table.

===================================================================================
===============================================================================

DTD To HTD movement menu --> HDTOH

EAB tbale movement ---> HEABR menu

===================================================================================
=======================================================================

Avail deposit account going negative for acct

select avail_deposit_amt,deposit_amount,open_effective_date from tbaadm.tam; where

acid in('AA1039911','AA3773278');

note : update karyche avail_deposit_amt la jo clr_bal_amt aahe he update karyche.

===================================================================================
===========================================================================
This type of fatal error come

Bufman error: 1403; Table: COT; Operation: S\r\nKey: [AA3171452/01]

Insert into TBAADM.COT

(ACID,ENTITY_CRE_FLG,DEL_FLG,CHRGE_OFF_DATE,CHRGE_OFF_PRINCIPAL,PENDING_INTEREST,PR
INCIPAL_RECOVERY,INTEREST_RECOVERY,DATE_NON_ACCRUE,
INT_SUSPENSE_AMT,PENAL_INT_SUSPENSE_AMT,LCHG_USER_ID,LCHG_TIME,RCRE_USER_ID,RCRE_TI
ME,TS_CNT,REASON_CODE,ACCRUED_INT_RECOVERY,WAIVED_ACCRUED_AMT,
COLLATERAL_VALUE,CHARGE_OFF_TYPE,MODE_OF_OPER,PROVISION_AMT,DEFERRED_INT_AMT,HLDY_P
ERD_INT_AMT,EMICAP_DEFERRED_INT,CHRGOFF_NONPASTDUE_FLG,BANK_ID,
ACCRUED_PENAL_INT_RECOVERY,PENAL_INT_RECOVERY,COLL_INT_RECOVERY,COLL_PENAL_INT_RECO
VERY)values ('AA3169865','Y','N',null,0,0,0,0,
to_date('02-10-2024 00:00:00','DD-MM-YYYY HH24:MI:SS'),0,0,'E2066',to_date('31-10-
2024 17:24:41','DD-MM-YYYY HH24:MI:SS'),
'UBSADMIN',to_date('03-10-2024 07:21:28','DD-MM-YYYY HH24:MI:SS'),2,null,0,0,0,'
',' ',0,0,0,0,' ','01',0,0,0,0);

multiple records insert

Insert into tbaadm.cot select b.acid,'Y','N',null,0,0,0,0,

to_date('02-10-2024 00:00:00','DD-MM-YYYY HH24:MI:SS'),0,0,'E2066',to_date('31-10-
2024 17:24:41','DD-MM-YYYY HH24:MI:SS'),
'UBSADMIN',to_date('03-10-2024 07:21:28','DD-MM-YYYY HH24:MI:SS'),2,null,0,0,0,'
',' ',0,0,0,0,' ','01',0,0,0,0 from
tbaadm.cot a,tbaadm.gam b where b.acid not in
(select acid from tbaadm.cot) and b.schm_type='LAA'
and b.gl_sub_head_code='31035' group by
b.sol_id,b.foracid,b.acid,b.gl_sub_head_code order by 1;

Note: Only change acid no like AA3169865 this

===================================================================================
=========================================================================

Bufman error: -1; Table: IDDT; Operation: I\r\nKey:

[AA3187220/ACCNT/D/N/00001/00001/01]

select * from tbaadm.IDDT where entity_id='AA3187220';

select * from tbaadm.IDT where entity_id='AA3187220';

1.check two table records data are correct or not.

2.check two tables BANK_ID if bank mis match in two table then update the same.
===================================================================================
======================================================================

E4822 : The employee SOL ID and the user profile do not match.

select * from finfadm.urm_upr_coreserver where user_id ='SDC026';

update finfadm.urm_upr_coreserver set user_emp_id ='2614' where user_id ='SDC026';

commit;

select * from tbaadm.get where sol_id ='1040';

select * from tbaadm.gec where sol_id ='1040';

===================================================================================
==========================================================================
ASMAB batch job check

select count(*) from CUSTOM.c_alert_data_cbs where alert_desc like 'Non%';

Loan
tbaadm.ldt
tbaadm.lam
tbaadm.lda
tbaadm.ltd

===================================================================================
=============================================================
UNCLIAM SETUP FOR TD

1) Go HTDGSPM menu
2) go to schme tab
--Duration to Mark A/c. as Inactive yana inactive zale pahije aasel tar count
takycha
--Duration from Inactive to Dormant ----count takycha
---Duration to Mark A/c. as Unclaimed (Months) month takyche 120 total zali pahije
note: Duration to Mark A/c. as Unclaimed (Months) yachi toatal 120 yala lagete
Duration to Mark A/c. as Inactive yana inactive+Duration from Inactive to Dormant
+Duration to Mark A/c. as Unclaimed (Months) yachi

select * from tbaadm.GSP;

select * from tbaadm.TSD;
select * from tbaadm.TSD;
select * from tbaadm.TSD;
select * from tbaadm.TSP;
select * from tbaadm.IN_TSP;
select * from tbaadm.DSD;
===================================================================================
======================================================================
There is nothing to verify ya modify aase aasel ya modify nasel hot tar ya table
madhe check karyche

select * from tbaadm.ga0 where acid='AA2673949';

select * from tbaadm.sm0 where acid='AA2673949';
select * from tbaadm.ast_mod where acid='AA2673949';
select * from tbaadm.ga1 where acid='AA2673949';
select * from tbaadm.aa0 where acid='AA2673949';

===================================================================================
=========================================================================

DATABASE ERROR :
Database Error Message - ^ORA-00942: table or view does not exist^
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
DBLayer Error Code = ^[DBL-50]^ Operation: ^[S]^
Database Query - ^[SELECT TDS_DUE_FLG FROM C_194NCWD_TXN WHERE 1=1 AND FIN_YEAR
= :1 AND FORACID = :2 AND TRAN_ID = :3 AND TRAN_DATE = TO_DATE( :4 ,'DD-MM-
YYYY') AND PART_TRAN_SRL_NUM
= :5 AND BANK_ID = :6 ]^
Bind Variables - ^
[1:s,5,(2025)]
[2:s,16,(120101710990001)]
[3:s,10,( MD175641)]
[4:s,11,(31-03-2025)]
[5:s,5,( 1)]
[6:s,3,(01)]^

select * from all_objects where object_name='C_194NCWD_TXN';

/
SELECT * FROM all_synonyms WHERE synonym_name='C_194NCWD_TXN';
CREATE synonym TBAGEN.C_194NCWD_TXN FOR CUSTOM.CUST_194N_CASHWD_TXN_TBL;
/
GRANT ALL ON TBAUTIL.C_194NCWD_TXN TO CRMUSER,TBAADM;

select * from custom.C_194NCWD_TXN;

select * from custom.C_194NCWD_TDS;
select * from custom.C_194NTDS_TXN;

note:- create all_synonyms for table

===================================================================================
===================================================================================
=====
TDS not clear record IN_TECH table after YEAR END eod process then follow this
process

update tbaadm.gct set TDS_START_DATE ='01-04-2025', TDS_END_DATE ='31-03-2026' ;

commit;
-----------------------------------------------------------------------------------
-------------------------------
create table migadm.gamTDA020425 as select * from tbaadm.gam where schm_type='TDA'
and acct_cls_flg='N' and wtax_flg='E';
UPDATE TBAADM.GAM SET WTAX_FLG ='T' WHERE WTAX_FLG ='E' and acct_cls_flg='N' and
schm_type='TDA';
rollback;
commit;
CREATE TABLE CUSTOM.IN_TECT_31032025 as (SELECT * FROM tbaadm.IN_TECT);
select * from tbaadm.IN_TECT where rcre_time>'01-04-25';---10258
SELECT * FROM CUSTOM.IN_TECT_31032025;
commit;

TRUNCATE TABLE tbaadm.IN_TECT;

select * from tbaadm.in_tect;
delete FROM TBAADM.IN_TECT where rcre_time<'01-04-25';
commit;

select * from tbaadm.gam where schm_type='TDA' and acct_cls_flg='N' and

wtax_flg='E';---9616--46456

===================================================================================
===================================================================================
==============

Oracle EAM Asset Activity Script
No ratings yet
Oracle EAM Asset Activity Script
3 pages
Db2explain Advis
No ratings yet
Db2explain Advis
9 pages
Rsbpcoll
No ratings yet
Rsbpcoll
4 pages
Datapatch Sanity Checks
No ratings yet
Datapatch Sanity Checks
4 pages
Wrong Results
No ratings yet
Wrong Results
18 pages
BODS - Job Control Table
No ratings yet
BODS - Job Control Table
8 pages
Db2 Class 12
No ratings yet
Db2 Class 12
23 pages
Fusion Queries
100% (2)
Fusion Queries
4 pages
Db2 Class 11
No ratings yet
Db2 Class 11
21 pages
Citybox
No ratings yet
Citybox
8 pages
PeopleSoft Security Tables
No ratings yet
PeopleSoft Security Tables
8 pages
Manual Práctico de SQL Jobs
No ratings yet
Manual Práctico de SQL Jobs
24 pages
HANA SQL StatementHints 1.00.122.03+
No ratings yet
HANA SQL StatementHints 1.00.122.03+
4 pages
Readme
100% (1)
Readme
5 pages
SQL Advisor 7qp5xpk82ftmz
No ratings yet
SQL Advisor 7qp5xpk82ftmz
72 pages
IT Performance Optimization
No ratings yet
IT Performance Optimization
4 pages
Automating Index Rebuilds in Multitenant Databases
No ratings yet
Automating Index Rebuilds in Multitenant Databases
19 pages
Other Definitions Functional Areas Then in The Functional Area Tab Select INCIDENT REGISTER and Enter Values
No ratings yet
Other Definitions Functional Areas Then in The Functional Area Tab Select INCIDENT REGISTER and Enter Values
9 pages
Job Conversion
No ratings yet
Job Conversion
66 pages
12 Job Processes
No ratings yet
12 Job Processes
6 pages
Informatica Metadata Query
No ratings yet
Informatica Metadata Query
12 pages
Inc
No ratings yet
Inc
12 pages
Document 1325788.1
No ratings yet
Document 1325788.1
3 pages
Oracle PL/SQL Initialization Log
No ratings yet
Oracle PL/SQL Initialization Log
3 pages
Common Scripts
No ratings yet
Common Scripts
25 pages
Addmrpt 1 74096 74124
No ratings yet
Addmrpt 1 74096 74124
10 pages
Ds Commands
No ratings yet
Ds Commands
2 pages
SQL Query Samples For Unilever Reports
No ratings yet
SQL Query Samples For Unilever Reports
2 pages
Hana SQL Statement
No ratings yet
Hana SQL Statement
7 pages
Daily Use Queries
No ratings yet
Daily Use Queries
6 pages
SQL Server Job Status Check
No ratings yet
SQL Server Job Status Check
62 pages
RPFIEU SAFT EXT SDPROC Franca
No ratings yet
RPFIEU SAFT EXT SDPROC Franca
43 pages
SQL DDL and DML Commands Guide
No ratings yet
SQL DDL and DML Commands Guide
7 pages
QUERIES
No ratings yet
QUERIES
4 pages
Migration Doc-NEC-BPC Compass Wages Extract
No ratings yet
Migration Doc-NEC-BPC Compass Wages Extract
13 pages
Slides
No ratings yet
Slides
24 pages
XXSDL No Sgwi Payroll Int PKG
No ratings yet
XXSDL No Sgwi Payroll Int PKG
161 pages
SQL Practice Questions and Answers
No ratings yet
SQL Practice Questions and Answers
20 pages
SQL Scripts for PowerCenter Monitoring
No ratings yet
SQL Scripts for PowerCenter Monitoring
4 pages
UAT Database Observations
No ratings yet
UAT Database Observations
26 pages
Active Session History
No ratings yet
Active Session History
4 pages
Informatica Tips for ETL Developers
No ratings yet
Informatica Tips for ETL Developers
27 pages
FM For Finding Manager For An Employee
No ratings yet
FM For Finding Manager For An Employee
2 pages
OPM Financials (GMF) Troubleshooting Guide (ID 1213193.1)
100% (4)
OPM Financials (GMF) Troubleshooting Guide (ID 1213193.1)
28 pages
Approval Rule Setup Job Level Based On Replication GL 3-6
No ratings yet
Approval Rule Setup Job Level Based On Replication GL 3-6
8 pages
SAP BasisnKnown Issues
No ratings yet
SAP BasisnKnown Issues
17 pages
RJ Training Plan SQL
No ratings yet
RJ Training Plan SQL
35 pages
Oracle Manufacturing SQL Debug Guide
No ratings yet
Oracle Manufacturing SQL Debug Guide
32 pages
PR WF
No ratings yet
PR WF
5 pages
BKP Info
No ratings yet
BKP Info
6 pages
89273
No ratings yet
89273
2 pages
Apps Tables STR
No ratings yet
Apps Tables STR
17 pages
HANA SmartDataAccess SQL 1.00.60+
No ratings yet
HANA SmartDataAccess SQL 1.00.60+
9 pages
Queries 1
No ratings yet
Queries 1
19 pages
SQL Statements
No ratings yet
SQL Statements
9 pages
Ciclo de Pagamento Trace
No ratings yet
Ciclo de Pagamento Trace
47 pages
Loan Data Processing Guide
No ratings yet
Loan Data Processing Guide
13 pages
Print Validations Mail - 23042024
No ratings yet
Print Validations Mail - 23042024
2 pages
Con Final
No ratings yet
Con Final
92 pages
Balance
No ratings yet
Balance
6 pages
Final
No ratings yet
Final
176 pages
SQL Session Configuration & Query
No ratings yet
SQL Session Configuration & Query
6 pages
The Implementation of API RP 1102 Code To Evaluate Gas Pipeline Road Crossing
No ratings yet
The Implementation of API RP 1102 Code To Evaluate Gas Pipeline Road Crossing
10 pages
Legendre Polynomials Assignment
100% (1)
Legendre Polynomials Assignment
2 pages
Lead Mechanical Design Engineer in Atlanta GA Resume Tatiana Laguna
No ratings yet
Lead Mechanical Design Engineer in Atlanta GA Resume Tatiana Laguna
2 pages
Lag Manual
No ratings yet
Lag Manual
23 pages
66 1001 001-6 User Manual RFID Encoder
No ratings yet
66 1001 001-6 User Manual RFID Encoder
32 pages
RCH-Series Hollow Plunger Cylinders EN-US
No ratings yet
RCH-Series Hollow Plunger Cylinders EN-US
2 pages
El Cuento Mexicano de Fin de Siglo Algun
No ratings yet
El Cuento Mexicano de Fin de Siglo Algun
9 pages
Solutions For Exercises in Mechanical Behavior of Materials, 2nd Edition by William Hosford
No ratings yet
Solutions For Exercises in Mechanical Behavior of Materials, 2nd Edition by William Hosford
6 pages
White John S. The Limiting Distribution of The Serial Correlation Coefficient in The Explosive Case
No ratings yet
White John S. The Limiting Distribution of The Serial Correlation Coefficient in The Explosive Case
11 pages
101 Lab Sheet-3 1
No ratings yet
101 Lab Sheet-3 1
8 pages
Class X (Mathematics) : Holiday Homework
No ratings yet
Class X (Mathematics) : Holiday Homework
7 pages
Physics: Paper 0625/11 Multiple Choice
No ratings yet
Physics: Paper 0625/11 Multiple Choice
47 pages
Indian Journal Subscription Details
No ratings yet
Indian Journal Subscription Details
16 pages
Design Optimization of Crude Oil Distillation
No ratings yet
Design Optimization of Crude Oil Distillation
8 pages
Chain Rule Differentiation Lecture
No ratings yet
Chain Rule Differentiation Lecture
17 pages
Deep Learning Exam Guide
No ratings yet
Deep Learning Exam Guide
3 pages
Friction
No ratings yet
Friction
31 pages
Selecting The Right Thermodynamic Models For Process Simulation PDF
No ratings yet
Selecting The Right Thermodynamic Models For Process Simulation PDF
5 pages
Hill Train Power Generation and Automatic Railway Gate Controlling
No ratings yet
Hill Train Power Generation and Automatic Railway Gate Controlling
73 pages
Complete The Square Worksheet
No ratings yet
Complete The Square Worksheet
4 pages
Electrical Wiring for Students
No ratings yet
Electrical Wiring for Students
13 pages
Hospital Management Software Development: Olawale Ayotunde Sobogungod
No ratings yet
Hospital Management Software Development: Olawale Ayotunde Sobogungod
3 pages
Stairs: A Little Bit About Them: Slope
No ratings yet
Stairs: A Little Bit About Them: Slope
2 pages
TEE - CSE3001 - DBMS - 100237 - Dr. Harihrasitaraman.S - Winter21-22-Block1 - QP
No ratings yet
TEE - CSE3001 - DBMS - 100237 - Dr. Harihrasitaraman.S - Winter21-22-Block1 - QP
3 pages
RT - Specific Exam
100% (1)
RT - Specific Exam
3 pages
LQG/LTR Controller Design For Rotary Inverted Pendulum Quanser Real-Time Experiment
No ratings yet
LQG/LTR Controller Design For Rotary Inverted Pendulum Quanser Real-Time Experiment
7 pages
Method 8242 Heterotrophic Bacteria
No ratings yet
Method 8242 Heterotrophic Bacteria
6 pages
Admin & Teacher Impact on NAT Performance
No ratings yet
Admin & Teacher Impact on NAT Performance
12 pages
XED and YED + Exercises
No ratings yet
XED and YED + Exercises
5 pages
EO Extension in R12
100% (2)
EO Extension in R12
10 pages