-
Procure to Pay Cycle
Diagrammatic representation of Procure to Pay cycle. Watch the procure-pay-cycle-video Article with 11i screen shots: Procure to Pay Cycle 11i Query: Procure to Pay Cycle Query 1) Create Requisition: Requisition is nothing but a formal request to buy something (like Inventory material, office supplies etc) needed for the enterprise. Only an employee can create…
-
Order to Cash Process
order to cash process steps can be listed as below Enter the Sales Order Book the Sales Order Launch Pick Release Ship Confirm Create Invoice Create the Receipts either manually or using Auto Lockbox ( In this article we will concentrate on Manual creation) Transfer to General Ledger Journal Import Posting Watch o2c Video: Order…
-
Interfaces and Conversions
Overview: Oracle provides flexible tools in the form of Interface programs to import the master and transactional data like Customers, Invoices, and Sales Orders etc from external systems into Oracle Applications or to transfer the data from one module to another module. There are 2 types of interfaces: 1)Inbound Interface: will be used to upload…
-
Importing Blanket Purchase Agreements(BPA)
In this article we will see what a Blanket Purchase Agreement is and how we can import them along with the price breaks. Overview of Blanket Purchase Agreements: You create blanket purchase agreements when you know the detail of the goods or services you plan to buy from a specific supplier in a period, but…
-
Delimited Report Output using Report Builder
Overview: In this tutorial, we will see how to customize the existing standard Oracle report to get a delimited output file instead of the regular layout. Most business users prefer delimited report output as it can easily be imported into Excel where they can manipulate and perform calculations on the data easily. Report Builder is…
-
JSP forms Customization in 11i & R12
Overview: JSP allows the embedding of servlet code within HTML pages. As part of the Java technology family, JSP technology enables rapid development of Web-based applications that are platform independent. JSP technology separates the user interface from content generation, enabling designers to change the overall page layout without altering the underlying dynamic content. In…
-
Email the output of a concurrent program as Attachment
This article illustrates the steps to be followed to Email a concurrent program’s output. Write a procedure that will submit the concurrent program whose output has to be sent as an Email and once the program completes, send the output as Email using UTL_MAIL.send_attach_varchar2. Register this procedure as a concurrent program so that this program…
-
BPEL Database Adapter Part 2
In this article I will explain how to pass parameters to the Database Adapter. This article is continuation of our previous Database Adapter Tutorial 1. Open previously created project in jdeveloper. Now Double Click the ‘FetchEmail’ Database Adapter Click the Define Adapter Service Icon Click Next Next Next Next Next Next In the Parameters Section…
-
BPEL Olite Database Connection
With SOA Suite by default we get to install the Oracle Olite Database and in this article i will explain how to make a connection to that database explicitly from different tools Method 1: Open command prompt Navigation: Start >> Run >> cmd Then navigate to the directory SOA_HOMEbpelbin Once you are in bin…
-
BPEL Tutorial for beginners with helloworld example
After reading this article you will be able to understand the following things: What is SOA? What is BPEL? Difference between SOA and BPEL Advantages of SOA/BPEL Download SOA Suite “Hello World/ErpSchools” Tutorial in BPEL Compile and deploy BPEL Suitcase using bplec.bat Monitor the activities/instances/statuses in Dashboard What is SOA? SOA stands for “Service…
-
Alerts in Oracle Applications
Overview: You can use alerts simply to notify one person/multiple persons about an event or some data change. There are two type of alerts Event based Alerts Periodic Alerts Event based Alerts: These Alerts are fired/triggered based on some change in data in the database. Ex: If you want to notify your manager when…
-
Get SQL for a concurrent request id
1. Use this Script to get current sql statement that is running in the background for a given concurrent request. 2. Get all the sql statements that are being executed by a user. 3. Get all the blocking sessions — GET THE CURRENT SQL STATEMENT RUNNING FOR A CONCURRENT REQUEST SELECT A.REQUEST_ID, D.SID, D.SERIAL#, D.OSUSER,…