Enabling security on value sets helps us to restrict values on concurrent program parameters. Business Scenario: Let’s say that we would like define Apple products with their codes in a independent value set which will be attached to a concurrent program as a parameter. 100: iPod Product Family (Note: This is not a product […]
The following are the setups relating to Core HR. Creating Location: We can create locations using the Work Structures => Location window. Create Business Group We can use either the start up BG or we can create a new BG. The start up BG has a default legislation code of US and has a default […]
Retainage Release Invoices in Oracle AP: Retainage means retaining certain amount of money with us without paying the supplier in full. The retained amount is released or paid to the supplier when all the terms of the agreement have been met or all the work is completed. Pre-requisites: 1. Retainage Account setup: Navigation: Payables Responsibility […]
SQL Validation used for profile options List of Values: Before proceeding further, we recommend you to go through our article on Profile Option in Oracle Apps where we have covered how to create a profile option and assign a value (user enters free text as value) to it. Many a times, you need to a […]
Steps for handling multiple layouts in XML. After developing the Report definition file (.rdf) we have to add one more parameter like follows. This parameter value should be assigned to Place holder column(CP ) like follows We can assign Parameter value either after parameter form or before report Triggers. In this we assigned in Before […]
Oracle apps sub functions Overview: There are two types of functions: form functions, and non-form functions. For clarity, we refer to a form function as a form, and a non-form function as a sub function, even though both are just instances of functions in the database. Oracle Applications aggregates several related business functions into a single […]
Folders in Oracle Forms: Folders let you do the below: 1.Control how you want the data to be displayed in the form meaning what columns should be displayed, what should be width of the columns, sequence of the columns, what should be the prompt for each of these columns etc. 2. Control what data should […]
This script below will get the list of all inactive users and end date all the responsibilities assigned to them.
This script can be used to adjust the Revenue for a particular transaction. The amount can be adjusted from one transaction line to another line by specifying the actual amount to adjust or percentage. Run this procedure in loop to adjust many transactions.