You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Why does Oracle retain CE_STMT_BALANCES rows after a bank statement header and lines are deleted?

in Payables, Payments & Cash Management 2 comments

Summary:

We encountered a scenario in Oracle Fusion Cloud Cash Management where a user manually created a bank statement and subsequently deleted it from the UI.

After the deletion:

  • The statement header was removed from CE_STATEMENT_HEADERS
  • The statement lines were removed from CE_STATEMENT_LINES
  • However, the associated balance rows still exist in CE_STMT_BALANCES, with STATEMENT_HEADER_ID values that no longer exist in CE_STATEMENT_HEADERS

This raises several questions:

  1. Is it expected behavior that CE_STMT_BALANCES retains records even when both the statement header and lines are deleted?
  2. Does Oracle intentionally keep balance data for audit or reconciliation history purposes?
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!