This discussion is archived
6 Replies Latest reply: Jan 30, 2013 12:22 PM by 987240 RSS

Not able to see data in af:table unless refresh is clicked

869093 Newbie
Currently Being Moderated
We have a table which already has rows. But,when we are navigating to that table jsff page,no data is shown in the table.Only we click on add '+' icon or refreshing the page,I am able to see the data. Am i missing something in jsff definition? Here is the code for jsff page.It is a customiser generated page which comes on runtime.

<af:showDetailHeader text="#{adfBundle['oracle.apps.fnd.applcore.flex.runtime.FlexfieldResourceBundle']['FND:::FND_FFRES_oracle.apps.scm.productCatalogManagement.advancedItems.flex.egoItemEff.item.ui.bundle.d_EFF_AL_EFF_EGO_ITEM_DL_IL_PAGE_Private_PageBundleMsg#contextCode_5FAG_5FNT_5FMR_5FIL_5FMCDEF']}" id="CXTPB" contentStyle="padding:5px;" immediate="true" disclosed="true">
<f:facet name="context"/>
<f:facet name="menuBar"/>
<f:facet name="toolbar"/>
<af:toolbar id="t1"/>
<f:facet name="legend"/>
<f:facet name="info"/>
<f:facet name="help"/>
<fnd:applicationsTable tableId="ATt1" id="AT1" inlineStyle="width:99%;" deleteEnabled="#{true}" exportEnabled="#{false}" createPatternType="inline" createDisabled="#{!pageFlowScope._eff_containerBean.createPrivilegeForContext}" editDisabled="#{pageFlowScope._eff_read_only == 'Y'}" deleteDisabled="#{pageFlowScope._eff_read_only == 'Y'}" actionsMenuRendered="#{pageFlowScope._eff_read_only != 'Y'}" deleteImmediate="true" createImmediate="true">
<f:facet name="additionalToolbarButtons"/>
<f:facet name="additionalActionItems"/>
<f:facet name="table">
<af:table rows="#{bindings.ItemEFFBAG_5FNT_5FMR_5FIL_5FMCDEFPrivateVO.rangeSize}" fetchSize="#{bindings.ItemEFFBAG_5FNT_5FMR_5FIL_5FMCDEFPrivateVO.rangeSize}" emptyText="#{bindings.ItemEFFBAG_5FNT_5FMR_5FIL_5FMCDEFPrivateVO.viewable ? 'No data to display.' : 'Access Denied.'}" var="row" rowBandingInterval="0" value="#{bindings.ItemEFFBAG_5FNT_5FMR_5FIL_5FMCDEFPrivateVO.collectionModel}" selectedRowKeys="#{bindings.ItemEFFBAG_5FNT_5FMR_5FIL_5FMCDEFPrivateVO.collectionModel.selectedRow}" selectionListener="#{bindings.ItemEFFBAG_5FNT_5FMR_5FIL_5FMCDEFPrivateVO.collectionModel.makeCurrent}" rowSelection="single" id="ATt1" partialTriggers="::delete ::deleteMenuItem ::create ::createMenuItem" editingMode="clickToEdit" contentDelivery="immediate" columnStretching="last" autoHeightRows="10">
<af:column headerText="#{bindings.ItemEFFBAG_5FNT_5FMR_5FIL_5FMCDEFPrivateVO.hints._mruniqkey.label}" sortProperty="_mruniqkey" sortable="false" id="effcol0">
<af:inputText value="#{row.bindings._mruniqkey.inputValue}" label="#{bindings.ItemEFFBAG_5FNT_5FMR_5FIL_5FMCDEFPrivateVO.hints._mruniqkey.label}" required="#{ ( true) and pageFlowScope._eff_param2 != 'Y' }" columns="#{bindings.ItemEFFBAG_5FNT_5FMR_5FIL_5FMCDEFPrivateVO.hints._mruniqkey.displayWidth}" maximumLength="#{bindings.ItemEFFBAG_5FNT_5FMR_5FIL_5FMCDEFPrivateVO.hints._mruniqkey.precision}" shortDesc="#{bindings.ItemEFFBAG_5FNT_5FMR_5FIL_5FMCDEFPrivateVO.hints._mruniqkey.tooltip}" id="ecseg0" readOnly="#{ ( pageFlowScope._eff_read_only == 'Y' ) or pageFlowScope._eff_containerBean.mandatoryEffAttributes['AG_NT_MR_IL_MCDEF||_mruniqkey'] != null}" showRequired="#{ ( true) and pageFlowScope._eff_param2 != 'Y' }">


Please help me with this if I am missing something.
  • 1. Re: Not able to see data in af:table unless refresh is clicked
    Frank Nimphius Employee ACE
    Currently Being Moderated
    Hi,

    the page source doesn't give a hint. Check the iterator if there is a refresh condition set that doesn't populate the data on initial query

    Frank
  • 2. Re: Not able to see data in af:table unless refresh is clicked
    869093 Newbie
    Currently Being Moderated
    We have our iterator defined with refresh = "never" . Does it affects the initial query data?
  • 3. Re: Not able to see data in af:table unless refresh is clicked
    987240 Newbie
    Currently Being Moderated
    >
    We have our iterator defined with refresh = "never" . Does it affects the initial query data?
    >
    This will affect the behavior for sure. Try with refresh="ifNeeded".
    There could be other issues as well. Like Frank said, page source doesn't say much. Try to provide pagedef definitions.
    Also, please include the source inside {noformat}
    source
    {noformat} which supports source code formatting for readability.

    Edited by: Shah23 on Jan 29, 2013 9:02 AM
  • 4. Re: Not able to see data in af:table unless refresh is clicked
    Sudipto Desmukh Expert
    Currently Being Moderated
    Just wanted to point out that the default property for an iterator is defferred. You would like to try that as well.
  • 5. Re: Not able to see data in af:table unless refresh is clicked
    869093 Newbie
    Currently Being Moderated
    I tried with refresh from "never" to "ifNeeded" and "deferred" also,but still the problem exists. Here is the part of pagedef with the iterator binding :

    <?xml version='1.0' encoding='UTF-8'?>
    <pageDefinition xmlns="http://xmlns.oracle.com/adfm/uimodel" version="11.1.1.50.65" id="d_AG_NT_MR_IL_MCDEF_IL_PAGE_AL_EFF_EGO_ITEM_DL_EGO_ITEM_EFF_10010_PrivateFragPageDef" Package="pageDefs.oracle.apps.scm.productCatalogManagement.advancedItems.flex.egoItemEff.item.ui">
    <parameters>
    <parameter id="CONTEXTCODE" value="AG_NT_MR_IL_MCDEF"/>
    </parameters>
    <executables>
    <iterator Binds="Root.j_AlEffPrivateAM.j_ItemAlEffPrivateVO" DataControl="ItemAMDataControl" RangeSize="25" id="j_ItemAlEffPrivateVOIterator" Refresh="never"/>
    <accessorIterator MasterBinding="j_ItemAlEffPrivateVOIterator" Binds="ItemEFFBAG_5FNT_5FMR_5FIL_5FMCDEFPrivateVO" RangeSize="25" DataControl="ItemAMDataControl" BeanClass="oracle.apps.scm.productCatalogManagement.advancedItems.flex.egoItemEff.item.contexts.view.ItemEFFBAG_5FNT_5FMR_5FIL_5FMCDEFPrivateVO" id="ItemEFFBAG_5FNT_5FMR_5FIL_5FMCDEFPrivateVOIterator"/>
    </executables>
    <bindings>
    <listOfValues StaticList="false" IterBinding="ItemEFFBAG_5FNT_5FMR_5FIL_5FMCDEFPrivateVOIterator" id="_target_ctxt" Uses="LOV__target_ctxt">
    <AttrNames>
    <Item Value="_target_ctxt"/>
    </AttrNames>
    </listOfValues>
    <tree IterBinding="ItemEFFBAG_5FNT_5FMR_5FIL_5FMCDEFPrivateVOIterator" id="ItemEFFBAG_5FNT_5FMR_5FIL_5FMCDEFPrivateVO">
    <nodeDefinition DefName="oracle.apps.scm.productCatalogManagement.advancedItems.flex.egoItemEff.item.contexts.view.ItemEFFBAG_5FNT_5FMR_5FIL_5FMCDEFPrivateVO" Name="ItemEFFBAG_5FNT_5FMR_5FIL_5FMCDEFPrivateVO0">
  • 6. Re: Not able to see data in af:table unless refresh is clicked
    987240 Newbie
    Currently Being Moderated
    Have you tried removing contentDelivery="immediate" from your table property and leave it as default value of "whenAvailable"?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points