My Oracle Support Banner

USING LOOKUPS TO SAME TABLE FROM XSD REPORT TEMPLATE (Doc ID 967057.1)

Last updated on NOVEMBER 07, 2018

Applies to:

LODESTAR EIP - Version: 1.5.0 - Release: 1.5
Information in this document applies to any platform.

Goal


In the custom report Open Items by Assigned to User there two input fields “From Bill Number” and "To Bill Number” both are look-ups to the same table and field and defined as following:

[[<xs:element name="INVOICEID" type="ls:lookup" ls:entity="CNBILLINVOICE" ls:caption="From Bill Number" /><xs:element name="INVOICEID" type="ls:lookup" ls:entity="CNBILLINVOICE" ls:caption="To Bill Number" />]


Currently only the name field can be used to define which column to use for a return value. However when OCCS renders this XSD report page using ‘lsrf\Parameters.asp’ and the stylesheet ‘datatools\PageGenerator.xslt’ both fields are rendered as:


[<tr>
<th align="right">From Bill Number</th>
<td><input name="X_INVOICEID" id="COMPANYNAME_NL_BIL_PRINTINVOICE_INVOICEID" value="" class="Lookup" onblur="LookupBlur('CNBILLINVOICE', this, 'INVOICEID')">
<button id="luCNBILLINVOICE_INVOICEID" name="luCNBILLINVOICE_INVOICEID" class="mPushButton" onclick="Lookup('CNBILLINVOICE','INVOICEID', '', '', '')">...</button></td>
</tr>
<tr>
<th align="right">To Bill Number</th>
<td><input name="X_INVOICEID" id="COMPANYNAME_NL_BIL_PRINTINVOICE_INVOICEID" value="" class="Lookup" onblur
]


Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Goal
  Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.