Insert base64 QR Code data in Oracle Fusion

Question

Hello Oracle Community,

We are working on implementing eInvoice solutions for our client. From the API, we receive base64 QR Code data, which is 16,000 characters in length. Once we receive this data, we need to store it in Oracle Fusion against each AR Invoice, so that the QR Code can be printed in the BI Report. The problem is that there is no standard field available to capture this, and DFF does not support the CLOB datatype in Oracle Fusion.

If anyone has worked on a similar requirement, your guidance or recommendations would be greatly appreciated.

Thank you in advance for your support!

Steve F-2 · Answer

This forum is for Oracle Analytics Cloud and Oracle Analytics Server.

Recommend you post in an Oracle Fusion Applications forum for your requirement.

Syamantak Saha · Answer

For your particular requirement, you can ask your DBA to create a separate schema and table where you can store the QR Code as BLOB. Also, ask him to take regular backups for this.

Oracle also provides storing Large Objects on Cloud:

https://www.oracle.com/cloud/storage/object-storage/

User_V9TJK · Answer

There is no such table or column exists in Accounts Receviables. I was hoping to store that base64 data as Varchar and use RTF tags to generate QR Code image. If you are aware of any such details, please let me know