Default Payment Date in AP Payment Workbench

http://aporaclepayables.blogspot.com/2016/10/default-payment-date-in-ap-payment.html

Personalization: 1

Trigger Event: WHEN-NEW-RECORD-INSTANCE
Trigger Object: PAY_SUM_FOLDER
Processing Mode: Not in Enter-Query Mode

Type: Property
Object Type: Item
Target Object: PAY_SUM_FOLDER.CHECK_DATE
Property Name: INITIAL_VALUE
Value: =select to_char(sysdate,'dd-mon-rrrr') from dual "or" =Sysdate

If this Error Occurs from Personalization: 1 then Try the below Personalization: 2
ORA-01403: no data found
FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-06502.


Personalization: 2

Trigger Event: WHEN-NEW-ITEM-INSTANCE
Trigger Object: PAY_SUM_FOLDER.VENDOR_NUMBER
Condition: :PAY_SUM_FOLDER.CHECK_DATE is null
Processing Mode: Not in Enter-Query Mode

Type: Property
Object Type: Item
Target Object: PAY_SUM_FOLDER.CHECK_DATE
Property Name: VALUE
Value: =select to_char(sysdate,'dd-mon-rrrr') from dual "or" =Sysdate