Categories
- All Categories
- 104 Oracle Analytics News
- 9 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 58 Oracle Analytics Trainings
- 60 Oracle Analytics Data Visualizations Gallery
- 5 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
BI Publisher mutliple-reports for OTM

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
Answers
-
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 !
0 -
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 ?
0 -
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
0 -
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
0 -
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 ?
0 -
0
-
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.
0 -
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)
0 -
No not received.
else use venkythota54@yahoo.com
0 -
creation of more than one report is possible using single data model. send me documents.
0