Journal Approval Deadline Due Date Expression Error ORABPEL-30046exception.code:30046exception.type The expiration specified in the routing slip could not be evaluate (Doc ID 2995172.1)

Last updated on DECEMBER 27, 2023

Applies to:

Symptoms

On : 11.13.23.07.0 version, Journals and Intercompany

When attempting to use the expression /task:task/task:payload/ns6:findJournalBatchResponse/ns6:result/ns0:LastUpdateDate > TO_DATE('2023-09-20 13:50:00', 'YYYY-MM-DD HH24:MI:SS') in the Deadline section > Due Date, all approvals fail with the following error occurs.

ERROR
-----------------------
ORABPEL-30046exception.code:30046exception.type: ERRORexception.severity: 2exception.name: Error in routing slip.exception.description: The expiration specified in the routing slip could not be evaluated. The error is exception.code:37058exception.type: ERRORexception.severity: 2exception.name: Invalid value for xpath expression.exception.description: The xpath expression /task:task/task:payload/ns6:findJournalBatchResponse/ns6:result/ns0:LastUpdateDate > TO_DATE('2023-10-19 13:50:00', 'YYYY-MM-DD HH24:MI:SS') is invalid: Parse Error in TO_DATE function.exception.fix: Verify that the xpath expression is valid for the task data.. The routing slip is associated with the task definition default/FinGlJrnlEntriesApprovalComposite!11.13.23.07.0/FinGlJournalApproval.exception.fix: Make sure that the expiration duration is specified correctly. The value should conform to XML duration specifications.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Edit the journal approval task
2. In the Deadline tab enter for the Deadline Due Date set the expression /task:task/task:payload/ns6:findJournalBatchResponse/ns6:result/ns0:LastUpdateDate > TO_DATE('2023-09-20 13:50:00', 'YYYY-MM-DD HH24:MI:SS')

3. validate and commit
4.Test any approval

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.