Current Position:Home > Table not populating values

Table not populating values

Update:10-11Source: network consolidation
Advertisement
Hello All,
I am populating Table for a Search Region and the values are not getting populated. I am altering the where clause in PFR of the CO. Please find the code in PFR.
String eNum = pageContext.getParameter("SearchEmpNum");
System.out.println("Employee Number " + eNum);
System.out.println("Post initQuery ");
OAViewObject vo = (OAViewObject)am.findViewObject("ZenPerSearchVO1");
if (vo != null) {
vo.clearCache();
vo.setWhereClause(null);
vo.setWhereClause("PERSON_ID in (select selected_person_id from hr_working_person_lists where owning_person_id = zen_person_details.get_person_id(:1))");
vo.setWhereClauseParams(null);
vo.setWhereClauseParam(0, eNum);
System.out.println("Params " + eNum);
//System.out.println("Post Clause " + vo.getQuery());
vo.executeQuery();
System.out.println("Post whereclause ");
The following is the Page
<?xml version = '1.0' encoding = 'UTF-8'?>
<page xmlns:jrad="http://xmlns.oracle.com/jrad" xmlns:oa="http://xmlns.oracle.com/oa" xmlns:ui="http://xmlns.oracle.com/uix/ui" version="10.1.3_1312" xml:lang="en-US" xmlns:user="http://xmlns.oracle.com/jrad/user" xmlns="http://xmlns.oracle.com/jrad" file-version="$Header$">
<content>
<oa:pageLayout id="PageLayoutRN" amDefName="zenith.oracle.apps.hxc.asg.server.ZenPerSearchAM" windowTitle="Employee Search Window" title="Employees">
<ui:corporateBranding>
<oa:image id="corporateBrandingImage" source="/OA_MEDIA/FNDSSCORP.gif"/>
</ui:corporateBranding>
<ui:contents>
<oa:query id="QueryRN" dispSimple="true" dispCustomized="false" dispAdvanced="false" mode="autoCustomizationCriteria" amDefName="zenith.oracle.apps.hxc.asg.server.ZenPerSearchAM" controllerClass="zenith.oracle.apps.hxc.asg.webui.ZenPersonSearchCO">
<ui:contents>
<oa:table id="ResultsTable" userCustomizable="true" shortDesc="Employees Assigned Table" amDefName="zenith.oracle.apps.hxc.asg.server.ZenPerSearchAM">
<ui:contents>
<oa:messageStyledText id="EmpNum" viewName="ZenPerSearchVO1" viewAttr="EmployeeNumber" queryable="true" sortState="ascending" prompt="Employee Number" selectiveSearchCriteria="true" initSortSeq="first" userCustomizable="true"/>
<oa:messageStyledText id="EmpName" queryable="true" sortState="no" viewName="ZenPerSearchVO1" viewAttr="FullName" prompt="Employee" unvalidated="true" selectiveSearchCriteria="true" userCustomizable="true"/>
</ui:contents>
</oa:table>
</ui:contents>
<oa:simpleSearchPanel>
<oa:header text="Employee Search" id="SimpleSearchHdr">
<ui:contents>
<oa:messageComponentLayout id="CustomSimpleSearch">
<ui:contents>
<oa:messageLovInput id="SearchEmpName" selectiveSearchCriteria="true" prompt="Employee Name" unvalidated="true" externalListOfValues="/zenith/oracle/apps/hxc/asg/lov/webui/ZenEmpLovRN" required="yes">
<lovMappings>
<lovMap id="EnameMap" lovItem="EmpName" resultTo="SearchEmpName" criteriaFrom="SearchEmpName"/>
<lovMap id="ENumMap" lovItem="EmpNum" resultTo="SearchEmpNum" criteriaFrom="SearchEmpNum"/>
</lovMappings>
</oa:messageLovInput>
<oa:messageTextInput id="SearchEmpNum" selectiveSearchCriteria="true" prompt="Employee Number"/>
</ui:contents>
</oa:messageComponentLayout>
</ui:contents>
</oa:header>
</oa:simpleSearchPanel>
<oa:simpleSearchMappings>
<oa:queryCriteriaMap id="EmpNameMap" criteriaItem="SearchEmpName" resultsItem="EmpName"/>
<oa:queryCriteriaMap id="EmpNumMap" criteriaItem="SearchEmpNum" resultsItem="EmpNum"/>
</oa:simpleSearchMappings>
</oa:query>
<oa:defaultSingleColumn id="ApplyRN">
<ui:contents>
<oa:submitButton id="SButton" text="Save" prompt="Save">
<ui:primaryClientAction>
<ui:fireAction/>
</ui:primaryClientAction>
</oa:submitButton>
</ui:contents>
</oa:defaultSingleColumn>
</ui:contents>
</oa:pageLayout>
</content>
</page>

The Best Answer

Advertisement
Hi,
Some of the column values are not getting populated or few rows which you are expecting is not getting populated?
Could you please try the following 2 changes, in both the cases, after executing the query, print all the query and rows in the VO using the below code (change your object names accordingly).
if(appraisalVO !=null)
AppraisalVORowImpl appraisalVORow = (AppraisalVORowImpl) appraisalVO.first();
if(appraisalVORow !=null)
int attrCount = appraisalVO.getAttributeCount();
writeLog("XXRBG",pageContext,"Attrbuute count "+attrCount);
String[] attributeNames = appraisalVORow.getAttributeNames();
for (int i = 0 ;i< attributeNames.length ;i++ )
writeLog("XXRBG",pageContext," Name "+attributeNames[i] +" = "+appraisalVORow.getAttribute(i));
1)
instead of calling the function to get the owning_person_id, hard code the value and check you are getting the expected result.
like,
vo.setWhereClause("PERSON_ID in (select selected_person_id from hr_working_person_lists where owning_person_id = 54)");
2)
instead of the below code
vo.setWhereClause("PERSON_ID in (select selected_person_id from hr_working_person_lists where owning_person_id = zen_person_details.get_person_id(:1))");
vo.setWhereClauseParams(null);
vo.setWhereClauseParam(0, eNum);
System.out.println("Params " + eNum);
try without binding the parameter like,
vo.setWhereClause("PERSON_ID in (select selected_person_id from hr_working_person_lists where owning_person_id = zen_person_details.get_person_id("+eNum+"))");
Thanks.
With Regards,
Kali.
OSSi.
  • How to set setRowKey value when table is populated dynamically Update:10-11

    Hi All I have created a view object using only select statement and displaying all the records in it in the table at page load. Table is SelectMany. Now after selecting some records I press submit button. At the backend logic is executed which prints

  • When is  table BOM_CTO_ORDER_LINES populated Update:11-30

    Soes anyone have any information regarding this Oracle table 'BOM_CTO_ORDER_LINES'. We are trying to determine when this table gets populated.  We know that the Autocreate config process populates the table but when exactly and which API does it  ?It

  • IDXNOALE - table is populated automatically Update:11-30

    Hi every one, I am working on Idoc - XI - Idoc scenario, whenever I send an Idoc from R/3 to XI, the IDXNOALE - table is populated automatically. Y is this. Can anyone please explain this? -Naveen.From one on the newest Service Pack the IDXNOALE is p

  • How many minimum tables get Populated once Employee Created in People scree Update:11-30

    Hi how many minimum tables get Populated once Employee Created in People screen ? thanxper_all_people_f per_periods_of_service per_person_type_usages_f per_all_assignments_f (as a primary assignment is mandatory for employee)Read other 3 answers

  • When RW_Server_Job_Queue table is populated. Update:11-30

    Hi All, I want to know how and when RW_Server_Job_Queue table is populated. I am printing a report from 10g print server through Scheduler. After Submitting the job I am tring to find the same in RW_Server_Job_Queue table but it is not populated thou

  • How does table CE4JJ01_ACCT populated? Update:11-30

    Hi All, Good day. I would like to seek help from everyone on how the table CE4JJ01_ACCT populated. Does it needs a program or a transaction code or a function module to be executed first in order to populate it. Your help is very much appreciated. Th

  • How is table VBFA populated? Update:11-30

    Hi Experts, I will appreciate if someone can explain to me how is table VBFA populated.  What is the logic for creating a record inside this table ?. Why are also some documents that only have 000000 as value in the POSNN field? Thanks for your help.

  • Table not populating values Update:10-11

    Hello All, I am populating Table for a Search Region and the values are not getting populated. I am altering the where clause in PFR of the CO. Please find the code in PFR. String eNum = pageContext.getParameter("SearchEmpNum"); System.out.print

  • ARP table not populating mac address for previously reachable IP address Update:10-11

    Router has been online and working fine with one BGP neighbor for almost 2 years and no downtime.  2 weeks ago, added a 2nd BGP peer.  Everything worked fine for 2 weeks, then all of a sudden yesterday the 2nd BGP peer is disconnected and does not co

  • How to check how this table is populated in PL/SQL Update:10-11

    Hi, This is based on assumption that it using a trigger , function or procedure to update this table tbl1 how can i find out how tbl1 is being updated ? do i check thru those "referenced by" ? or it updating another table set off a trigger that