Payables and Cash Management - EBS (MOSC)

MOSC Banner

Amount Reconciled is not showing the correct amount reconciled for the statement line

edited Aug 20, 2021 7:40AM in Payables and Cash Management - EBS (MOSC) 3 commentsAnswered

I have an issue with Bank Statement reconciliation. The reconciled amount on the Statement lines form is not same as from ce_statemenrt_lines (tried with query behind tables

I am trying the same amounts from database tables. Data is not the same as it is from the form.

SELECT *

        FROM (

SELECT

       SH.STATEMENT_NUMBER,

       SD.STATEMENT_LINE_ID,

       SD.LINE_NUMBER,

       SD.TRX_TYPE,

       SD.TRX_CODE_ID,

       SD.AMOUNT,

       SD.STATUS,

       SUM(S.AMOUNT) RECON_AMOUNT,

       SH.STATEMENT_DATE,

       SUBSTR(SH.STATEMENT_DATE,4,6) PERIOD

FROM   CE_STATEMENT_RECONCILIATIONS S,

       CE.CE_STATEMENT_HEADERS       SH,

       CE.CE_STATEMENT_LINES         SD

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center