Oracle Analytics and AI

Kath Alcayde

Hi,

Our requirement is to dynamically call the logo in the Purchase Order Document report based on the Legal Entity of the PO.

I have done several ways to achieve this output but it's not working.

I used UCM as image repository

I did the following:

1. I followed the steps indicated in Doc ID 2232740.1

300000001423024 = LegalEntityID

* I successfully uploaded the logo and got the url:

https://<hostname>:port/cs/groups/public/@public/@ucm_spaces/documents/digitalmedia/mdax/ndiz/~edisp/300000001423024.jpg

* To attached it in the RTF template, I modified the URL as indicated in the reference document:

https://<hostname>:port/cs/idcplg?IdcService=GET_FILE&RevisionSelectionMethod=Latest&dDocName=300000001423024

* To call it dynamically, I placed a dummy image and I used the follwong syntax in Alternate Text:

url:{concat('https://<hostname>:port/cs/idcplg?IdcService=GET_FILE&RevisionSelectionMethod=Latest&dDocName=',<LegalEntityIDColumn>)}

Result: Blank

2. Created a DFF and insert the image URL

Result: URL of the image appeared in the PDF instead of  the image

3. Other references: Doc ID 550627.1

Result: Blank

- What are the other possible ways to do this?

- Or where did I get it wrong?

- How to insert an image as BLOB in PER_IMAGES table in cloud environment?

Thanks.

Regards,

Kath

managed BEAN

Hello

I have read the docx provided in link.

The solution i am offering is not like that (no need for ucm), but it is up to you.

It´s directly from DB to get the blob and display it (are you interested? keep reading, otherwise forget. LOL ).

In data model make a query to select the BLOB, you can pass parameters in it, like :

select blob as thememo from imagetablewhere column = :someParameter

and you´ll have:

Now in rtf template you´ll have to insert a field (whit BIP add-on in MSWord):

Click in it twice and go to advanced tab and write:

<fo:instream-foreign-object content-type="image/jpg"height="1  in" width="1 in"><?THEMEMO?></fo:instream-foreign-object>

Run it and you´ll see the image.

Regards,

Carlos