Oracle Analytics and AI

user2768902

I need to store authorized approver signatures in a cloud location and display the correct signature image in an Oracle BI Publisher RTF report based on business logic (e.g., department, cost, approval level).

** Oracle BI Publisher (RTF template), Oracle ERP Cloud (Fusion) **

Display the image conditionally using data-driven logic (department, cost thresholds, etc.)

Appreciate examples, best practices, or sample RTF/XDO syntax

JohnW-Oracle

Hello @user2768902,

This forum might be better for this question: https://community.oracle.com/products/oracleanalytics/categories/bi-publisher

I see a couple KM articles with BI Publisher on this.

How To Implement Digital Signature Xml Publisher Template KB458126

BI Publisher supports digital signatures on PDF output documents. Digital signatures enable you to verify the authenticity of the documents you send and receive.

Oracle BI Publisher can access your digital ID file from a central, secure location and at runtime sign the PDF output with the digital ID.

The digital signature verifies the signer's identity and ensures that the document has not been altered after it was signed.

Please find the details in bookshelf:
Implementing a Digital Signature

https://docs.oracle.com/middleware/11119/bip/BIPAD/digital_sig.htm

and

Digital Signature In Invoice KB339499

The following steps summarize the tasks required to set up and use digital signature with Oracle BI Publisher:

Register the digital ID in the BI Publisher Admin interface.

Specify the Roles that are authorized to sign documents.

(Optional for PDF templates) Add a signature field to the PDF template in which to place the digital signature at runtime.

Enable Digital Signature for the report in the Runtime Configuration properties and specify the position to place the digital signature on the completed document. This can be a signature field (for PDF templates), general location (top left, top center, or top right), or you can specify x and y coordinates.

Log in to BI Publisher as a user with an authorized role and submit the report through the BI Publisher scheduler, choosing PDF output. When the report completes it will be signed with your digital ID in the specified location of the document.

Additional details can be found here: https://docs.oracle.com/cd/E10383_01/doc/bip.1013/e10416/bip_digital_sigs.htm

Regards,

John