Oracle ERP User Network Collaborate with Professionals working on Oracle ERP(Oracle Apps) including EBusiness Suite (R12, 11i), Fusion, Peoplesoft, JDE, Siebel, Hyperion, OBIEE, SOA etc.

Have you ever wanted to see your Oracle output or log files open in your custom text editor instead of an IE window? I use Notepad++ (FREE) for text editing. Every time I open an output file or log file which is text it opens in IE. This is undesirable for a couple of reasons: (I'm sure you can name more)

1. This means I have SEVERAL IE (Internet Explorer) windows open for each log I am viewing.
2. I cannot use the advanced features of my desktop application, I'm stuck with CTRL+F in IE, etc.

If you are in my boat, I ..

How many times have you been told by Oracle Support that you should run a concurrent request...only to realize that you have no idea which responsibility to choose to run the request? Or you want to instruct a user to run a request, and you want to be sure they have access? The query below will help you. It will provide for you the responsibility name and the request group name which can run a concurrent program. You can search by the user_concurrent_program_name or the "short_name".

SELECT FRT.RESPONSIBILITY_NAME, FRG.REQUEST_GROUP_NAME, FRG.DESCRIPTION
  FROM FND_REQUEST_GROUPS FRG
      ,FND_REQUEST_GROUP_UNITS FRGU
      ,FND_CONCURRENT_PROGRAMS FCP
      ,FND_CONCURRENT_PROGRAMS_TL FCPT
      ,FND_RESPONSIBILITY_TL FRT
      ..

In this article I will be explaining the general steps involved in any Conversion/Data Migration of Oracle Projects module.

At the end of this article, you would have learned:

* Stages in Oracle Projects Conversion.
* How to setup the Oracle Projects module for the conversion/Data Migration.
* Options for the Load (flat file, csv, or direct Loads).
* Oracle Projects AMG APIs needed to perform the Conversion.
* Testing the Conversion Process.
* Verifying the Conversion Process.

Scenario:

Company 'XYZ' is using a Project Management and Accounting Software for years long. The Management has decided to move from their existing ..

How to personalize a page in order to open a document in a new window ?

If you want to add a link in a page, you can do as below :

In the personalize Page link, add an item :
Item Style : Button
ID : My_Doc
Destination URI : http://........../document.pdf
Prompt : My doc

The above opens the document in a new window.

As an Apps technical or functional consultant, it is essential for you to understand what options EBS gives you to if you want to talk to a SOA component like BPEL or ESB. The selection depends upon the interaction pattern you are looking for - invoking the SOA component from EBS or invoking EBS components from SOA components, whether the communication needs to be in real time, batch, complexity and technical feasibility.  Following are the options that Oracle provides:

Interface Tables and Views:

The most common strategy to insert data into the Oracle Apps' tables is to first insert the data ..

This is to answer question to those who might be wondering how iStore is fit/can be used in an Order-To-Cash cycle.

iStore is just another mode to capture Orders or Quotes based on the setup. In case you set it as Order then iStore directly links you to Order-to-Cash. There is no special extension of the Order to Cash which would include iStore. In fact, there is no new functionality that iStore does in the O2C cycle.

Here is how the flow looks while iStore is linked with OTC cycle.

iStore:

1. Customer enters and submits Order with credit card or other ..

We all know the we can refer system profiles by using FND_PROFILE.VALUE(profile_name). There are already existing system profiles. We can also define and set up profiles not provided by Oracle, for example: FTP_TO_TARGET_SERVER_NAME. In this case, we can refer it in PL/SQL by FND_PROFILE.VALUE('FTP_TO_TARGET_SERVER_NAME'). The below are the steps to define user profiles.

1) Log in as Application Developer responsibility, click on ‘Profile' from menu. when the form opened, input all necessary information.

Name: FTP_TO_TARGET_SERVER_NAME

Application: XX

User Profile Name: Target Server Name for FTP

Hierarchy Type: Security

Hierarchy Type Access Level: Check site and Application.

2) Switch to System Administrator ..

pztkw4vnxi

Solution and Content contributed by Bill Foster.

This is a workaround solution for one of the most asked question by Clients implementing Order Management "How to Calculate Freight Charges?" Thanks to Bill for sharing this wonderful solution. Oracle doesn't have solution for this even in R12.

Problem:  Add Freight Charges to a Sales Order in Order Management and have Oracle/Vertex tell how much (if any) Taxes should be charged on the Freight Charges.

Solution:  

• Use an Item called ‘FREIGHT' which is basically treated as any other Item where you can establish the tax code ..

 

What is ‘Oracle ERP Reporting'?

In any company there are 2 clear aspects to reporting - namely the definition and the technology.

The definition of reports required for internal and external customers is entirely a matter for the business managers. For example, Finance teams define what reporting is required to meet statutory and regulatory requirements. They define what information is included, who receives the report and when the report is delivered to the customer.

The IT team is responsible for advising on, developing and supporting the technology used to meet the needs of business reporting. The IT role is ..