R12:CE: How Does the CE_STATEMENT_LINES Gets Tagged with STATUS = RECONCILED? Is There an API? (Doc ID 1986499.1)

Last updated on OCTOBER 23, 2015

Applies to:

Oracle Cash Management - Version 12.1.3 and later
Information in this document applies to any platform.


Customer has implemented the P2Land system recently.
Land Check process gets fired thru this new system.
When the Bank file comes in, it does have a list of Checks that have cleared,
which include the checks processed thru P2Land as well.
The file gets imported via the Seeded Oracle Load and Import into CE_STATEMENT_LINES and CE_STATEMENT_HEADERS.
There is a Custom concurrent program set up to read the Land Checks cleared on the file and Update the P2Land tables.

The checks processed thru P2Land are included in the Bank file as any other cleared check. 
Tried to reconcile those transactions using the standard procedure as per notes provided but it does not get tagged as RECONCILED.

Q1: How does the CE_STATEMENT_LINES get tagged with the STATUS = RECONCILED when the data come from a third party system?
Q2: Is there an API to change statement lines to reconciled?



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms