For more information, please refer to this announcement explaining best practices for getting answers to questions.
We have requirement to validate and to get the sum of all pending in progress for an ICP
Summary:
We have requirement to validate and to get the sum of all pending transaction for an ICP in Oracle Fusion, using SQL query we are able to get the details. but while using the same query inside a Value set its not working.
Example :- Employee has 40k as child education limit for a year and he already has an approved transaction of 10k. Now he raised couple of request of 10k each(total 20k) which is "pending for approval". Is there a way that the next transaction, which is of 15k, can be validated against the amount of (Total eligibility - Approved Transaction - In progress transaction) so that employee should be restricted from submitting a new transaction.