Introduction There are many ways to manage a project, two of the most prominent ways are waterfall and agile. The outline below describes these two project management methods. Waterfall What is Waterfall? The waterfall methodology is a design process, frequently used in software development, which progresses sequentially through the phases of Planning, Analysis, Design, Implementation, and Maintenance. (Diagram 1) Advantages of Waterfall Time and budget estimates are more reliable Development processes tend to be more secure Disadvantages of Waterfall Rigid and inflexible processes Feedback and testing are deferred until very late into the project Response to unanticipated problems require … Read More
Managing Negative Leave Balances in Oracle EBS R12.1.3 HCM
The Challenge Managers of Oracle E-Business Suite HCM applications may wish to implement a business rule that prohibits employees from taking leave that exceeds their balance (ie result in a negative leave balance). Until now, E-Business Suite has not provided an easy way to implement that business rule, rather, users needed to write custom code for the ‘BG_ABSENCE_DURATION’ fast formula. For many users these seemed overly complicated. The Solution Beginning with E-Business Suite R12.1.3, following the simple steps below, Oracle has provided a profile option that can be set to prevent employees from taking leave that exceeds their balance. Authenticate … Read More
Responsibility Assignment Matrix
What is a Responsibility Assignment Matrix (RAM) or a RACI MatriX? A responsibility assignment matrix (RAM), also known as RACI matrix, describes the participation by various roles in completing tasks or deliverables for a project or business process. How is RAM / RACI useful? RAM / RACI is especially useful in clarifying the roles and responsibilities in cross-functional/departmental projects and processes. What does RACI stand for? RACI is derived from the four key responsibilities: Responsible, Accountable, Consulted, Informed. The RACI model is a straightforward tool used for identifying roles and responsibilities and avoiding confusion over the roles and responsibilities during … Read More
Oracle EBS Query-by-Example – Query like a Pro
Knowing all of the options when querying in forms will help take users beyond average and toward ‘power user’ status. Master the use of query wildcards, and query operators as described below. Query Basics Query-by-Example is a simple three step process: While in a form, switch to query mode by selecting <F11> from the keyboard enter the criteria for the query execute the query by selecting <ctrl><F11> simultaneously from the keyboard While performing step 2 (enter the criteria), with either wildcards or operators as shown in the tables below. Query Wildcards Query Operators In the examples below, the query … Read More
E-Business Suite R12.1.3 HCM changes to VETS-100 Reporting
The Challenge VETS-100 reports present data for a 12 month period. Prior to R12.1.3, the E-Business Suite HCM processes used to create those reports, included parameters labelled ‘Report From Date’ and ‘Report To Date’. This allowed users to select a duration of less than 12 months. The Solution To ensure that the report covers the appropriate time span, beginning with R12.1.3, Oracle E-Business HCM functionality replaces the date fields (Report From Date and Report To Date) with the date on which the 12 months conclude: 12 Month Period End Date. The field change affects the following reports: VETS-100 Suite Of … Read More