Previous Next JavaScript must be enabled to correctly display this content

## 12.1 File Inquiry – Oracle Banking Electronic Data Exchange for Corporates

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.

Figure 12-1 File Inquiries

Description of "Figure 12-1 File Inquiries"

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.

Figure 12-2 File Inquiry – Details Page

Description of "Figure 12-2 File Inquiry – Details Page"

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.

Figure 12-3 View File Details

Description of "Figure 12-3 View File Details"

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.

Figure 12-4 Record Details for Payments

Description of "Figure 12-4 Record Details for Payments"
Description of "Figure 12-4 Record Details for Payments"
Description of "Figure 12-4 Record Details for Payments"

Figure 12-5 Record Details for Open Virtual Account

Description of "Figure 12-5 Record Details for Open Virtual Account"

Figure 12-6 Record Details for Close Virtual Account

Description of "Figure 12-6 Record Details for Close Virtual Account"

Figure 12-7 Record Details for Add Special Rates

Description of "Figure 12-7 Record Details for Add Special Rates"

Record Journey

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

Figure 12-8 Record Journey

Description of "Figure 12-8 Record Journey"

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

Parent topic: File Inquiry