nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

BI Publisher mutliple-reports for OTM

Antoine KAIBER

Summary

BI Publisher mutliple-reports for OTM

Content

Hello,

I've managed, thanks to some help from this forum ( ) to activate multi-reporting on OTM, but when I select multiple shipments on OTM, it merges my different reports instead of making 2 distinct reports (either multiple pdf's or 1 pdf with one report after another). What should I do to change that ?

Antoine

Find more posts tagged with

Accepted answers

All comments

Antoine KAIBER

Ok, I don't necessarily need multiple PDF's actually, if I can get one PDF but with the ShipmentA report and ShipmentB report with data that hasn't merged it is fine as well. I will send you the documents by mail !

Antoine KAIBER

Yes one data model. Actually I need to 2 pdf's that come out from one report. Apparently I can't upload anything other than an image, a video or a link, or maybe you know a way to upload word documents here ?

Venkat Thota - BIP

send to venkythota54@gmail.com

Its not possible for generating two pdf files from one report when running report Online.

You need to use bursting concept to deliever multiple PDF's from single report.

https://docs.oracle.com/cd/E21764_01/bi.1111/e18862/T527073T555155.htm

Venkat Thota - BIP

You want to create two separate reports using one data model ? one for shipmnetA and shipmentB.

upload you xml and template ,along with output samples

Venkat Thota - BIP

Can you detail your requirement what you are trying to achieve ?

what i understood was that you have one data model and on top of that you have to create two separate reports ?

Antoine KAIBER

Data Model.png

Antoine KAIBER

So basically I have a data model (image attached) and when I go in OTM (Oracle Transportation Management) and try to run the pick-up sheet report for multiple shipments, I get only one report with is a merger of the two shipments I selected.

Before I couldn't even select more than 1 shipment ID to run a report but someone helped me by telling me to add the condition "and SH.SHIPMENT_GID in(:P_SHIP_ID)" to my SQL Table (see above) to be able to run multiple reports.

Now this works but the reports are merged in one PDF (for example in the item area of the report I have all the items of shipment A and Shipment B where I need two reports. One for shipment A and one for shipment when I need them to be separate.

Antoine KAIBER

My SQL table for my Data Set shipment is this :

select sh.SHIPMENT_GID

, sh.SHIPMENT_XID

, sh.DEST_LOCATION_GID

, coalesce (c1.CORPORATION_NAME,' ') DEST_NAME

,coalesce (c1.CORPORATION_GID,' ') DEST_GID

, l1.LOCATION_NAME DEST_LOC_NAME

, l1.CITY DEST_CITY

, l1.POSTAL_CODE DEST_CP

, l1.COUNTRY_CODE3_GID DEST_COUNTRY

, ct1.COUNTRY_NAME DEST_COUNTRY_NAME

, substr(LTRIM(sh.DEST_LOCATION_GID,sh.DOMAIN_NAME||'.'),13,19) DEST_GATE

, substr(LTRIM(sh.DEST_LOCATION_GID,sh.DOMAIN_NAME||'.'),1,11) DEST_PLANID

, sh.SOURCE_LOCATION_GID

, coalesce (c2.CORPORATION_NAME,' ') SRC_NAME

,coalesce (c2.CORPORATION_GID,' ') SRC_GID

, l2.LOCATION_NAME SRC_LOC_NAME

, l2.CITY SRC_CITY

, l2.POSTAL_CODE SRC_CP

, l2.COUNTRY_CODE3_GID SRC_COUNTRY

, ct2.COUNTRY_NAME SRC_COUNTRY_NAME

, substr(LTRIM(sh.SOURCE_LOCATION_GID,sh.DOMAIN_NAME||'.'),13,19) SRC_GATE

, substr(LTRIM(sh.SOURCE_LOCATION_GID,sh.DOMAIN_NAME||'.'),1,11) SRC_PLANID

, sh.SERVPROV_GID

, sh.VOYAGE_GID

, sh.TOTAL_WEIGHT

, sh.TOTAL_WEIGHT_UOM_CODE

, sh.TOTAL_VOLUME

, sh.TOTAL_VOLUME_UOM_CODE

, sh.TOTAL_SHIP_UNIT_COUNT

, sh.TOTAL_PACKAGING_UNIT_COUNT

, sh.TOTAL_ITEM_PACKAGE_COUNT

, sh.SHIPMENT_TYPE_GID

from SHIPMENT sh

,LOCATION l1 left join LOCATION_CORPORATION lc1

ON l1.LOCATION_GID= lc1.LOCATION_GID left join CORPORATION c1

ON lc1.CORPORATION_GID= c1.CORPORATION_GID

, LOCATION l2 left join LOCATION_CORPORATION lc2

ON l2.LOCATION_GID= lc2.LOCATION_GID left join CORPORATION c2

ON lc2.CORPORATION_GID= c2.CORPORATION_GID

,COUNTRY_CODE ct1,COUNTRY_CODE ct2

where l2.LOCATION_GID=sh.SOURCE_LOCATION_GID

and l1.LOCATION_GID=sh.DEST_LOCATION_GID

and l1.COUNTRY_CODE3_GID=ct1.COUNTRY_CODE3_GID

and l2.COUNTRY_CODE3_GID=ct2.COUNTRY_CODE3_GID

and SH.SHIPMENT_GID in(:P_SHIP_ID)

Venkat Thota - BIP

No not received.

else use venkythota54@yahoo.com

Venkat Thota - BIP

creation of more than one report is possible using single data model. send me documents.