Timecard Layout Modification – Remove Columns

Timecard Layout Modification – Remove Columns

Let’s talk about how to remove the columns from the timecard projects layout. In the previous posts, we have seen how to add a custom new columns in the timecard project layout.
Now we remove those columns from the timecard layout.

We can even take out the columns which are available in Oracle seeded template Projects Timecard Template but sometimes we may run into some problems.

Here we take out the two custom columns that we create in earlier stages/posts.
Column1: Project Details LOV
Column2: Project Details Choice List

Download the template from Oracle server using below command.

FNDLOAD apps/apps 0 Y DOWNLOAD $HXC_TOP/patch/115/import/hxclaytlayoutsld.lct xxcus_hxclaytlayoutsld.ldt HXC_LAYOUTS LAYOUT_NAME='XXCUS-PROJECTS-TIMECARD'

Here we changed the layout name(XXCUS-PROJECTS-TIMECARD) in order to use our custom columns.
We have to comment on the columns that we created earlier like below.
Project Details LOV

############################################################################ 
# Project Details on the timecard matrix  - Start
############################################################################ 
#BEGIN HXC_LAYOUT_COMPONENTS "Projects Timecard Layout - Project Details"
#OWNER = "ORACLE"
#COMPONENT_VALUE = "DETAILS"
#SEQUENCE = "275" 
#COMPONENT_DEFINITION = "LOV"
#RENDER_TYPE = "WEB" 
#PARENT_COMPONENT = "Projects Timecard Layout - Day Scope Building blocks for worker timecard matrix"
#REGION_CODE = "HXC_CUI_TIMECARD"
#REGION_CODE_APP_SHORT_NAME = "HXC"
#ATTRIBUTE_CODE = "HXC_XXCUS_PJDET_LOV"
#ATTRIBUTE_CODE_APP_SHORT_NAME = "HXC"
#BEGIN HXC_LAYOUT_COMP_QUALIFIERS "Projects Timecard Layout - Project 
#Details"
#OWNER = "ORACLE"
#QUALIFIER_ATTRIBUTE_CATEGORY = "LOV"
#      QUALIFIER_ATTRIBUTE1 = "CustomLov1VO"
#      QUALIFIER_ATTRIBUTE2 = "N"
#      QUALIFIER_ATTRIBUTE3 = "XXCUS_PROJ_LOV"
#      QUALIFIER_ATTRIBUTE4 = "809"
#      QUALIFIER_ATTRIBUTE5 = "12"
#      QUALIFIER_ATTRIBUTE6 =
# "XXCUSProjType|DETAILS-DISPLAY|CRITERIA|N|XXCUSProjClassCode|DETAILS|RESULT|N|XXCUSProjType|DETAILS-DISPLAY|RESULT|N"
#      QUALIFIER_ATTRIBUTE8 = "XXCUSProjType"
#      QUALIFIER_ATTRIBUTE9 = "XXCUSProjClassCode"
#      QUALIFIER_ATTRIBUTE10 =
# "oracle.apps.hxc.selfservice.timecard.server.CustomLov1VO"
#      QUALIFIER_ATTRIBUTE17 = "OraTableCellText"
#      QUALIFIER_ATTRIBUTE20 = "N"
#      QUALIFIER_ATTRIBUTE21 = "Y"
#      QUALIFIER_ATTRIBUTE22 = "L"
#      QUALIFIER_ATTRIBUTE25 = "FLEX"
#      QUALIFIER_ATTRIBUTE26 = "XXCUS_PROJ_TYPE"
#      QUALIFIER_ATTRIBUTE27 = "Attribute1"
#      QUALIFIER_ATTRIBUTE28 = "DETAILS"
#END HXC_LAYOUT_COMP_QUALIFIERS 
#END HXC_LAYOUT_COMPONENTS  
############################################################################ 
# Project Details on the timecard matrix  - End
############################################################################

Project Details Choice List

############################################################################ 
# Project Details Choice List on the timecard matrix  - Start
############################################################################ 
#BEGIN HXC_LAYOUT_COMPONENTS "Projects Timecard Layout - Project Details Chioce List"
#OWNER = "ORACLE"
#COMPONENT_VALUE = "DETAILS_CHOICE"
#SEQUENCE = "276" 
#COMPONENT_DEFINITION = "CHOICE_LIST"
#RENDER_TYPE = "WEB" 
#PARENT_COMPONENT = "Projects Timecard Layout - Day Scope Building blocks for worker timecard matrix"
#REGION_CODE = "HXC_CUI_TIMECARD"
#REGION_CODE_APP_SHORT_NAME = "HXC"
#ATTRIBUTE_CODE = "XXCUS_LIST_PROJ_TYPE"
#ATTRIBUTE_CODE_APP_SHORT_NAME = "HXC"
#BEGIN HXC_LAYOUT_COMP_QUALIFIERS "Projects Timecard Layout - Project 
#Details"
#OWNER = "ORACLE"
#QUALIFIER_ATTRIBUTE_CATEGORY = "CHOICE_LIST"
#      QUALIFIER_ATTRIBUTE1 = "Custom1VO"
#	  QUALIFIER_ATTRIBUTE4 = "N"
#	  QUALIFIER_ATTRIBUTE8 = "DisplayValue"
#	  QUALIFIER_ATTRIBUTE9 = "Value"
#      QUALIFIER_ATTRIBUTE10 =
#		"oracle.apps.hxc.selfservice.timecard.server.Custom1VO"
#      QUALIFIER_ATTRIBUTE17 = "OraTableCellText"
#      QUALIFIER_ATTRIBUTE20 = "N"
#      QUALIFIER_ATTRIBUTE21 = "Y"
#      QUALIFIER_ATTRIBUTE22 = "L"
#      QUALIFIER_ATTRIBUTE25 = "FLEX"
#      QUALIFIER_ATTRIBUTE26 = "XXCUS_PROJ_TYPE_LIST"
#      QUALIFIER_ATTRIBUTE27 = "Attribute1"
#END HXC_LAYOUT_COMP_QUALIFIERS 
#END HXC_LAYOUT_COMPONENTS  
############################################################################ 
# Project Details Choice List on the timecard matrix  - End
############################################################################

Upload the modified the template Oracle server and execute the below upload command to reflect the changes in Timecard Layout/Page.

FNDLOAD apps/apps 0 Y UPLOAD $HXC_TOP/patch/115/import/hxclaytlayoutsld.lct xxcus_hxclaytlayoutsld.ldt

If we want to use those columns in the near future then we can comment code like and leave. So custom views(HXC_CUI_CUSTOM_LOV1_V, HXC_CUI_CUSTOM1_V) that we used for columns cannot be used.

  • We want to use those views and delete permanently those custom columns then we can comment/delete the columns from the code.
  • Delete region items from AK Region(HXC_CUI_TIMECARD) and delete the attributes from AK Attributes(XXCUSProjType, XXCUSProjClassCode).
  • Remove the DFF context entries(XXCUS_PROJ_TYPE_LIST, XXCUS_PROJ_TYPE) from the system.
  • Recompile the views(HXC_CUI_CUSTOM_LOV1_V, HXC_CUI_CUSTOM1_V) same as PROD.
  • Upload the modified .ldt file to the server and run the UPLOAD FNDLOAD command to reflect the changes on the Timecard page.
Comments are closed.