Format issue for Number field in af:query. Is it an ADF Bug?

Advertisement
Hi OTN,
Requirement : Format DepartmentId in query panel
I have created a view criteria from Employees table (HR Schema). I have four view criteria items called EmployeeId, DepartmentId, Firstname, LastName and all the items having validation property as Selectively Required. DepartmentId attribute have UI Hints property as Format Type = Number and Format = *0000* and Auto Submit=true.
But in UI, I am not able to do search from af:Query panel. It works fine without setting UI Hints property Format Type* and Format
Step 1 : Enter 123 in DepartmentId field
Step 2 : Click Search Button
Error : Please provide a value for atleast one of the indicated fields
Error Screen : http://www.freeimagehosting.net/24d51
Please check the below link for downloading the sample application
http://formatissue.googlecode.com/svn/trunk/FormatTest/FormatTest.zip
http://formatissue.googlecode.com/svn/trunk/FormatTest ( SVN version)
Note:
JDev Version : 11.1.1.5.0
I am using ADF BC and ADF Faces Components
Any recommendations fully appreciated
Thanks,
Dinil Mithra
Edited by: Dinil Mithra on Nov 23, 2011 4:51 PM
Edited by: Dinil Mithra on Nov 23, 2011 5:21 PM
Advertisement

Replay

Please find the metadata for VO attribute and View Criteria
<ViewAttribute
Name="DepartmentId"
PrecisionRule="true"
EntityAttrName="DepartmentId"
EntityUsage="Employees"
AliasName="DEPARTMENT_ID">
<Properties>
<SchemaBasedProperties>
<CONTROLTYPE
Value="edit"/>
<FMT_FORMATTER
ResId="model.EmployeesView.DepartmentId_FMT_FORMATTER"/>
<FMT_FORMAT
ResId="model.EmployeesView.DepartmentId_FMT_FORMAT"/>
<AUTOSUBMIT
Value="true"/>
</SchemaBasedProperties>
</Properties>
</ViewAttribute>
<ViewCriteria
Name="EmployeesViewCriteria"
ViewObjectName="model.EmployeesView"
Conjunction="AND">
<Properties>
<CustomProperties>
<Property
Name="displayOperators"
Value="InAdvancedMode"/>
<Property
Name="autoExecute"
Value="false"/>
<Property
Name="allowConjunctionOverride"
Value="true"/>
<Property
Name="showInList"
Value="true"/>
<Property
Name="mode"
Value="Basic"/>
</CustomProperties>
</Properties>
<ViewCriteriaRow
Name="vcrow103"
UpperColumns="1">
<ViewCriteriaItem
Name="EmployeesViewCriteria_vcrow103_EmployeeId"
ViewAttribute="EmployeeId"
Operator="="
Conjunction="AND"
Required="SelectivelyRequired"
GenerateIsNullClauseForBindVars="false"/>
<ViewCriteriaItem
Name="EmployeesViewCriteria_vcrow103_DepartmentId_EmployeesViewCriteria_vcrow103_DepartmentId_itemHolder_vcrow105_DepartmentId"
ViewAttribute="DepartmentId"
Operator="="
Conjunction="AND"
Required="SelectivelyRequired"
GenerateIsNullClauseForBindVars="false"/>
<ViewCriteriaItem
Name="FirstName"
ViewAttribute="FirstName"
Operator="CONTAINS"
Conjunction="AND"
Required="SelectivelyRequired"
GenerateIsNullClauseForBindVars="false"/>
<ViewCriteriaItem
Name="LastName"
ViewAttribute="LastName"
Operator="CONTAINS"
Conjunction="AND"
Required="SelectivelyRequired"
GenerateIsNullClauseForBindVars="false"/>
</ViewCriteriaRow>
</ViewCriteria>

How Can I Change Format Mask For All Fields that type's Number Depend on Parameter in Report Builder 10g ?

I want Change format mask for all fields that type's number Such as if  :parameter_value = 1 then    all fields format mask = ' 999,999,990.000' ; else    all fields format mask = ' 999,999,990.00' ; end if; RegardsSo, i have bad news for you : you'l

Number fields filter in ADF

Hi, I am using JDeveloper 11.1.1.4 and ADF-BC in my project. I have an query on how adf filter works for wild card characters '*' and '_' number fields and string fields.[Typically 'Number' and 'Varchar2' fields in DB]. For Number fields, for example

Field / Column for Minus/Plus sign in Query

Hello In Query Designer I would like to create a column that shows the sign '+' or '-' when a key figure KF1 is below 0 or above. How do I do this? It has to be a separate column. I already created a calculated key figure KF2 that has as formula ABS

Number format issue in XML Publisher from OAF (',.' is replaced by 'u n')

Hi All, I am facing a problem in XML Publisher report. In report I need to display some number fields with 'USD' format. In RTF, data type 'Number' and format '###,##0.00' is selected. If I run concurrent program from oracle core forms using System A

Issue for Production Query

Hi, I'm having a situation when I print "Issue for Production" for an item, sometimes the batch issued printed out wrongly. I'm wondering is there a way to write a query to display issue for production (item code, item description, quantity, bat

Whole number field formatted as timezone in CRM 2013 SP1UR1 gives error on saving

Hi, I added a whole number field formatted  as time zone to the appointment form and when I save the record I get an error saying Crm Exception: Message: An unexpected error occurred., ErrorCode: -2147220970, InnerException: System.InvalidCastExcepti

Using number field for date

Hi, I have a number field that contain a date (YYYYMMDD). In my report I must show the date in the format DDMMYYY. Please, help me. TIA, Alex nullHi, You can also change your query... Instead of the column you are using, use to_char( to_date( ltrim(

How to show returned components on Issue for Production on a query.

Hi Guru's,      Is there a way to show the items that have been returned (Return Components) on Issue for Production using a query? Thanks and Regards, ChristianHi, 1. Create row level UDF for issue from production order. 2. Assign below FMS to this

R/3 Field name for "Number of Pipes" and "Length of Pipe" for SD Billing

Dear Gurus, I require the R3 tables and fields for "Number of pipes" and "length". These Fields are used in Billing Document Data: Items (As of 2.0B) (ZS2LIS_13_VDITM) for BI report. Your Help is greatly appritiated.hi, Now sure abour

In CO11N, no auto goods receipt & issues for materials having serial number

Hi, I had activated for auto GR and backflushing for materials to happen auto GR and issue during confirmation - CO11N, FG material w/o serial number are auto receipted and SFG materials w/o serial number are auto issued during confirmation. But auto

Exporting to CSV, a number field is changing format

Post Author: MELANIE ELIASON CA Forum: Exporting Exporting to CSV, a number field is changing formats.  I have it excluding the decimals places and commas. Can anyone help?  I am using version 10. MelPost Author: V361 CA Forum: Exporting If you are e

How to add a receipt number in the following Query for PO Report

Hi Guys, I need a help regarding following query. Its a PO report for 11.5.10.2 select distinct pv.segment1 supplier_number, pv.vendor_name supplier_name, pha.segment1 po_number, pha.revision_num revision_num, pha.authorization_status po_status, to_c

I have number range issue for fi posting.

hi gurus, i have number range issue for fi posting (fb01,fb50). problem in updating table glpca due to duplication of record. INSERT GLPCA FROM TABLE T_GLPCA . With Regards, Shakthi Raj N.error msg  after generating document no and it is not getting

Template inclusion/Javascript issue for doc header's custom fields

Hi all gurus, premise: I'm absolutely a newbie about templates and Jscript. I'm facing a strange behaviour for a field and I'd like to get your help on it, I'm running out of ideas. I modified a custom field, a checkbox, which automatically makes a s

Query about Leaving date,Reason for leaving fields in R3 report of HR Modul

Hi Experts,           I have a report in R3 for HR. In the report i am getting fields like leaving date,reason for leaving . When I  clicked F1 on the leaving date and reason  i came to know the field name as FIREDATE and MGTXT... I checked in DD03L

SSRS how to get for number of months

Hi All; below is my SSRS expression  =Cdate(Format(Cdate(Mid(Fields!createdon.Value,4,2) & "/" & Mid(Fields!createdon.Value,1,2) & "/" & Mid(Fields!createdon.Value,7,4)),"MMMM yyyy")) which gives me the month

2 Formatting issues with HTML forms

I have a couple of issues that we can't seem to get past with adobe livecycle designer 7.0. We have an internal form, rendered in HTML, that is emailed between departments, and the data entered is stored in an XML file that is created using the code

Multiple queries and formatting issues

I am running a report with 2 queries in a csv format. It displayed the right format with one query but with the new query , I have all sorts of formatting issues. The data is displayed in random cells. Why would this happen? Any ideas? thanksSripathy

Using a field to subtract or add to a number field in the database

Hi everyone I use Jdeveloper 1.5 with ADF and have the following functionality I have 3 fields Account withdrawing from: Account depositing to: Sum: In the database I have 2 tables clients and accounts. Client table has client name, adress phone, acc