Oracle Apps Info

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…

Read More Read More

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…

Read More Read More

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 ->…

Read More Read More

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…

Read More Read More

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…

Read More Read More