In this article, we will see how to add a Project Name column and comments in a column in the Project Timecard Layout. If we observe the Oracle standard layout for Projects we don’t see any project name column in the Layout. So as part of this exercise, we will try to add the Project Name column. As soon as we select the project number in the timecard page it should automatically pull the Project Name information based on the…
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….
This is one key setup for Oracle Time and Labor Timecard entry. These preferences are how do you enter and submit the Timecard page. By using these preferences we can set up the approval rules, retrieval rules, timecard entry rules, layouts and much more. Preferences Navigation: OTL Super Administrator -> Preferences Right click on Preference Tree and click on New then Save – Name in Tree(XXCUS OTL) Preference: Self Service Create Template Functionality This preference will allow users to create…
Timecard entry layout modification to add new CHOICE LIST column to Projects Timecard Layout. We can add our own custom choice lists in Oracle Time and Labor. Oracle support up to ten custom choice lists columns. We have to access these values using an Oracle predefined views, which must have two columns in a choice list view. The views are named as HXC_CUI_CUSTOMn_V where n is a number between 1 and 10. For example, HXC_CUI_CUSTOM1_V. These views must have at…
Timecard entry layout modification, how to add a new column to an existing standard Projects Template. Sometimes we do get a business requirement to add a new column or remove an existing column. Here we look at how to add a new LOV column to Projects Timecard Entry page. Oracle Provided Projects Timecard: Process1 – Custom LOV & Standard Region Step1: Identify the layout to modify and download the file from Oracle DB Navigation: OTL Super Administrator -> Preferences ->…
This article talks about how to use Timecard API’s. By using these API’s we can create the data into Oracle timecard tables, update timecard information, delete timecard information and retrieval of timecard information by using API’s. Create Timecard Update Timecard Delete Timecard Retrieve Timecard Information Create Timecard We can create timecard in 2 ways before we begin creating timecard, timecard information will be stored in a table as blocks. We have 3 blocks in timecard table(hxc_time_buidling_blocks) Scope = Timecard(this is…
In this article, we will talk about how to create Oracle timecard(OTL) entry rules and impose on timecard entry. To validate a timecard when it is saved or submitted and display a business message, error or warning Let’s assume the user enters more than 24 hours per day while timecard creation then we have to raise an error and stop user being save/submit the timecard. This we can achieve by using Oracle seeded formula and by creating custom rules. Oracle…