Oracle ebs Purchasing data discovery with Qlik Sense

With data discovery tool like Qlik Sense , we can explore data to see what’s happening and why. 

Navigate vast amounts of data from multiple sources. Ask questions and find your answers.
With Data Discovery tool we can Create Smart personalized, interactive data visualizations, reports and 
Dashboards

In Our demo we are exploring and discovering Oracle Purchsing (PO only) data with Qlik Sense.

To begin with we have created Dashboard to explore
Purchasing KPIs
PO Analysis
PO Analysis (contd)
On Hand Qty

iPhone Mobile Browser Apps to Access BPEL Webservice(based on Oracle Apps) and BPM Worklist

This is short presentation about How to access a BPEL based Web service from iPhone UI ( Developed with Mobile ADF), plus how to access BPM worklist from iPhone.

Requirement -
Design BPEL Human Taskflow Web Service and Access that from iPhone.For My Test case I have Designed a BPEL based web service(this web service used Oracle Applicationss public api to check the status of Purchase Order).
If status of Purchase Order is Approved then just return the status , Else for any other Status send an FYI Notification(Designed in BPEL Human taskflow) to buyer via BPM Worklist.

Step Implemented to fulfillment above requirement-

1. Create a PL/Sql API to check the status of Purchase Order.
2. Create the BPEL process and call above pl/sql API as database Adapter.Expose BPEL process as Web Service.
3. Create data control from the Web Service created above.Create ADF UI based on this Web Service data control.
4. Run the ADF from iPhone and Test for few PO status
5. Add a new scenario (FYI Notification)- Check the status of any PO and If the PO status is not Approved then send an FYI Notification to Buyer.
6. Add Human task flow to BPEL Process for Notification , If the PO status is not Approved then send an FYI Notification to Buyer in BPM WorkList.

Demo

Data flow for (P2P) Requisition to Payment Cycle in Oracle Applications

This is  short YouTube Presentation about Data flow from Oracle Purchasing Requisition to Payment in Oracle Payables

Approved Supplier List (ASL) in Oracle Purchasing

This Post is about Oracle Apps Purchasing and ASL ( Approved Supplier List) and I will explain how to define the APPROVE SUPPLIER list in Oracle Purchasing

In the last REQ TO PO RECEIPT cycle post we have noticed that I have define an Item(Test001) with “Use Approval Supplier Checked “ and when I try to approve the PO Release for this item system prompt with error message

“Item is restricted and Supplier is not Approve Supplier”. To Progress the Releases /PO with the item that are mark as “Use Approve Supplier” , we need to define the Item in the Approve Supplier List.
Note - In Approve Supplier List (ASL)we define all the Supplier that are Approved to Supply a particular Item.

RFQ to PO Receipt Cycle

This Post is about Oracle applications RFQ to Receipt Cycle.In this Post I will explain the Cycle from RFQ to PO Receipt with screen shots.

High -Lights of this Cycle is
Create

• RFQ
• Quote
• Purchase Order
• Receive against PO.

Once RFQ is created , Submit concurrent job “Request to Print the RFQ” for a supplier. On completion this job will increment print count for that supplier as shown below.

In below  Oracle Apps UIs we can see

API to Check Status of Purchase Order in Oracle Applications.

Below is API that return you the status of Purchase Order -


DECLARE
l_po_header_id          NUMBER;
l_po_status_rec         PO_STATUS_REC_TYPE;
l_return_status         VARCHAR2(1);
l_autorization_status   VARCHAR2(30);
l_po_release_id         NUMBER;
BEGIN
 PO_DOCUMENT_CHECKS_GRP.po_status_check
                                (p_api_version => 1.0
                                , p_header_id => l_po_header_id
                                , p_release_id => l_po_release_id
                                , p_mode => 'GET_STATUS'
                                , x_po_status_rec => l_po_status_rec
                                , x_return_status => l_return_status);
                               
l_autorization_status := l_po_status_rec.authorization_status(1);
dbms_output.put_line('Status = '||l_autorization_status);
END;

Duplicate data on Oracle oe_drop_ship_sources

This Post is about Oracle Apps Drop Ship Sales Order.

Why I have duplicate data in oe_drop_ship_sources.answer is simple, for a drop ship sales order when I book Sales Order in Oracle Apps, Oracle workflow for order line progress to p\Purchasing - deferred activity.once we execute the WBP it insert the data into Oracle Requisition Interface Table ( to Create Requisition and Purchase Order).NOW
1. Some how if user rewind the order line workflow to an activity before purchasing -deferred and delete the data from Req interface .in such cases workflow when got progressed to purchasing -deferred,it will again insert data in oe drop ship sources.


- Posted using BlogPress

How to Create Supplier List and RFQ

This Post is about How to create Supplier List and RFQ in Oracle Purchasing.

In the post I will explain about the Supplier List and how to use Supplier List and Price breaks while creating a RFQ.

Navigate to Supplier List
Supplier Base > Supplier List

 Purchasing Responsibility  -Navigate to RFQ UI

Navigation > RFQ.
Enter details for the RFQ

Operating Unit
RFQ Type
Status
Due Date
Description
Reply Via
Close Date
Item
category
UOM etc

How to Define the Payment Terms for Supplier in Oracle Purchasing

In this blog I will explain "How to define Payment Terms for Supplier in Oracle Purchasing" .

Step#1
Define a Supplier

Step#2

Define Supplier Site

Step#3

Click on the Payment Tab and define your Payment terms for Supplier /Supplier Site combination.

 

Save your data.

Step #4

Create Purchase Order

Step #5

Press the Terms Button on Purchase Order ad it will reflect the payment Trems that you have defined in Step#3.