Last updated on SEPTEMBER 26, 2016
Applies to:Oracle Cash Management - Version 12.1.3 and later
Information in this document applies to any platform.
1. Create form personalization in order to prevent users to un-reconcile cash statements from past date:
Form Personalization Name: Unreconcile (DL_DATE not equal CLEARED_DATE)
Trigger Event: WHEN-VALIDATE-RECORD
Trigger Object: RECONCILED
Processing Mode: Not in Enter-Query Mode
Unreconcilation is impossible. GL_DATE doesn't equal CLEARED_DATE :RCONCILED.CLEARED_DATE
Builtin Type: RAISE FORM_TRIGGER_FAILURE
2. Unreconcile any bank statement line
3. Bank statement is unreconciled -> issue
Expectation: Bank statement unreconcile should not be possible due to personalization done.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms