OracleContractors.com Forum: Last 35 Posts

Anonymous on "unable to Access R12 Sandbox"

Anonymous — Thu, 24 Mar 2011 14:24:45 +0000

I am not able to login into R12 Sandbox. Although after successful completion of the Registration process it give me below message.

"Login failed. Please verify your login information or contact the system administrator."

Anonymous on "HTML Text in Workflow Notifications"

Anonymous — Mon, 31 Jan 2011 15:02:47 +0000

I thought I would include a note here on adding dynamic HTML text in Workflow Notifications since it took me a while to figure out.

Unfortunately it's not as straightforward as adding an Item Attribute to the Message, referencing this in the HTML tab and then writing code to populate the Attribute from within a preceeding Workflow function call. Doing it this way doesn't format the text in HTML but rather displays all of the text as one string including the HTML tags.

Whilst most of the above are required steps, within the code that you write you will need to create a Procedure that returns a CLOB variable named 'document' which itself is populated within your Procedure by making the following function call:

wf_notification.writetoclob(document, l_document)

'l_document' is a local variable defined within the Procedure that is populated with the text, embedded within HTML Tags, that you want to appear in the Notification.

The Procedure header must be defined as follows:

PROCEDURE <procedure_name>
(document_id IN VARCHAR2
,display_type IN VARCHAR2
,document IN OUT NOCOPY CLOB
,document_type IN OUT NOCOPY VARCHAR2) IS…

You will then need to create a function that is called from Workflow prior to the Notification activity which sets the value of the message attribute by making a call to the Procedure above in the following manner:

wf_engine.SetItemAttrText(itemtype => p_itemtype,
itemkey => p_itemkey,
aname => '<Item_Attribute_Name>,
avalue =>
'PLSQLCLOB:<procedure_name>/'|| p_itemtype||':'|| p_itemkey);

The 'document_id' parameter defined within your Procedure holds the Workflow Item Type and Item Key passed in the call to PLSQLCLOB.

There's more information regarding the use of PLSQLCLOB within the Workflow Developer's Guide.

Anonymous on "London oracle contract market is dead"

Anonymous — Thu, 15 Apr 2010 15:06:24 +0000

Hi,
I have 12 years experience as a Functional R11 and R12 Financials and Projects and am finding it hard too for the same reason.
I found that some Indian companies have exploited the UK marked as they are significantly cheaper (you pay peanuts....) however I also have found that clients that have bought cheap are buying twice and the second time are staying as far as possible from the Indian colleagues as, I am told, that there is no imagination with their work, just what we ahve asked.
I am keen to find out if anyone else has founf the same situation.
I think we have to figure out a way to improve communication with Clients without having to give too much away for little return.

Good luck to us all... ;)

Anonymous on "Status for OracleContractors R12 Vision Sandbox?"

Anonymous — Tue, 02 Mar 2010 18:12:20 +0000

I have been trying to access the sandbox but am having no luck if I type login it just takes me to home page - any ideas help please

Anonymous on "London oracle contract market is dead"

Anonymous — Fri, 29 Jan 2010 17:04:58 +0000

Hi all,
I have 12 years experience as an oracle dba and I am really struggling to get a job for over a year now in London or anywhere.
The employers are being really choosy and I think most are going offshore to India as its cheaper.
Is my career over??

What is goin on out there?

Desparate in London.

Anonymous on "Oracle/PeopleSoft HCM 9.1"

Anonymous — Tue, 19 Jan 2010 20:41:20 +0000

It looks like HCM 9.1 upgrades are starting to pick up. I keep getting asked about 9.1 experience. My reply is no and there are few if any out there with the experience. I've spoken with current firms that I partner with and they agree. Does anyone on this forum have experience with 9.1? Just want to see a show of hands. If you want to include your perspective on the upgrade or new implementation that would be great too.

admin on "Status for OracleContractors R12 Vision Sandbox?"

admin — Mon, 29 Jun 2009 14:24:51 +0000

Hi there,

Are you still having the same issue? If so please email rebecca.bragg@oraclecontractors.com and I will follow up for you.

Thanks,Bec

Anonymous on "Status for OracleContractors R12 Vision Sandbox?"

Anonymous — Wed, 24 Jun 2009 20:25:53 +0000

I have the same problem but with internet explorer one week ago till now,can anybody help

Regadrs
A.Mousa

Anonymous on "Status for OracleContractors R12 Vision Sandbox?"

Anonymous — Thu, 18 Jun 2009 03:49:27 +0000

Hi all,

I tried to access the Oracle EBS R12 Vision sandbox and it says that the server is not available:

Firefox can�t open the page �http://oracontractors.fs-server.com:8000/OA_HTML/OA.jsp?page=/oracle/apps/fnd/sso/login/webui/MainLoginPG&_ri=0&language_code=US&requestUrl=&oapc=5� because it can�t find the server �oracontractors.fs-server.com�.

Did the server go offline? I was going to use this to do some testing as part of future whitepapers on R12 DBA topics.

Regards,
Ben Prusinski

Anonymous on "Query"

Anonymous — Tue, 09 Jun 2009 10:36:12 +0000

Does a data block data source using FROM CLAUSE allow DML operations? Yes or NO?

Anonymous on "Oracle EBusiness Suite release 12.1"

Anonymous — Fri, 29 May 2009 22:34:27 +0000

12.1.1 out since March 30

Anonymous on "Cant make payment in AP"

Anonymous — Fri, 29 May 2009 16:26:09 +0000

you need to have AP and GL accounting periods open b

Anonymous on "Cant make payment in AP"

Anonymous — Wed, 27 May 2009 14:54:33 +0000

hi,
may be Cash Account are not defined correctly.

fix:

Check the following setup for the Cash Account:

1. Navigate to Setup -> Payments -> Banks
2. Query up the bank.
3. Go to Bank Account
4. In the GL_Accounts region, make sure that the Cash Account is defined correctly.
regards

Anonymous on "Cant make payment in AP"

Anonymous — Fri, 22 May 2009 11:15:23 +0000

Hi all,

I have setup my AP and created 3 invoice batches which as seen validated yet when i try to make payment i get the following error"APP-SQL - 10006: the date you entered is not an open accounting period."

I have opened the calendar for that month yet it giving me this error. Any help will be appreciated.

Anonymous on "Shared Service Centres - How to Lose Friends and Alienate People"

Anonymous — Wed, 13 May 2009 15:11:19 +0000

A few months ago I was asked to help rescue a failing project.Nothing unusual their thats what I do as an independant consultant.

A large group of NHS Trusts had contracted with a shared service cenntre to install an eProcurement solution.Again nothing new their as this path has been tread a thousand times before.

So I aske my sponsor what the issues were.He indicated that the PCT's had suspisions that the SSC organisation were not sufficiently versed in delivering IT projects that he wanted to hedge against the risks by hiring his own procurement expert.

I established that the project had been going two months before I arrived and would be required to play catch up.

Over the next six weks i met my follow PM's from the other PCT's and quickly realised that they were not full-time PM's and most were Finance Directors with real jobs and had pressures such as month end accounts to complete.This in efect left the SSC a free reign to do what they want.

In my second month I started asking for project plans, requirements documents , gap analysis, user acceptance test scripts...etc..I may as well have been talking a foreign language as the PM for the SSC (Shared Service Centre) hadnt got a clue that these were required. She was working to aplan on the back of a fag packet and this certainly didnt include talking to customers,end users etc..

I decided to give the SSC the benefit of the doubt and start talking to y pilot sites that had been agreed before my arrival. Unanimously each of these had sever reservations about the product and its inability to meet their needs.

I have sinced pulled the plug on the implementation and aksed for a break to go back and fix the problems.

It has shocked me to the core that we have public bodies wasting tens of thusands of pounds of pub;lic money trying to force through IT projects run by cheap and cheerful inexperienced staff.

I would love to hear from other colleagues with similar stories and how they fixed the problem.

Anonymous on "what are the main steps and problems in setting up MRC"

Anonymous — Mon, 20 Apr 2009 17:30:12 +0000

what are the main steps and problems in setting up MRC

Anonymous on "Pendragon Finally pay up"

Anonymous — Wed, 15 Apr 2009 19:31:40 +0000

After months of getting nowhere, I finally took Pendragon Information Systems to court. They owed me over �22K. On Friday the 13th of February they paid up in full, one day before I could have slapped a County Court judgment on them. Since then I have heard from other agencies that other Pendragon contractors are not being paid. Beware.

Anonymous on "ODI EE: the best ODI and OWB in one single product"

Anonymous — Thu, 02 Apr 2009 13:09:36 +0000

Today Oracle includes Oracle Data Integrator and Oracle Warehouse Builder Enterprise ETL, formerly an add-on option to Oracle Database, as the two components of ODI-EE. Going forward, these products will merge into a single unified data integration technology platform. This strategy fully preserves any existing development investments of all Oracle data integration customers and will provide a seamless, easy upgrade path from the current components to the unified platform. Oracle Data Integrator Enterprise Edition addresses multiple enterprise data integration needs.
? Data Warehousing and Business Intelligence�by executing high-volume, high-performance loading of data warehouses, data marts, On Line Analytical Processing (OLAP) cubes, and analytical applications. It transparently handles incremental loads and slowly changes dimensions, manages data integrity and consistency, and analyzes data lineage.
? Service-Oriented Architecture�by calling on external services for data integration and by deploying data services and transformation services that can be seamlessly integrated within an SOA infrastructure. It adds support for high-volume, high-performance bulk data processing to an existing service-oriented architecture.
? Master Data Management (MDM)�by providing a comprehensive data synchronization infrastructure for customers who build their own data hubs, work with packaged MDM solutions, or coordinate hybrid MDM systems with integrated SOA process analytics and Business Process Execution Language (BPEL) compositions.
? Migration�by providing efficient bulk load of historical data (including complex transformations) from existing systems to new ones. It continues to seamlessly synchronize data for as long as the two systems coexist.

Since OWB 10.2 (not 10.1), all 'major' new features have been added into the "Enterprise ETL" paid packaging (and not into the free, core ETL features). Fact is that there are no plans at all to add any new substantially price-worthy features into the free packaging of OWB on the DB.
Some sensitive people seem to take this as an indication that "OWB is dead," which it is not. The plain and simple fact is that the free features of OWB are already very, very powerful, and therefore our commitment to investing in new advanced features is limited to the paid product area - ODI-EE (including future releases of ODI and OWB).
For the free OWB features, there will continue to be (a) investment in bug fixes and patches, as well as (b) any other improvements to the overall product which happen to fall into the "free" category. For example, improving the dimensional modeling capabilities may be driven by our paid customer install base, but the free users benefit from this since dimensional modeling is a free feature.

Until nowadays doesn�t exist any kind of tool allowing the migration among applications developed by OWB and applications developed by ODI.
The only possible technology is the manual one. A team of people analyze individually every OWB mapping trying to replicate the functioning in ODI. This kind of process is very long and complicated with the risk of not being able to replicate exactly the applications thus not enabling a complete and functioning migration.
Instead, the OWB>ODI Converter, developped by Oracle's partner D&T, has the purpose to simplify and speed the migration as much as possible, automatizing the process. The Converter automatically makes an analysis on each mapping, highlighting the semantics of the single mapping. The utility of the Converter, thus of an automatic migration, is evident when very complicated OWB mapping have to be migrated with a great number of operators and various ramifications. The Converter allows to automatically verify which objects of a database are actually used in a OWB project therefore enabling to make a clean migration that doesn�t bring in the new environment objects no longer in use.

www.owb2odiconverter.com

Anonymous on "ODI EE: the best ODI and OWB in one single product"

Anonymous — Thu, 02 Apr 2009 13:06:49 +0000

Anonymous on "Oracle EBusiness Suite release 12.1"

Anonymous — Tue, 24 Mar 2009 22:44:33 +0000

Anyone know when 12.1 is coming out?