BI Publisher (MOSC)

MOSC Banner

Excel template problem

edited Jun 27, 2012 2:04AM in BI Publisher (MOSC) 1 commentAnswered
1. Data file - data.xml2. template - LTC BoQ Export Template_V1.0.xls
3. revised template - addBlankLineLTC BoQ Export Template_V1.0.xls

Problem description :

1. The data file has three level
<HwPurchaseOrder>
......
<ListOfQuote>
<Quote>
......
<L       <ListOfHWPOOffsetContractBoqBC>
-          <HWPOOffsetContractBoqBC>
       ......
</HWPOOffsetContractBoqBC>
</ListOfHWPOOffsetContractBoqBC>
......
</Quote>
</ListOfQuote>
</HwPurchaseOrder>

2. The template has two group, one is group XDO_GROUP_?HWPOOffsetContractBoqBC?, the other is XDO_GROUP_?Quote?, and XDO_GROUP_?Quote? includes XDO_GROUP_?HWPOOffsetContractBoqBC. They are in the same line.

3. When use BIP desktop 11g template viewer to process data.xml and LTC BoQ Export Template_V1.0.xls, the Quote lines that has no Offset data are missing in the output excel report.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS BI Publisher Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center