Oracle Banking Electronic Data Exchange for Corporates provides a summarized and detailed inquiry screen to view the files that have been received for processing. All stages of the file - previous, current and pending - are available on this screen.

Along with the status of the file, any errors encountered during the file lifecycle are also available on this screen. Screen provides a detailed information about the ACKs/NACKs sent, channel approval status, de-dupe and reconciliation status of individual record. Screen also provides an option to download the ACK/NACK response, handoff files and response files.

Bank user will be able to inquire each and every action, processing status, errors, stages, files exchanged along with the time stamp of that activity from this screen

For the files, those required the channel approval; the bank user will be able to view the approver details for every record in approval hierarchy with Approver name and Timestamp.

When the file is uploaded with multiple records, and out of those all records some of the records are approved, some are rejected and some are in other state .In this case, the application is intelligent enough to capture and display all those records as per their current status in application. .And once the bank user selects the counts of records across various status, the application will display those records sorted as per there status in Record Details tab.

File Inquiry:

This screen is refers for File Inquiry – Summary Page

Navigation Path:

From the Electronic Data Exchange, select Inquiries , click File Inquiries

On accessing ‘File Inquiry’ option from the menu, by default screen displays the summary of the files uploaded on that day with respective statuses. User can choose to view the details of the file by clicking on the File Reference ID or can even choose to search the files uploaded on previous days clicking search filters.

1. Refer to the following table for specifying details in the above screen:

   Note:

   Fields marked with ‘*’ are mandatory.

   Table 12-1 Field Description

   Field Name	Description
   Corporate	Displays name Party/Corporate name Displays corporate Alias | Displays Corporate ID
   File Name	Displays file name, that has been uploaded
   File Reference Number	Display the file reference number (File Message ID from the Uploaded File) and Upload Date Time
   Format	Displays format ID for the uploaded file
   Transaction	Displays transaction type along with transaction category and transaction name
   #Records	Displays number of records present in the file
   Status	Displays Current (Logical) Status of the file

This screen is refers for File Inquiry – Details Page

On clicking on the File Name from the summary page of file inquiry, following screen is displayed to the user. Screen displays the basic file details like name, status, reference id etc. along with the file journey

User can download the file inquiry report by clicking on the

button.

On click of View File Details, file details and the download button to download the incoming file is displayed in the right drawer as shown below.

On click of the Record Details tab, record summary in the form of the pie chart will be displayed along with the record data as shown below for each transaction.

User can download the record inquiry report by clicking on the

button.

Record Journey

Record Journey is displayed for each record on the click of the Status.

1. Refer to the following table for specifying details in the above screen:

   Table 12-2 Field Description

   Field Name	Description
   Stage details
   File Stage Details	Displays stage details which file pass through along with status and Timestamp
   	Primary Stage	File Processing Stage
   	Received	File Reception Process Initiation
   	Parsed	File Name Check Pre Parsing Check Parsing
   	Verified	File Dedupe Check File Validation Transaction Dedupe Check Transaction Syntax Check Record  Level Validations
   	Corporate Approval	Channel Approval (Corporate Approval Matrix - Record Synopsis )
   	Handoff Generation	Handoff Generation (Hand Off File Status)
   	Response Received	Response Reception
   	Response Sent to Corporate	Response Sent to Corporate
   Acknowledgement/Response Status	Displays ACK / NACK / Responses generated as per predefined corporate preference with option to download response details and resend the response details.
   File details
   File Reference	Displays the file reference number
   Corporate ID	Displays the Corporate ID from which file has been received
   Alias	Displays the Corporates Alias name
   File Name	Displays file name, that has been uploaded
   Customer Reference	Displays the Message Id of the file uploaded, Data in this field is displayed for payments related files uploaded
   Upload Date	Displays upload date of the file
   Format	Displays format for the uploaded file
   Channel	Displays the channel name in which file was received/sent
   Transaction Category	Displays the transaction category of the received file
   Transaction Name	Displays the transaction name for which bulk file has been uploaded
   Number Of Records	Displays the number of the transaction available in File
   File Size	Displays the file size
   Upload Date	Displays the upload date and time of the file received
   Download File	Option to download the original file
   Record details (For Payments)
   Record Number	Displays Record Reference Number assign to the record
   Payment Reference Number	Displays Payment Reference Number for the transaction record processed
   Value Date	Displays value date of the transaction processed
   Amount	Displays the amount of the transaction with currency
   Debit Account	Displays the Debit Account Number
   Debit IBAN	Displays Unique International Bank Account Number
   Credit Account	Displays the Credit Account Number
   Credit IBAN	Displays Unique International Bank Account Number
   Beneficiary Name	Displays the beneficiary name of transaction
   Payment Method	Displays the mode of payment.
   Processing Stage	Displays the stage at which transaction is lying
   Status	Displays the status of the transaction whether it is processed or failed.
   Record details (For Open Virtual Account)
   Record Number	Displays Unique Record Number generated in OBEDX for the transaction record
   Real Customer Number	Display the Real Customer Number received in the uploaded file
   Real Account Number	Display the Real Account Number received in the uploaded file
   Virtual Entity ID	Display the Virtual Entity ID received in the uploaded file
   Virtual Account Product	Display the Virtual Account Product received in the uploaded file
   Branch Code	Display the Branch Code received in the uploaded file
   Virtual Account Name	Display the Virtual Account Name received in the uploaded file
   Account Currency	Display the currency received in the uploaded file
   Virtual Account Number	Display the Virtual Account Number created in the Product Processor
   Processing Stage	Displays the stage at which transaction lying
   Status	Displays the status of the transaction whether it is processed or failed.
   Record details (For Close Virtual Account)
   Record Number	Displays Unique Record Number generated in OBEDX for the transaction record
   Virtual Account Number	Displays Virtual Account Number present in the incoming file
   Virtual Account Name	Displays Virtual Account Name present in the incoming file
   Real Customer Number	Displays Real Customer Number present in the incoming file
   Real Account Number	Displays Real Account Number present in the incoming file
   Virtual Entity ID	Displays Virtual Entity ID present in the incoming file
   Transfer In Virtual Account No	Displays Transfer In Virtual Account Number present in the incoming file
   Transfer Out Virtual Account No	Displays Transfer Out Virtual Account Number present in the incoming file
   Virtual Account Number	Display the Virtual Account Number created in the Product Processor
   Processing Stage	Displays the stage at which transaction lying
   Status	Displays the status of the transaction whether it is processed or failed.
   Record details (For Add Special Rates)
   Record Number	Displays Unique Record Number generated in OBEDX for the transaction record
   Virtual Account Number	Displays Virtual Account Number present in the incoming file
   Branch	This field in the incoming file is the code of the branch in which the accounts are created.
   Product	To calculate interest for an account, you must apply an interest product on the account. Every interest product is linked to an interest rule and interest will be calculated according to the formulae maintained in the rule. More than one interest product can be applied to an account.
   Effective Date	This indicates the date from which the Product-UDE combination takes effect. Different values can be maintained for a UDE, for different effective dates, for an account. When interest is calculated on a particular day for an account, the value of the UDE corresponding to the date will be picked up.
   UDE ID	Every product that is created is linked to a rule. In the rule, the UDEs (User Defined Element) that are required to calculate interest are specified. A rule can have more than one UDE.
   UDE Value	In this field the value of the UDE (i.e. rate) to be used for calculation of interest for the account is specified.
   Rate Code	Instead of specifying a value for the UDE, or in addition to the UDE value specified, a Rate code can be applied to the UDE. Rate code is maintained such that a specific rate is applicable from a specific effective date onwards.The rate that is maintained for the rate code as on the effective date will be picked up while calculating interest.
   TD Rate Code	Specify the rate code to be used for Term Deposit calculation. Can be used only for term deposit accounts when ‘Rate Chart Allowed’ flag is enabled for the account class linked to product.
   UDE Variance	The bank can also choose to give an additional rate as a variance over and above the UDE value given for the calculation of interest. The effective rate used for calculation will be UDE Value + Value from Rate Code + Variance.
   Processing Stage	Displays the stage at which transaction lying
   Status	Displays the status of the transaction whether it is processed or failed.
   Record details (Search Filter for Payments)
   Processing Stage	Display all the status applicable
   Value Date	Display as below Today Last 3 Days Last 7 Days Last 15 Days Date Range
   From Value Date	Select From date
   To Value Date	Select To date
   Currency	Display all available currencies
   Amount From	Provide the amount above which records will be filtered
   Amount To	Provide the amount below which records will be filtered
   Record details (Search Filter for Open Virtual Account)
   Processing Stage	Display all the status applicable
   Virtual Account Name	Provide Virtual Account Name for which filter is required
   Virtual Account Branch	Provide Virtual Account Product for which filter is required
   Virtual Account Product	Provide Virtual Account Product for which filter is required
   Account Currency	Display all available currencies
   Record details (Search Filter for Close Virtual Account)
   Processing Stage	Display all the status applicable
   Virtual Account Number	Provide Virtual Account Number for which filter is required
   Virtual Account Name	Provide Virtual Account Name for which filter is required
   Transfer In Virtual Account No	Provide Transfer In Virtual Account No for which filter is required
   Transfer Out Virtual Account No	Provide Transfer Out Virtual Account No for which filter is required
   Record details (Search Filter for Close Virtual Account)
   Processing Stage	Display all the status applicable
   Effective Date	Display as below Today Last 3 Days Last 7 Days Last 15 Days Date Range
   From Date	Select From date
   To Date	Select To date
   Virtual Account Name	Provide Virtual Account Name for which filter is required
   Product	Real time values based on distinct Product Id's present in this file
   UDE ID	Real time values based on distinct Product Id's present in this file