Archive for the ‘Uncategorized’ Category

Project Accounting – Validation of the Project Starting Organisation per OU

Friday, March 4th, 2016

Used to quickly validate the setup and configuration of a implementation.

Select o.name "Operating Unit", o1.name "Project Start Org" 
from PA_IMPLEMENTATIONS_ALL pi, hr_all_organization_units o, hr_all_organization_units o1
where pi.org_id = o.organization_id
and proj_start_org_id = o1.organization_id
and o.name <> o1.name;

Oracle WebADI (R12) Examine Configuration of WebADI Layouts and Codes

Friday, March 4th, 2016

This SQL statement was used to support the creation of custom menu items for custom WebADI layouts.

SELECT biv.integrator_code,
  biv.user_name,
  fa.application_id,
  fa.application_short_name
  ,biv.language
  , bl.layout_code
FROM bne_integrators_tl biv,
  fnd_application fa,
  fnd_application_tl fat,
  BNE_LAYOUTS_B bl
WHERE biv.application_id = fa.application_id
AND fa.application_id    = fat.application_id
  /* The next few line can be commented or changed to suit*/
AND fa.application_short_name = 'PA'
and biv.integrator_code = 'PAXTTRXB'
and biv.integrator_code = bl.integrator_code
AND fat.language              = 'US'            
and biv.language = fat.language
ORDER BY fa.application_short_name,
  biv.user_name;

Oracle – EBS – Database Variables

Friday, March 4th, 2016

The purpose of the ALTER SESSION statement is “to specify or modify any of the conditions or parameters that affect your connection to the database. The statement stays in effect until you disconnect from the database.”
ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA' NLS_CURRENCY= '$' NLS_ISO_CURRENCY= 'AMERICA' NLS_NUMERIC_CHARACTERS= '.,' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'AMERICAN' NLS_SORT= 'BINARY';

Heard of BI?

Sunday, July 22nd, 2012

So you’ve heard the term BI, Business Intelligence. You think, expense, high cost, and poor return on investment. I hate to be the bearer of bad news, but you’re wrong. Business intelligence isn’t the preserve of the large overbearing corporate entities, the emergence of analytics software can support smaller SME, and that does include those non-technical companies.

According to Gartner, the worldwide market for BI platform, analytic applications and performance management software generated revenues of $12.2bn in 2011. That’s 16% up on 2010, making BI the second fastest growing sector in the overall worldwide enterprise software market. More vendors than you can shake a stick at are appearing in the market with tools that can enable your businesses BI.

This growth could be attributed to a number of sources. Cloud, mobile and social media are all enablers for companies, leveraging and analysing the outputs and availabilities of these sources are often more difficult. How many companies have we seen with there own Facebook & Linkedin page? Do you use Twitter?

Why are these factors helping BI implementation, its down to targeting users and markets. BI tools often enable you to do more than write reports on your finance system. They often aren’t vendor or application specific.

SME’s as small, often market specific channels are in excellent positions to quickly move and understand these market shifts, they can leverage “Cloud” and SaaS principles to expand functions quickly to accommodate new trends. But spotting and understanding the trends is often more luck than insight.

So you’re an SME (or even large organisation) just starting out on the BI path. Where do you go what are your first moves?

Firstly, understand your data estate and processes. I can’t stress this enough, systems and technology in business are your businesses lifeblood. Seriously how much of your business works without technology? How many of your processes depend on users, customers or stakeholders utilising your technology? Understanding where technology is used, what data it depends on and the mediums it users are essential.

Secondly, many of your current systems have some kind of reports as well as a presentation layer? Establish what your users do with the data? Are they extracting it to publish, doing lookups or validation to non-linked data sets?

Thirdly, and this might be difficult, decide what your business strategy is? Can’t, haven’t or don’t have one? Well, tell me what you want to improve, become faster leaner or more focused? Do you have lots of customers and marketing data, do you understand relationships

4th (Fourthly didn’t sound right), leverage and evaluate what you have, map and out your data, relationships and (potential) linkages. Relate information to external markets and indexes.

5th, understand your users and capabilities, there is no point buying a Global Corporate grade BI solution if you can’t use it. Remember, its child, it will grow, start small and targeted, grow your own skills and capabilities. Understand where contractors can be applied to initially setup the basics.

6th choose your platform, if you’ve evaluated your current applications and providers offerings which are normally the quickest to implement. Generally they also offer a close match to your budget too. If that doesn’t suit your going to have to examine the market and approach providers who understand the technologies you need. Normally, if your in the cheap seats, move people head for Crystal Reporting type products for there high scalability, and downright cheap price point for capabilities. You can often find developers of many flavours who can use it. Even many jumped up junior programmers can use it, as its built-in with many MS Visual Studio installs for the last few generations.

7th, the mash up. You’ve got your data, you’ve got some super tools. You know need to get a little creative. Experiment, relate data together, look for correlations and patterns. The greatest part of the BI toolset is the interpretation engine that you the user has. Your wetware is the key to unlocking the valuable information behind your reports.

In conclusion, buying a BI product isn’t the end, you will learn, you will want to explore more, you stop, your business stops learning. BI is like a educating a child, as it grows, it becomes more powerful, sometimes you will have to change schools for it to specialize in new areas, sometimes you have to get a tutor and sometimes you simply have to let it make mistakes. Each is a new experience.

High Level Design (HLD) Vs. Low Level Design (LLD)

Wednesday, May 23rd, 2012

For people who have been involved in software projects, they will constantly hear the terms, High Level Design (HLD) and Low Level Design (LLD). So what are the differences between these 2 design stages and when are they respectively used ?

High Level Design (HLD) gives the overall System Design in terms of Functional Architecture and Database design. It designs the over all architecture of the entire system from main module to all sub module. This is very useful for the developers to understand the flow of the system. In this phase design team, review team (testers) and customers plays a major role. For this the entry criteria are the requirement document that is SRS. And the exit criteria will be HLD, projects standards, the functional design documents, and the database design document. Further, High level deign gives the overview of the development of product. In other words how the program is going to be divided into functions, modules, subdivision etc.

Low Level Design (LLD) During the detailed phase, the view of the application developed during the high level design is broken down into modules and programs. Logic design is done for every program and then documented as program specifications. For every program, a unit test plan is created. The entry criteria for this will be the HLD document. And the exit criteria will the program specification and unit test plan (LLD).

The Low Level Design Document gives the design of the actual program code which is designed based on the High Level Design Document. It defines Internal logic of corresponding submodule designers are preparing and mapping individual LLD’s to Every module. A good Low Level Design Document developed will make the program very easy to be developed by developers because if proper analysis is made and the Low Level Design Document is prepared then the code can be developed by developers directly from Low Level Design Document with minimal effort of debugging and testing.

Business Requirement Documents

Friday, April 6th, 2012

Business Requirement Documents, areis primafaciely done by the Functional Persons of the Implementation Team like Funtional Project Leads / Managers. These documents are the Set up Documents, which is 100% based on the BR 120 – Business Requirement Gatherings as provided by the business.

You can say these are As Is process. So BR 100 is the To Be Process after you gather all sorts of info from the Biz and map in the Oracle Systems.

For Sale: Ex-MOD Bunker

Friday, December 30th, 2011

Praticalities aside, the idea of having my own bunker has fasinated me.

If Britain had been attacked by a nuclear bomb during the Cold War, its government would have survived by retreating to a massive, 35-acre complex buried beneath the county of Wiltshire. I call it a bunker in the headline, but it was more like a small town—large rooms linked by roads, built on the site of an abandoned quarry. Known as Burlington, it could house 4000 people and feed them all for 3 months. It was also home a broadcasting studio and hospital.

Considering the size and space, it may make for an interesting site, suggetions:

1) Film Studio: Problems: Access and movement of materials into the site

2) Massive Server Farm: Cooling and Elextricity – Big Plus – Very secure.

3) Umbrella Research base – Possibility of creating the T-Virus… a few of you might get where that was going.

Disabled Failing to Find Work

Wednesday, December 21st, 2011

This headline grabbed my attention! Yes. The disabled are failing to find work, along with 10% of the rest of the population. I’d have thought it to be a little obvious, that statistically it would be like that.

Can you blame employers either, given the choice in the labour market, would you employee the easiest people to manage? I think a little more thought and priority or reward should be given to businesses that take on the more complex employees. After all we encourage employers to take on long term unemployed, or young apprentices.

I may not be able to offer incentives or fleshed out ideas, but there does appear to be a gap that needs to be addressed in a comparable why to the rest of unemployment.

If you’re interested in reading more the CMI have a little article, but I’m afraid it doesn’t link back to anything more useful that I could find.

http://www.managers.org.uk/news/disabled-people-failing-find-employment

Posting More Often!

Monday, December 19th, 2011

I’m going to make a little more effort to attempt to post an article at least every week! I’ve got rather lax over the last few months, and with the change in job, I believe its about time for a few other changes as well.

I’d certainly like some encouragement if anyone has topic’s or issues they’d like me to cover!

ksTop 25 Management Books

Wednesday, October 26th, 2011

Just noticed that the UK’s top 25 managment books have been announced by the Chartered Management Institute’s (CMI).

If you’re interested you can find out a little more here.

http://www.managers.org.uk/news/top-25-management-books-announced