Oracle Forms in Fusion replaced by Web UI? One of the readers Santosh, raised a very valid question. His Question:- I heard that in Oracle Fusion there will be no forms and it would be of all web pages. Is that correct? Firstly, let me thanks Santosh for raising this ever important question. I have heard this from various circles that Oracle will phase out Oracle Forms. Fusion may be the right time, but there is no official word as yet(unless I missed it). The SelfService Framework as it stands(despite its PPR-Partial Page Rendering) stands no chance of replacing the Oracle Forms D2K. It looks extremely unlikely that Oracle Forms will be ditched alltogether in Fusion, because:- a. It is impossible to Execute a query(in OAF or ADF) within a section of the screen, without using Search Section ( yucks ! cumbersome). b. Basic functionality like copying the field from prior record field, by hitting single KeyStroke, is not possible in Oracle Framework. c. If fusion is all about web services, then why did Oracle Forms team bother integrating Oracle Forms with Web Services? Oracle's Article Link d. Why did Oracle invest time to make personalizations work on Oracle Forms (in 11.5.10). Looks like there is a competetion ongoing between the forms & Web product teams. e. Oracle Forms is a part of Oracle's Fusion Middleware. I suspect that in Fusion, Oracle will provide every possible business functionality on the web UI. But for the power user requirements(high volume data entry), Oracle might provide D2k type interface using Oracle Forms for some selected few screens. One school of thought against this could be that, high data entry is slowly becoming a thing of past. This is being made possible by de-centralization of operations, which were traditionally back office operations. iProc, iRecruitment, iExpenses etc are prime examples to testify this claim. With the advent of XML & Web Services based integration, re-keying of data will slowly become a thing of past. Take a scenario below:- Company A will raise Purchase Order to Company B, using iProc. This company B will then process the sales Order & ship the same. Shipment confirmation will be sent electronically by XML and Invoice can be received by Company A using XML Gateway and imported into Oracle Payables. Given that no data entry happens anywhere(except from the iProc Self Service user) the possibility of Auto Matching the Payables invoice becomes very high indeed. The Company A will have scheduled Payables batches, that will initiate Payment electronically using BACS/ACH/SWIFT etc. Now the company B will receive a Bank Statement electronically which will be reconciled with the originating sales Order and hence recognising the revenue. And this technology is already here with us in Oracle, working perfectly well. What is lacking is the widespread & speedy adaptation of this technology. But this will happen, because I see this happening already. What will be the core Fusion UI be based upon.... Oracle Forms? Ans: Certainly not Oracle Apps Framework ( OAF ) ? Ans: Not really Oracle ADF? Ans: Highly possible. But will the ADF be UIX or JSF based.......well I do not know. Will Oracle Fusion UI be web 2.0..... Answer: This is unlikely, as Web 2.0 is yet to be tested on Enterprise Wide large Applications. But yes, one thing is for certain, one day Oracle will release Fusion 2.0 which will support Web 2.0 Cheers Anil Passi

TCA in Release 12 & Oracle Fusion and beyond This article represents my thoughts about how the Oracle's TCA will look like in the future. My love with TCA started in its early days, as TCA API's brought a fresh approach of standardising DML's in Apps. I think this is one of Oracle's best written modules in APPS, but the flaws that exist are primarily because Oracle thought about TCA a bit too late. Firstly , what is TCA TCA stands for trading community architecture. As the name might suggest, any entitiy with which a company does or did trading or can potentially do trading in future can be in Oracle TCA. With whom can we possibly trade with? To name a few.... 1. Customers We sell our products/services to them 2. Suppliers They sell us their goods and we pay them in return 3. Employees These can be special customers, or even vendor if they sue you (yucks !) 4. Banks Banks can be paying us interest, or charging penalties, or selling us products. 5. Insuance Company This is Interesting. When you buy their policy, you become their customer. However when you make a claim, you become their customer(as you get paid). 6. Students Even more interesting than 5 above. They are your customers, as you would bill them. They can become your staff latter. Or they can become your vendor if they become independent contractor latter by selling their services to you. Even more, they can become your student again(for post-grad), after resigning as an employee. Well, I have worked upto Release 11.5.10, hence can analyse Oracle's TCA roadmap on that basis. Here are my thoughts ! Financial Services.. vendor or customer or both ! Ever wondered why Oracle Applications eBusiness Suite has not managed to penetrate financial services deeply as yet? Well, one of the reasons is that Financial services make no distinction between a vendor and a customer. For them, whomsoever they trade with, becomes their counterparty. Guess what, Oralce have their suppliers and customers in diffrerent tables and different schemas! Can you imagine that you call up your insurance company to make a claim, and what if they are unable to identify you for the premiums that you have been paying. Is the excuse that ooh well, let me search for you in the customer tables..oops poor fellow will keep switching between Vendor and Customer screen. Four years ago, when working for an Insurance Sector client of mine, I had raised this query with Oracle ( as a Tar ). The response came that merger of Vendors and Customers in Oracle Apps will happen in Release12. I can't wait for Release 12 to be released, however I doubt my current client will be an early adopter(but hey you never know). Before you start pulling your hair with...oops what will happen to hundreds of custom reports that reference po_vendors and po_sites_all? My response is that Oracle are hopefully/surely going to provide views with exactly the same names, but these views will be based on TCA tables like HZ_PARTIES, HZ_PARTY_SITES etc. Surely, if you have written custom processes that modify vendor data, then good news is that such code can be translated to TCA API's, and hence will be supported by Oracle in future. Counterparties For those who do not know, Oracle came out with lovely little product named Oracle Treasury. It is a good product for back office deal/financial instruments, but it has its own flaws w.r.t oracle TCA. At least when I worked on this product(4yrs ago). Four years ago Year 2002, Oracle Treasury's product director visited my client, and I raised a question regarding merger of counterparty to Oracle TCA. His response was to raise a enhancement request, and enhancement I raised. I am waiting to see whether Oracle Treasury counterparties become a part of TCA in Release 12. If not Release 12, I am certain this will happen in Oracle Fusion. A brief example for why this is important. Imagine you are a bank, that you have traded some financial instruments with a counterparty. What if you then supply some consultancy service to that counterpary. Also, what if you are selling insurance products to that counterparty. Imagine if the counterpary has billions of dollars being traded with you. Would you ever with such trading party send a rash reminder that their $1000/- consulting charges are outstanding...blaah for 6months...blaah will blacklist you...blaah will report to credit rating agency........No fool will do that, but how will poor Oracle Receivables system know that this customer happens to be an important trading partner. Students become an Employee Students are currently stored in TCA as parties. Please leave a comment to this post, if you believe there is a standard way of hiring that student as an Employee. Well, if you can't translate a TCA HZ_PARTIES record into HR's PER_PEOPLE_F, then imagine this situation....A student studies at a college where they are also registered in TCA. Assume that this student has unpaid debt of $25,000/-. Will you offer such candidate a job? Hey..but how is HR supposed to know those details....HR will create a new record in per_people_f, with new Employee Number, which in turn will create a new HZ_PARTIES record. Imagine if this student was from Asia or Africa....poor Oracle Receivables will send reminders for invoice payment to far off countries, without knowing that the person works just there.....Please correct me if my understanding is wrong here... Banks Uptill 11.5.10 banks are stored in Oracle Payables. I hope banks are moving into TCA from Oracle R12 onwards or latest by Fusion. Its not that Oracle designed this poorly, the unfortunate fact is that Oracle Payables was conceived much prior to Oracle TCA. I can see that Oracle is finally getting there, hence I can't wait for Release 12. Most of these flaws are not because of poor design from Oracle. These flaws exist because TCA made a late entry. The good thing is that all these separate entities will be moving into TCA. However the challenge will remain that when TCA becomes single data hub for all kinds of trading partners, how will Oracle secure its data , given that there will be multiple modules using the same set of data....I will publish those thoughts soon...here on this blog. Your comments are welcome. Thanks, Anil Passi