Module wise Reports in Oracle Banking Trade Finance

Module: Common Core

Table 3-1 Common Core Reports

Sr No.	Function ID	Report Name	Report Details
1	SMRBASTA	Batch Performance Statistics	Maximum, minimum and average performance record of each batch operation across all the branches in Oracle Banking Trade Finance.
2	SMRCONTL	Change Control Log	Change log details.
3	SMREVNLO	Event Log	Event log details.
4	SMRNWUSR	New User Created	New user created.
5	SMRROLPR	Role Profile	Details of the role profiles.
6	SMRSUMRY	User Role Summary	User role summary details.
7	SSRCONTL	User Change Control Log	User change log
8	SSRPINST	Security Maintenance Inactive User	Security maintenance inactive users.
9	SSRUSLOG	User Log Details Log	User log details log.
10	SSRUSRDS	Disabled Users System Violation Log	Disabled user’s system violation log.
11	SSRUSSTS	User Status Log	Provides user status log.

Module: Core Entities and Services

Table 3-2 Core Entities and Services Core Reports

Sr No.	Function ID	Report Name	Report Details
1	TFRTRDRP	Trade 360 Degree Report	This report gives the details of all contracts of a customer generated in trade 360 degree screen.
2	TFRITRDR	Islamic Trade 360 Degree Report	This report gives the details of all contracts of a customer generated in trade Islamic 360 degree screen.

Module: Brokerage

Table 3-3 Brokerage Reports

Sr No.	Function ID	Report Name	Report Details
1	BRRASSOC	Brokerage Association Report	This report gives the details of all associated brokers. It is printed daily as part of the batch process. You can configure this report to display details of brokerage contract.

Tax

Table 3-4 Tax Reports

Sr No.	Function ID	Report Name	Report Details
1	TARAYABL	Tax Payable Report	This report gives the details of all taxes that are to be paid over a period in time. You can specify the period for which you require the report when you invoke the report function.

Module: Letter of Credit

Table 3-5 Letter of Credit Reports

Sr No.	Function ID	Report Name	Report Details
1	LCRPEX	Expired Letters of Credit with Outstanding Items	Expired LCs with outstanding items report.
2	LCRPCOLI	Closed Letters of Credits	Closed LCs with outstanding items report.
3	LCRPDUE	Letters of Credit Due to be Expired	LCs Due to Expire report
4	LCRPCOLC	Letters of Credit Due to be Closed	LCs that are due for closure, during the period.
5	LCRPCODU	Commission Due Report	Periodic commissions that are due to be collected, for a specific period.
6	LCRPCAC	Commission Activity Report	LCs for which commission was liquidated or calculated, as of the date.
7	LCRPUNTR	Un-replied Tracers Report	Unreplied tracers report
8	LCRFNREP	Confirmed Letters of Credit Report	Confirmed LC Report
9	LCRPOVD	Letters of Credit Contract Overrides Report	The overrides that were encountered for contracts, on the date the report was generated
10	LCRLYREP	Daily Activity Report	Details of LCs daily activity journal report
11	LCRPACCR	Accruals Control Report	LCs that was accrued
12	LCRPACR	Commission Activity 3 Report	Commission Activity 3 Report
13	LCRPCACT	Periodic Commission Activity Report	Details of the periodic commission activity report
14	LCRPEXP	Letters of Credit Process Exception Report	The process exceptions that were encountered for contracts report
15	LCRIMLIC	Import License Details Report	Import licenses captured for each customer report
16	LCRILUTL	Import License Utilization	Utilization for an import license report
17	LCRGCLM	Guarantee Claim Lodging Report	Details of active guarantee contracts on which claim is lodged on the system

Module: Islamic Letter of Credit

Table 3-6 Islamic Letter of Credit Reports

Sr No.	Function ID	Report Name	Report Details
1	LIRPEX	Expired Letters of Credit with Outstanding Items	Expired Islamic LCs with outstanding items report
3	LIRPDUE	Letters of Credit Due to be Expired	Islamic LCs Due to expire report
4	LIRPCOLC	Letters of Credit Due to be Closed	Islamic LCs that are due for closure, during the period
5	LIRPCODU	Commission Due Report	Periodic commissions that are due to be collected, for a specific period.
6	LIRPCAC	Commission Activity Report	Islamic LCs for which commission was liquidated or calculated, as of the date
7	LIRPOPN	Open Ended Islamic Letters Of Credit	All the open ended Islamic LCs that has outstanding items
8	LIRPUNTR	Un-replied Tracers Report	Unreplied tracers report
9	LIRFNREP	Confirmed Letters of Credit Report	Confirmed Islamic LC Report
10	LIRPOVD	Letters of Credit Contract Overrides Report	The overrides that were encountered for contracts, on the date the report was generated
11	LIRLYREP	Daily Activity Report	Details of Islamic LCs daily activity journal report
12	LIRPACCR	Accruals Control Report	Islamic LCs that was accrued
13	LIRPCACT	Periodic Commission Activity Report	Details of the periodic commission activity report
14	LIRPEXP	Letters of Credit Process Exception Report	The process exceptions that were encountered for contracts report
15	LIRPCNFR	Confirmed LI Outstanding Report	Confirmed Islamic LC outstanding report
16	LIRPEXRP	Expired Islamic Letters of Credit Report	Details of the expired Islamic LC outstanding report
17	LIRPGUCL	Guarantees Due for Closure Report	Details of the guarantees that are due report
18	LIRPOGRP	Outstanding Guarantees	Details of the guarantees that are outstanding
19	LIRPREBK	Reimbursing Bank Report	Reimbursing Bank Report
20	LIRPSCCR	Suspense Charges Account Receivable Report	Suspense charges account receivable report
21	LIRPTRDT	Transferred Islamic Letters Of Credit Report	A customer-wise report of the Islamic letters of credits transferred.

Module: Bills and Collections

Table 3-7 Bills and Collections Reports

Sr No.	Function ID	Report Name	Report Details
1	BCROBUDS	Bills in User Defined Status	Expired LCs with outstanding items report
2	BCRONACT	Bills and Collections Contract Activity Report	Bills and collections contract activity report
3	BCRODPAY	Overdue payments	Bills that have payment items overdue
4	BCRODACC	Overdue Acceptance	Bills which have acceptance items overdue
5	BCRODFIN	Finalization Overdue Days Report	Details of bills, which have Finalization items.
6	BCRUEXCP	Bills and Collections Automatic Exceptions Report	Bills and collections automatic processing exceptions report
7	BCRONOVD	Bills and Collections Contract Overrides Report	Bills and collections contract overrides report
8	BCRENDOC	List of Bills with Pending Documents Report	Bills with pending documents report
9	BCROBUNP	Bills Under Protest Report	Bills under protest report displays all the bills generated for protest advice during the day.
10	BCROBTBP	Bills to be Protested Report	Bills which need to be protested for Nonpayment, Non-acceptance or Non-approval of discrepancies
11	BCRODMAT	Bills and Collections Contract Maturing Bills Report	Preferences for the generation of the report
12	BCROBEFR	List of Bills Eligible for Rediscounting Report	List of bills eligible for re-discounting report
13	BCRODAPP	Under Reverse Report	List of bills under reserve report
14	BCRMLTNR	Multi Tenor Bills Report	Multi tenor bills report

Module: Islamic Bills and Collections

Table 3-8 Islamic Bills and Collections Reports

Sr No.	Function ID	Report Name	Report Details
1	IBRENDOC	List of Bills with Pending Documents Report	Islamic Bills with pending documents report
2	IBROBTBP	Bills to be Protested Report	Islamic Bills which need to be protested for Nonpayment, Non-acceptance or Non-approval of discrepancies
3	IBROBEFR	List of Bills Eligible for Re-discounting Report	List of Islamic bills eligible for re-discounting report
4	IBROBUDS	Bills in User Defined Status	Islamic Bills in User Defined Status report
5	IBROBUNP	Bills Under Protest Report	Islamic Bills under protest report displays all the bills generated for protest advice during the day.
6	IBRODACC	Overdue Acceptance	Islamic Bills which have acceptance items overdue
7	IBRODAPP	Under Reverse Report	List of Islamic bills under reserve report
8	IBRODFIN	Finalization Overdue Days Report	Details of Islamic bills, which have Finalization items.
9	IBRODMAT	Bills and Collections Contract Maturing Bills Report	Preferences for the generation of the report
10	IBRODPAY	Overdue payments	Islamic Bills that have payment items overdue
11	IBRONACT	Bills and Collections Contract Activity Report	Islamic Bills and collections contract activity report
12	IBRONOVD	Bills and Collections Contract Overrides Report	Islamic Bills and collections contract overrides report
13	IBRUEXCP	Bills and Collections Automatic Exceptions Report	Islamic Bills and collections automatic processing exceptions report
14	IBRPBCRP	IB Issued Report	Islamic bills and collections issued report
15	IBRPIDLC	Import Documents under Islamic Letters of Credit MIS Report	Report of the documents imported under Islamic LC MIS
16	IBRPUAIC	Unaccepted Import Collection Outstanding Documents Report	Report of the outstanding documents due to unaccepted import collection
17	IBRMLTNR	Islamic Multi Tenor Bills Report	Report of the Islamic multi tenor bills

Module: Messaging System

Table 3-9 Messaging System Reports

Sr No.	Function ID	Report Name	Report Details
1	MSRTFLRT	Trade Finance Security Management System Log Report	Trade Finance Security Management System Log Report
2	MSRTFPEX	Trade Finance Upload Exception	Closed LCs with outstanding items report.
3	MSRTFPSX	Trade Finance Successful Messages Report	Successful Messages report
4	MSRTFSFT	Trade Finance Daily Swift Message Status Report	Trade Finance Daily Swift Message Status Report

Module: Liquidation

Table 3-10 Liquidation

Sr No.	Function ID	Report Name	Report Details
1	LQRTFDLY	Liquidation Daily Activity Report	Report provides information on all liquidation events or a particular event which took place on a specified date.
2	LQRTFPOS	Outstanding Items Report	Report provides the details of all outstanding liquidation records in both receivable and payable accounts, across the modules in Oracle Banking Trade Finance.