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

Last updated on DECEMBER 22, 2009

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms