6 Replies Latest reply: Jan 30, 2013 2:22 PM by 987240 RSS

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

    869093
      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-Oracle
          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
            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
              >
              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
                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
                  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
                    Have you tried removing contentDelivery="immediate" from your table property and leave it as default value of "whenAvailable"?