Posts filed under 'Technical'
For those of you who are trying to set the organization context within your SQL sessions or custom programs, there’s a new API you must call in R12.
The previous way of setting organization context in 11i was to execute the following statement:
However, in R12, the new way of setting the organization context is as follows:
The â€˜S’ parameter indicates a single organization context. Replace ORG_ID with the ID of the operating unit you wish to use. You can also set a context for multiple operating units by setting the security profile. This is done by executing the following statement:
Replace SECURITY_PROFILE_ID with the ID of the appropriate security profile. ‘ASO’ represents the application short name associated with the responsibility you’ll be using.
February 3rd, 2009
In my last Qualifier article, I delved into the inner workings of Qualifiers in Advanced Pricing by walking through a quick demo of how to setup a Qualifier to reference Descriptive Flexfield data on a sales order transaction. In this article, I’d like to touch on how some Qualifiers require more advanced PL/SQL techniques to retrieve transactional data. For example, the “Customer Party ID” is tied to QP_SOURCING_API_PUB.GET_PARTY_ID function call because the Party ID isn’t stored directly in the G_HDR record structure. With that said, lets walk-thru the creation of a Qualifier that requires us to create our own PL/SQL function reference…
Continue Reading September 12th, 2008
Good question. I’m in the process of figuring this out myself. However, here are a few things I do know based on my research and my recent R12 engagement…
Continue Reading September 11th, 2008
Oracle Advanced Pricing allows you to create discounts, surcharges, and other promotions (called Modifiers) that can be applied against sales orders both manually and automatically. Often there are requirements for Modifiers to only apply in certain situations. For example, promotions on specific products or product lines, discounts on customer types, additional charges on international shipments, etc. So in addition to creating Modifiers, Qualifiers can be used to reference specific attributes of a sales order, product, customer, etc. to determine if the Modifier qualifies for the sales transaction.
Oracle provides a wide array of Qualifiers to evaluate a sales transaction, but situations often arise where Qualifiers are needed for attributes that aren’t available out of the box. However, with a few configurations and little bit of PL/SQL knowledge, you can create your own Qualifier attributes.
Continue Reading July 21st, 2008
In the United States there are numerous international embargo laws in place that restrict U.S. based corporations from selling to countries that are deemed a threat by the government. Cuba, Iran, and North Korea are all examples of countries which no one in the U.S. can conduct business with. These laws can change often depending on the political atmosphere or whoever happens to be in office, making it difficult for organizations who sell or distribute products globally to not only adhere to the laws, but to also adapt their audit procedures when a change to policy occurs.
Continue Reading May 30th, 2008
One of the fundamental flaws in Oracle Order Management (OM) is the inability to include tax on freight and special charge modifiers that are setup in Advanced Pricing (QP). There’s just no way to do it out of the box. Even if you use the Oracle suggested work around, which is to add freight as a line item to a sales order, it’s still a manual process and defeats the purpose of being able to include and calculate freight automatically the way you can through a charge modifier.
Continue Reading February 29th, 2008
These days it’s standard practice for American based companies implementing software systems to send technical development overseas to countries like India, Singapore, and China. If you walk around the corner of your office, you may find a small offshore team crammed into a cubical gathering and reviewing technical requirements to be distributed to resources located on the other side of the world. In almost all cases, the outsourcing model is adopted in an effort to cut down on development costs. On the surface it makes sense – why pay a US based contractor the high salary when an offshore resource can perform the same work for a fraction of the cost? Several years ago, many IT executives considered this question to be a no-brainer and would have immediately adopted the offshore model. But while all their concentration was focused on cutting costs, project managers neglected other important variables in the offshore equation, and as a result there have been few successes and far too many failures in adopting the outsourcing model within the IT industry. If you’re an executive evaluating the cost benefits of the offshore model, there are other factors to take into consideration.
Continue Reading January 21st, 2008
Over the years I’ve been involved with several Oracle implementations where the decision was made to retain the existing warehouse and inventory management systems in place of Oracle WMS. Perhaps your organization had made a similar decision knowing that the existing warehouse solution was best suited for your operations. Not to say that Oracle WMS is the best warehouse management solution out there – because it may very well not be. In fact, it may be true that your Legacy inventory system is the best fit for your business. Not only may it be the best fit, but keeping the existing system in place also eliminates any risk involved in changing the systems of what can be a fragile inventory and shipping operation. In other words, if it ain’t broke, don’t fix it – right?
Continue Reading January 10th, 2008
Recently I was looking for any working example of the OE_Order_PUB.Process_Order API to use for a volume test I wanted to setup. The idea would be to identify a base script that with minimal changes could be used to create and book a mass amount of sales orders. I scoured Metalink and Google, and for the longest time I could not identify a single working example. Many authors claimed to have posted an OE_Order_PUB.Process_Order script that, with slight modifications, are working examples, but this never was the case. There was always syntax or incorrect API parameter issues with each script I encountered…
Continue Reading December 6th, 2007
I recently bought a Lenovo IBM ThinkPad T61 notebook pre-installed with Windows XP SP2, Internet Explorer 7, Office 2007, and all the other IBM software bells and whistles. So far I’ve been quite happy with my purchase, however, I was disappointed to find several issues with IE and IBM factory software that caused my Internet Explorer session to crash when attempting to launch Oracle JInitiator. Upon clicking an apps link I get the infamous “Internet Explorer has encountered a problem and needs to close” error…
Continue Reading August 23rd, 2007
In a previous article, I discussed some of the advantages to using Personalizations within Oracle forms by demonstrating how to validate field data in the Sales Order form within Order Management. I’d like to further demonstrate some of the advanced features of Forms Personalizations by solving a problem that is frequently encountered within the Oracle development community – how to prompt and force the selection of inventory organization when entering a form…
Continue Reading July 13th, 2007
Being that Oracle Order Management is a workflow driven module, there is a tendency for the transactions to get “hung” up on errored or deferred workflow activities that requires the workflow to be retried or progressed…
Continue Reading July 7th, 2007
If you’re reading this article you probably did a Google search for this error message in hopes of finding a solution. Well, you may have come to the right placeâ€¦
Continue Reading July 5th, 2007
The latest Oracle Applications Technology rollup patch released in November 2006 introduces a multitude of fixes and enhancements to core ATG modules (FND, OAM, OWF, FWK, JTT, JTA, TXK, XDO, ECX, EC, AK, ALR, and UMX). The most notable, according to Metalink note 365228.1, are the enhancements to document attachments, Personalizations, and Workflow…
Continue Reading January 15th, 2007
So many times throughout my career I’ve wanted to slightly change the way a form behaves but have been held back because it was considered, dare I say it, a customization to the form. Just seeing the word customization sends implementers running, screaming for Larry. I can just see the developers giving me that “crazy” look when I ask for an open text field to be validated. The horror!…
Continue Reading July 21st, 2006