I’ve been using Oracle Fusion Cloud ERP for a while now, and I must say, it’s impressive how it modernizes business processes and enhances efficiency. The advanced reporting and AI capabilities cater to all business functions, providing insights and automation that significantly improve decision-making and streamline operations. Overall, Oracle Fusion Cloud ERP has been instrumental in optimizing business processes and driving growth. Oracle Fusion Cloud brings together enterprise resource planning (ERP), enterprise performance management (EPM), supply chain management (SCM), human capital man ..read more

5 Lessons to Learn from Makar Sankranti Makar Sankranti (Uttarayan or Pongal or Poush Sankranti as it is called in other parts of India) coincides with the day the Sun leaves the tropic of Cancer to move towards the tropic of Capricorn (called Makar in India).   The warmth in the air is apt to sow new seeds of crops and legumes after a wintry season. #1 No celebration without sharing! Makar Sankranti represents the commencement of the harvest season in India. When there is harvest, the first crop you get, you share with everyone! Celebration cannot happen without sharing. #2 Speak sweet t ..read more

The Art of Appraisal Big Boss: This year your performance was good, excellent and outstanding. So, your rating is “average”. KK: What? How come ‘average’? Big Boss: Because…err…uhh…you lack domain knowledge. KK: But last year you said I am a domain expert and you put me in this project as a domain consultant. Big Boss: Oh is it? Well, in that case, I think your domain knowledge has eroded this year. KK: What??? Big Boss: Yes, I didn’t see you sharing knowledge on Purchasing domain. KK: Why would I? Because I am not in Purchasing, I am in Manufacturing. Big Boss: This is what I don’t like about ..read more

Oracle Reports (Report 6i) – Technical – Interview – Question Answers Question: How many types of columns are there and what are they Formula columns: For doing mathematical calculations and returning one value Summary Columns: For doing summary calculations such as summations etc. Place holder Columns: These columns are useful for storing the value in a variable Question: Can u have more than one layout in report Answer: It is possible to have more than one layout in a report by using the additional layout option in the layout editor. Answer: Yes it is possible to run the report without param ..read more

Introduction The Property Management Module is designed as a property database for organisations with large property  management portfolios. This paper is to provide an overview of the module describing its features and functionality. Using this structured database users can manage space allocations within their portfolio for both employees and/or customers. Customers’ space can be charged via an interface to the Accounts Receivable package or invoices for rent can be generated and interfaced to the Accounts Payable Module. The database will hold various types of data including, features ..read more

[slideshare id=3539377&doc=differencebetweentechnicalandtechnofunctional-100324104623-phpapp01] Difference Between Technical and Functional and Techno Functional ..read more

To find forms session in Oracle database set linesize 1000 column username format a8 heading “User|Name” column sid format 9999 column serial# format 99999 column user_form_name format a25 column spid format a5 column unix_process format a7 heading “UNIX|Process” column user_name format a15 trunc heading “USER NAME” column Responsibility_name format a20 heading “Responsibility |Name” select s.sid, s.serial#, s.audsid, s.username, s.process unix_process, p.spid, u.user_name, f.user_form_name, to_char(a.start_time ,’DD-MON-YY’) start_time, f.responsibility_name from v$process p, v$session s, fnd ..read more

What is an Enterprise Data Warehouse? An Enterprise Data Warehouse (EDW) is a form of corporate repository that stores and manages all the historical business data of an enterprise. The information usually comes from different systems like ERPs, CRMs, physical recordings, and other flat files. To prepare data for further analysis, it must be placed in a single storage facility. This way, different business units can query it and analyze information from multiple angles. Enterprise Data Warehouse Architecture While there are many architectural approaches that extend warehouse capabili ..read more

Analytics is playing a major role in helping businesses stay competitive and relevant. Financial analytics helps organizations analyze historical data to predict future performance and improve decision making. Modern, cloud-based financial analytics tools enhance reporting capabilities and data visualization, helping businesses gain better insights from their data anytime, anywhere, on any device. What’s the Significance of Financial Analytics? Financial analytics typically involves ad hoc analysis to help find the answers to complex business questions. Financial analytics software can analyze ..read more

10 Key Features / Functions of Oracle Cloud ERP  ERP systems was designed for on-premises installation with a database management system as a backend. Those installations are increasingly replaced with the cloud by most ERP vendors. Maintaining and keeping them to the current standards might expensive and time-consuming for these older version-ERP systems. Oracle has emphasized migration to the ERP cloud and has outlined many guiding policies on the deployment process. What is Oracle ERP Cloud? Oracle ERP Cloud is a Software-as-a-Service recognized for its capability to scale with yo ..read more