Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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
