Saturday 8 December 2018

Bank statement interface error tables in Oracle

Bank statement interface error tables

When we do imports the Bank Statements in Oracle some time it got rejected due to some setup issues or some other reasons also so we need to know the process of How we can identify these errors and to put some actions to control this or fix this. Here in this post I will share the Methods to find the Banks Statement Interface errors using application and the Error Tables.
 

Two Ways to find the Bank Statement Interface Errors in Oracle

1. From Front End Application to find the error in the Imported Bank Statement.
2.From Bank End using Bank statement interface error tables.
 
 

From  Front End Using Application to find the Interface Errors

Step1:-
Go to Cash Management ==> Bank Statements ==> Bank Statement Interface.
 
In this Form , you will get all the error out Bank Statement which is not imported to Base Tables to some Errors.
 
Bank statement interface error tables
 
Step2:-  For Example this is the bank statement whose status is showing " Error". To see the Statement Header Errors table , click on the Errors button.
 
To see the Bank Statement Lines Error ==> Go to  the Lines Button and Then then we need to find the errors for each line.
 
Bank statement interface error tables
 
 

From Bank End using Bank statement interface error tables

These are the below Bank statement interface error tables to find the Statement Errors in Oracle
.
1CE_HEADER_INTERFACE_ERRORS
2.CE_LINE_INTERFACE_ERRORS
3.CE_SQLLDR_ERRORS
 

 
 

Bank statement interface error tables

0 comments:

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *