R12: CE - Forms Personalization Does Not Take Effective After RPC 4 (Doc ID 2183112.1)

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.

Goal

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)
Level: Function

-------------
Condition
-------------
Trigger Event: WHEN-VALIDATE-RECORD
Trigger Object: RECONCILED
Condition: :RECONCILED.GL_DATE<>:RECONCILED.CLEARED_DATE
Processing Mode: Not in Enter-Query Mode

-----------
Actions
-----------
Message:
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.
 

Solution

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