Current Position:Home > OTL Timecard Restrict Expendituretype LOV

OTL Timecard Restrict Expendituretype LOV

Update:11-30Source: network consolidation
Advertisement
Hi,
I'm really stuck with following issue.
My client has the requirement to restrict the Expendituretype LOV based on selected project.
I know this is possible and read all documentation about it but I can't get it working.
It should be possible because the TaskLOV is also restricted based on selected project.
Can anyone please help ? Search on
This is what I did:
1. I extended ExpTypeElementLOVVO in such a way that project_id is included in the query.
2. I created a custom layout file as follows. Relevant part is below.
I made changes to ATTRIBUTE6,14 and 15. As I don't entirely grasp the syntax of these attributes I probably made some mistakes there. By the way, I did bounce Apache and OC4J.
BEGIN HXC_LAYOUT_COMPONENTS "Projects Alternate Timecard Layout - Expenditure Type"
OWNER = "ORACLE"
COMPONENT_VALUE = "EXPENDITURETYPE"
REGION_CODE = "HXC_CUI_TIMECARD"
REGION_CODE_APP_SHORT_NAME = "HXC"
ATTRIBUTE_CODE = "HXC_TIMECARD_EXPTYPE"
ATTRIBUTE_CODE_APP_SHORT_NAME = "HXC"
NAME_VALUE_STRING = "EXPENDITURE_ELEMENTS"
SEQUENCE = "220"
COMPONENT_DEFINITION = "LOV"
RENDER_TYPE = "WEB"
PARENT_COMPONENT = "Projects Alternate Timecard Layout - Day Scope Building blocks for worker timecard matrix"
LAST_UPDATE_DATE = "2004/05/24"
BEGIN HXC_LAYOUT_COMP_QUALIFIERS "Projects Alternate Timecard Layout - Expenditure Type"
OWNER = "ORACLE"
QUALIFIER_ATTRIBUTE_CATEGORY = "LOV"
QUALIFIER_ATTRIBUTE1 = "ExpTypeElementLOVVO"
QUALIFIER_ATTRIBUTE2 = "N"
QUALIFIER_ATTRIBUTE3 = "HXC_CUI_LOV_EXPTYPE_ELEMENT"
QUALIFIER_ATTRIBUTE4 = "809"
QUALIFIER_ATTRIBUTE5 = "5"
QUALIFIER_ATTRIBUTE6 = "HxcCuiAliasValue|ALIAS-DISPLAY|CRITERIA|N|HxcCuiExpProjectId|PROJECT|PASSIVE_CRITERIA|Y|HxcCuiAliasId|DUMMY|PASSIVE_CRITERIA|N|HxcCuiAliasId|ALIAS|RESULT|N|HxcCuiAliasValue|ALIAS-DISPLAY|RESULT|N"
QUALIFIER_ATTRIBUTE8 = "AliasValueName"
QUALIFIER_ATTRIBUTE9 = "AliasValueId#NUMBER"
QUALIFIER_ATTRIBUTE10 = "oracle.apps.hxc.selfservice.timecard.server.ExpTypeElementLOVVO"
QUALIFIER_ATTRIBUTE14 = "HxcCuiExpProjectId|PROJECT|Y"
QUALIFIER_ATTRIBUTE15 = "project_id = ::HxcCuiExpProjectId"
QUALIFIER_ATTRIBUTE17 = "OraTableCellText"
QUALIFIER_ATTRIBUTE20 = "N"
QUALIFIER_ATTRIBUTE21 = "Y"
QUALIFIER_ATTRIBUTE22 = "L"
QUALIFIER_ATTRIBUTE24 = "ELEMENTS_EXPENDITURE_SLF"
QUALIFIER_ATTRIBUTE25 = "FLEX"
QUALIFIER_ATTRIBUTE26 = "OTL_ALIAS_1"
QUALIFIER_ATTRIBUTE27 = "Attribute1"
QUALIFIER_ATTRIBUTE28 = "ALIAS"
LAST_UPDATE_DATE = "2004/05/24"
END HXC_LAYOUT_COMP_QUALIFIERS
END HXC_LAYOUT_COMPONENTS
Please help me out.
Jan
Edited by: Jan Blok on Apr 29, 2011 1:56 PM
Edited by: Jan Blok on Apr 29, 2011 1:58 PM

The Best Answer

Advertisement
I would say its the correct functionality. Even though, all the premium elements are getting displayed, they won't pass the validation on either on time entry or during transfer process. What's the otl patching level?
If you are still concerned, raise an SR.
--Shiv                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
  • OTL Timecard Restrict Expendituretype LOV Update:11-30

    Hi, I'm really stuck with following issue. My client has the requirement to restrict the Expendituretype LOV based on selected project. I know this is possible and read all documentation about it but I can't get it working. It should be possible beca

  • Where clause for TaskLOVVO on OTL Timecard Update:11-30

    Hi, Following is the customization on our OTL timecard layout(Projects and Payroll Layout): ->Extended TaskLOVVO and based on a value selected in TaskLOV, i am defaulting Hours type. The dynamic where clause for the TaskLOVO is taken care of by the b

  • OTL Timecard LOV Sort Order Update:10-11

    Hello, We have an LOV field on our OTL timecard called Rate Up. It is a custom timecard created by someone who is long gone. We would like it sorted in a particular order. We identified a database view that is likely the source of the data, but addin

  • Creating fields as LOV (using alternate names) on OTL timecards Update:11-30

    Hi, I would really appreciate if someone can help me understand the process of being able to add fields on OTL timecard as LOV fields using alternate names. These are COST segments which I need to add on OTL timecard. The part which is most confusing

  • OTL Timecard Customization !!! Update:11-30

    Hi All, I'm trying Customization to OTL Timecard i.e add two extra columns Project Name and Task Name. I got this ldt file (hxczzhxclayt0019.ldt) to customize. I did my changes to add these fields. I was successful in seeing these columns. But the pr

  • Package Choicelist OTL timecard Update:11-30

    Has anyone implemented package choicelist in OTL timecard?...I wanted to ask you if you encountered a problem wherein you dont see any values in the list when you open a timecard after implementing package choiclist: Here is what my layout file looks

  • OTL Timecard Update:11-30

    Hi, I need to add a display only field on the OTL Timecard. It should show the 'display_value' column from Custom2VO. The values I see in the ldt file for referencing Custom2VO are choice_list and lov - are there other options? Thanks!Add following l

  • OTL Timecard Rejection/Resubmission Update:11-30

    Hi All, I am working on OTL Timecard Approval Workflow. I have a requirement as mentioned. Please let me know if it is feasible or not. Approval Style used is Project Manager. Hence when timecard is submitted, it is split into the number of projects

  • Accrual Balance in  OTL Timecard oaf page Update:11-30

    Hi Guy's Can any one help me find out from where or which table the accrual balance's of an employee are populating in OTL timecard . Thanks in advanceHi, The accrual balances for each employee or not stores anywhere unless you are using payroll bala

  • OTL TIMECARD Interface table - API (urgent) Update:11-30

    hi everybody... i want to know if there is an interface tables or API used for OTL Timecard for the integration purpose . API is acceptable but interface table is perefable . thanks alot .. best regards,Duplicate post. OTL TIMECARD Interface table -