How to display a 2nd signature based on Check Amount

Craig Garcia

Hi, we have a requirement to print a second signature on a check when the check amount exceeds a threshold e.g., $25,000. We have created our RTF template with one static image and the second uses url:{xdoxslt:get_variable($_XDOCTX, 'logopath')} to display the signature.

We are using the following statement to test the payment amount

<?if: PaymentAmount/Value >=25000?> <?xdoxslt:set_variable($_XDOCTX, 'logopath', 'FILE_PATH')?> <?end if?>

This works for a single payment but when there are multiple payment in a Payment Process Request once the condition is met all checks after display the second signature even when less than $25,000. I suspect once the variable is set it being picked up for all payments. I tried resetting the variable after the if statement but this did not work.

Attached is an example of the template.

I appreciate any guidance.

Thanks, Craig

Example.rtf

Subha_Tripathy-Oracle

Hi @Craig Garcia

Thank you for visiting and posting in Fusion Analytics Warehouse(FAW) Product Community Page.

This forum is for FAW product and looks like your question is for Fusion Applications.

Please note that this Question is for Fusion Apps and it is managed in our
sister community, which can be found at the below links:

Oracle Cloud Customer Connect (   https://community.oracle.com/customerconnect  ).

Please make a note of the above URL and visit those Fusion Apps forums to submit ideas, receive support from our FA Cloud experts and check out the resources they have available for you.

Thanks
Subha

Gianni Ceresa

@Craig Garcia , no need to post it somewhere else, you asked in the right place.

@Subha_Tripathy-Oracle , this isn't the FAW community page, it's the Oracle Analytics community. The question is in the Publisher category because it is a technical question about how to achieve something in a Publisher template. The data source doesn't really matter…

Kevin M-Oracle

The layout starts with an issue:

<?for-each:OutboundPayment@section?>

It should be:

<?for-each@section:OutboundPayment?>

Rgds,

Kevin

Craig Garcia

Hi Kevin,

Thanks for the reply. When I change the Group Outbound Payment as above it results in blank pages being inserted in between each check. Also, it doesn't resolve the issue with the second signature not being displayed for checks less than $25K.

Thanks,

Craig

Kevin M-Oracle

Hi Craig,

You can try moving the page break to the top to right after the for-each@section.

I d not see a conditional statement around your images.

Rgds,

Kevin

Craig Garcia

Hi Kevin,

This is the statement I'm using to validate the check amount and set the variable with the image location.

<?if: PaymentAmount/Value >=25000?> <?xdoxslt:set_variable($_XDOCTX, 'logopath', 'FILE_PATH')?> <?end if?>

I can't get the variable to reset to null or 0 for each check in the payment request.

Thanks so much for the help.

Kevin M-Oracle

Try adding this field as well:

<?if: PaymentAmount/Value < 25000?> <?xdoxslt:set_variable($_XDOCTX, 'logopath', '')?> <?end if?

Rgds,

Kevin