Timecard Layout Modification

-

Requirement of Timecard Layout Modification:

Let's assume that following SFDC /Partner Name field needs to be modified to increase the length of the field  in Timecard Layout:
Timecard Layout Modification
I am going to tell you how we can increase the length of the field in Oracle Timecard layout. But the field cannot modified using Personalization from the standard Oracle Applications Framework (OAF) functionality. All the changes to the layout must be made via the Oracle Time and Labor page layout definition. We need to modify the Timecard Layout configuration file for this requirement.

Solution to Timecard Layout Modification:

In order to increase the length of the field in the Timecard Layout, we need to get the layout name and ldt file for the Timecard layout. To get the current layout name follow the below steps:

Global OTL Administrator --> Preference
Press Timecard Layout --> Preference Values, following window will open:
Timecard Layout

Timecard Layout: Projects Timecard Layout - With Project & Task details Concatenated Canon

Get Timecard Layout Code:

SELECT layout_name
  FROM hxc_layouts_vl
 WHERE display_layout_name = 'Projects Timecard Layout - With Project & Task details Concatenated';

Layout_name

---------------------------------------------------------

PROJECTS-DET-TIME-XX

Download Ldt file:
FNDLOAD apps/apps_support01 0 Y DOWNLOAD $HXC_TOP/patch/115/import/hxclaytlayoutsld.lct xxtimecardlayout_new.ldt HXC_LAYOUTS LAYOUT_NAME='PROJECTS-DET-TIME-XX'

Changes the ldt for field width:
BEGIN HXC_LAYOUT_COMP_QUALIFIERS "Projects Details Timecard Layout - SFDC"
      OWNER = "ORACLE12.1.3"
      QUALIFIER_ATTRIBUTE_CATEGORY = "TEXT_FIELD"
      QUALIFIER_ATTRIBUTE1 = "N"
      QUALIFIER_ATTRIBUTE2 = "N"
      QUALIFIER_ATTRIBUTE3 = "25"
      QUALIFIER_ATTRIBUTE4 = "1"
      QUALIFIER_ATTRIBUTE5 = "50"
      QUALIFIER_ATTRIBUTE7 = "OraTableCellText"
      QUALIFIER_ATTRIBUTE17 = "NONE"
      QUALIFIER_ATTRIBUTE20 = "N"
      QUALIFIER_ATTRIBUTE21 = "Y"
      QUALIFIER_ATTRIBUTE22 = "L"
      QUALIFIER_ATTRIBUTE25 = "FLEX"
      QUALIFIER_ATTRIBUTE26 = "Dummy Element Context"
      QUALIFIER_ATTRIBUTE27 = "Attribute15"
      QUALIFIER_ATTRIBUTE28 = "SFDC"
      QUALIFIER_ATTRIBUTE30 = "N"
      LAST_UPDATE_DATE = "2011/10/11"
    END HXC_LAYOUT_COMP_QUALIFIERS

Update the above highlighted field  of Timecard Layout as below:
      QUALIFIER_ATTRIBUTE3 = "50"
      QUALIFIER_ATTRIBUTE5 = "75"

Uploading Timecard Layout:

To upload the new layouts (for each of the layouts in the set you are using, or have customized) to the database execute the following command from the command line:
FNDLOAD apps/apps_support01 0 Y UPLOAD $HXC_TOP/patch/115/import/hxclaytlayoutsld.lct xxtimecardlayout_new.ldt

Comments

Post a Comment

Popular posts from this blog

XML Publisher Request Fails Due to Output Post Processing Issue

-
OPP Log file: To obtain the OPP log file, follow the bellow steps: §   Select the System Administrator responsibility. §   Navigate to Concurrent à Manager à Administer. §   Select the Output Post Processor Service. §   Select the Processes button. §   Select Manager Log. Issues: BI Publisher concurrent request completed with warning due to a timeout caused by the Output Post Processor (OPP).  Given bellow the possible common errors may occur due to OPP issue: Issue 1. OPP No Response : +------------- 1) PUBLISH -------------+ The Output Post-processor is running but has not picked up this request. No further attempts will be made to post-process this request, and the request will be marked with Warning status. Setting the profile option C...
Read more

Oracle Database Connection to TOAD

-
Issues of Oracle Database Connection to TOAD Connections to Oracle database via TNS are bit of a painful until you get all the components in the TNS configured correctly. We generally get different types of errors when we try to connect the DB using TOAD.  Usually we get Host, Port & Service Name in the TNS Entry but SID is excluded from it. But if we supply the SID information instead of service name it gets connected easily. If we get the SID for the database we can easily connect to the DB using TOAD. Solution of Oracle Database Connection by TOAD: We can connect to any database instance using TOAD by the following steps: 1.        Connect to the database using SQL*Plus as below Ø   User Name:  ORACLE_USER Ø   Password: ORACLE_password1 Ø   Host String: 156.14.200.90:1542/VISSVC(host:port/Service Name) Ø   Or conn  ORACLE_USER / ORACLE_password1@156.14.200.90:1542/ORAVISSVC (Conn user/password@...
Read more

Row splitting on BI Publisher report with excel output

-
Issue: ------ The BI Publisher Report with excel output is splitting lines into separate rows for the same record. Findings: --------- As per my analysis, carriage returns on the field is one of the reason for row splitting on BI Publisher Report. Oracle BI Publisher report output generator cannot identify those non-human readable carriage returns. I continued my analysis and found out there are similar issue with some others fields also and Swiss characters are not creating this issue.  I tried to create a prototype to replace those non-human readable carriage returns symbol with spaces. Finally the prototype has been successfully created for both the fields in test instance. Hopefully this solution has been successfully fixed the row splitting issue. Solution: Edit the data definition XML file and for each field with carriage return char with space replace with following: TRANSLATE(TRANSLATE(htv.TCRD_COMMENT_TEXT, CHR(10),' '), CHR(13),' ')
Read more