Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Insert base64 QR Code data in Oracle Fusion
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!
Answers
-
QR Code is an image you should be able to store as a BLOB in Oracle Fusion database.
0 -
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
0 -
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:
0 -
This forum is for Oracle Analytics Cloud and Oracle Analytics Server.
Recommend you post in an Oracle Fusion Applications forum for your requirement.1
