Oracle Applications & Fusion Blog

Oracle iStore R12i - Carousel View (New Feature) Part - 2

2012-05-10T20:56:00.001-07:00

In Oracle iStore R12i - Product Comparison (New Feature) Part - 1, I have stated that oracle has introduced "Product Comparison " feature in iStore, and this is completely designed in Oracle ADF . As of now I am not sure when oracle will roll this feature, but their sales team is already talking about it.

Apart from "Product Comparison " feature they have introduced the Carousel view to display the related product at the bottom of the iStore page , and again they this feature is designed in Oracle ADF.
Advantage of Carousel view that user need not to scroll up and down to view the related product .

Oracle iStore R12i - Product Comparison (New Feature) Part - 1

2012-05-09T21:09:00.004-07:00

Oracle iStore R12i - Product Comparison -

Oracle in R12i iStore has introduced a new feature "Product Comparison" to compare the product .This new feature has designed in Oracle ADF , and when implemented let user compare the product side by side ,and user can compare up to 10 product at any time.

eoracleapps.blogspot.com

Since it is implemented in Oracle ADF , user has option to drag and drop the product while doing comparison.
Implementation Need - User need to implement 2 new profile options to implement this new feature.

Oracle iStore R12i - One Click Shopping List

2012-05-08T18:26:00.003-07:00

One Click Shopping List
In Oracle iStore R12i Oracle has introduced a new feature , One Click Shopping List (to allow user to add items in shopping list)Though we do have shopping list feature in 11i (but has it's own limitations), but in R12i oracle has made it more intuitive.
eoracleapps.blogspot.com
Now in R12i user has ability to add item in shopping list on the fly , that means user no longer need to save the shopping Cart as Shopping list ( and rename it) , rather they have now drop down list control available as "Add to cart" , moment user click on this "add to cart" drop down control , system will let user either create a new Shopping list (let user create Shopping list on the the fly) or add the item to existing Shipping list,

A new profile has been introduced for this "Enable Shopping List management " , that need to be set before user want to use this feature.

This new feature is available to the Register users only, and Guest user need to login to iStore before they can use this feature.

Like me in linkedin/facebook if you like this post.

Oracle iStore R12i - Integration with Oracle SCM and Financials

2012-05-07T23:40:00.002-07:00

Another advantage with Oracle iStore is , it is very well integrated with Oracle SCM and Financials modules.

For

Payment Processing (Credit Card /Debit Card) / Risk assessment , it is integrated with Oracle iPayment modules. eoracleapps.blogspot.com
Customer evaluations it is integrated with Oracle TCA.
Order Processing it is integrated with Oracle Order Management.
Promotions/Discounts/upsell etc it is Integrated with Oracle basic/Advance Pricing.
Items with Oracle Inventory.
User Accounts verification it is integrated with Oracle User Management.
For Product configuration it is well connected to BOM /Configuration.
For Shopping cart it is integrated with Oracle Order Capture.

Oracle iStore - Advantages of Access to existing Individual account, a R12i feature -2

2012-05-03T21:23:00.001-07:00

In my last post Oracle iStore - Access to existing Individual account, a R12i feature I have explained that Oracle has added a new feature to let existing iStore customer to create a New Online account .

This new feature has many advantages

it is safe ( as customer need not to share confidential information like C Card etc with CSR).
Once Online Order got created , all the old orders placed through non -online sources migrated to the Online account.
error free.
24 * 7 Access
Save Cost ( as ct. is not sharing their confidential information , their is less chance of mis-handling of their data and getting sue by customers :) ) .

"Access to existing account" will work only if profile IBE_INDIVIDUAL_PARTIALS has set , if it is not set then user will not be able to create account online.

Oracle iStore - Access to existing Individual account, a R12i feature - 1

2012-05-03T21:02:00.002-07:00

In R12i Oracle has added a new feature Access to existing Individual account. With this new feature existing customer who usually placed the Order through the CSR can now create Online account by Navigating to link Access to existing Individual account.

Once existing customer navigate to this link , system will prompt user to enter

Existing Account # .
Phone #
Zip Code

Enter preferred UserName ( that customer want to use for online a/c)
Password.

Once customer provides all above details , iStore will Validate the customer's credentials , and create Online account.

Once online account got created user can just place the order online , he/she need not to wait on CSR to create their Orders.

For what are the advantages of Access to existing Individual account, please refer the Post

Oracle iStore - Advantages of Access to existing Individual account, a R12i feature -2

istore (How to Shut down Payment book ) R12i New Feature -1

2012-05-02T18:29:00.002-07:00

In R12i Oracle has added many new features in iStore. In next few blog postings I will talk about (very short) these features

1.In R12i , Oracle has provided feature to shut down the Payment Book .Now in R12i we have new profile option Retain Credit card preference , by setting this to 'N' we can now Shut down the Payment Book.

With payment Book Shut down , System will not display the Credit Card information in the drop down list while doing check out , rather System will prompt user to enter the Credit card Information every time user perform the Check out.

Once Payment book is shut down , it will reflect to all the B2C and B2B customer .But if your business has requirement to SHUT DOWN payment book just for B2C customer , and still want to use it for B2B customer , it can be achieved by means of setting Role IBE_USER_PAYMENT_BOOK.

For more info, feel free to contact me ...

Integration Points b/w Siebel CRM and Oracle Order Management PIP

2012-05-01T23:11:00.000-07:00

Below is data flow for Integration Points b/w Siebel CRM and Oracle Order Management PIP, for more details on this feel free to shoot me an email.

Oracle Payable R12 New Invoicing related Features Part-2

2012-04-08T23:37:00.000-07:00

In Continuation to my previous post (Part-1), below are additional New features Offered in R12 Oracle Payables(Invoicing)

6.Now Oracle Payables enables invoice approval at both header and line levels.

7.The invoice corrections can be made with various types, including price corrections, quantity corrections and amount corrections, at invoice line level.

8.With invoice lines implementations, freight charge can be easily allocated to the real item lines on item.

9.User can apply the available prepayment onto the current invoices during the creation of standard invoices. Pre-Payment will be created a separate line in the Invoice and Gross amount of the invoice will be automatically reduced based on the Pre-payment amount.

10.During Invoice Validation process Oracle Payable validation process will check for validation of the various rules (set of invoices) , and of there is any violation of the tolerances rules then the invoice will be put on hold.

Oracle Payable R12, New Invoicing related Features Part-1

2012-04-08T23:35:00.000-07:00

New features Offered in R12 Oracle Payables (Invoicing).

1.In R12 Oracle Payables we have 3-tier hierarchical Invoice architecture
a.Header
b.Line
c.Distribution.

2.In R12 Oracle Payable Invoice line is now a Child of Invoice header and parent of invoice distribution entity.

3.Three different ways are available to enter an invoice from the Invoice workbench
a.Invoice header to Invoice Lines and then to Invoice Distributions.
b.Invoice as matched to a Purchase Order or Receipt, they will need to
manually look for and pick the matched records from searching result.
c.Quick match to have the matched data automatically fetched from PO or
Receipt, and then populated into the invoice.
4.The Invoice distribution entity will now exist as the child of the Invoice line entity. When the invoice lines are created, the distribution data are automatically generated and tied to the lines.

5.Another new feature is multi-period accounting entry , with this mechanism used cab create deferred accounting data for future data.

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

2012-04-01T23:56:00.000-07:00

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-

Create a PL/Sql API to check the status of Purchase Order.
Create the BPEL process and call above pl/sql API as database Adapter.Expose BPEL process as Web Service.
Create data control from the Web Service created above.Create ADF UI based on this Web Service data control.
Run the ADF from iPhone and Test for few PO status
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.
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

Cannot derive Chart of Account ID from xyz from organization Definitions -2

2012-03-26T17:53:00.001-07:00

In addition to my explanation about the error "Cannot derive Chart of Account ID from xyz from organization Definitions" in the post Cannot derive Chart of Account ID from xyz from organization Definitions , Please note that this error is raised by Oracle application while driving the COGS.

Few of my readers has commented that why on earth system is validating the "Ship From Org ID " of the original Sales order while doing the receiving against RMA.

And ANSWER is - For an RMA application will always drive the COGS account from the Original Sales Order refered by RMA ( if RMA is referring Sales order ) , but if RMA is not referring any Sales order then COGS will be derived from the RMA ( in such scenario original Sales order will not comes into picture at all , and neither this error).

Hope that Helps...

Cannot derive Chart of Account ID from xyz from organization Definitions-1

2012-03-25T10:31:00.003-07:00

recently encounter error "Cannot derive Chart of Account ID from xyz from organization" while performing receiving for an RMA.

While doing investigation I have found the

User was performing receiving against an RMA , and
RMA was referring sales order (Original Sales Order).
At the same time Ship from org ID ( warehouse ) referred on the Original Sales Order was disabled.

It is this disabled warehouse (ship from org ID) on the original Sales order that results in this error "Cannot derive Chart of Account ID from xyz from organization Definitions" .

To fix this issue we enabled the warehouse again and performed receiving against RMA and disabled the warehouse again.

Sync between Drop Ship Sales Order and corresponding PO

2012-03-03T17:18:00.000-08:00

For a Drop Ship Sales Order where Requisition and purchase order has already been created.........

Only Primary Quantity (Order qty) changes on SO will trigger Secondary Qty Syn in Purchasing.
Grade will not be auto Sync between SO and PO.
Shipping Method info from SO will be pass to PO ( Reason - Shipping Method Info. is required by the drop Ship Supplier , to ship the good to customer).
Similarly Shipping Instructions will be pass from SO to PO ( and finally to supplier).
Also a new Menu Option "View Sales Order" is now available in PO to check the status of Drop Ship Sales Order ( Important - this is visible only if Drop Ship PO has already created in system).

NOTE - Please note that Purchasing Module will not Store the SO data elements in Requisition or PO tables, instead this information is taken from SO lines whenever required.

What if we Cancel the drop Ship Purchase Order in Oracle Application.

2012-03-03T17:06:00.000-08:00

For a drop ship sales order , if Requisition and PO has already created and PO is APPROVED too , in such a scenario if user by some reason Cancelled the PO then connection between drop ship sales order and PO will be broken.Now user has following option
1.Cancel the drop ship sales order line and that will cancel the PO requisition too. OR
2.Navigate to AutoCreate and create a New PO from Purchasing Requisition.

Intercompany Invoicing for Drop ships Sales Order (Across the OU)

2012-02-26T00:11:00.001-08:00

There was question about why we created 3 invoice for "Drop ship sales order across OU" in reference to my post http://eoracleapps.blogspot.com/2010/11/how-to-create-drop-ship-sales-order.html

For More details about Drop Ship across OU , please refer the POST

Please Note that ,as per Inter-company Setup , System will generate 3 invoices.
1.AR Invoice from US Operating Unit to Customer..

2. Intercompany AR invoice in Singapore OU(Shipping OU) to US OU(Selling OU).
3.And now US has to pay Singapore OU, so an Intercompany AP invoice will be created in US OU .

US OU - Selling Operating Unit
Singapore OU - Shipping OU
Hope that will helps

Regards
eoracleapps

Query to get the Receiving Transaction where data not yet created in MMT and MMTT

2012-02-22T22:37:00.000-08:00

select rt.transaction_id, rsl.transfer_percentage, msi.revision_qty_control_code,
rsl.item_revision, rsl.item_id,
rsl.from_organization_id, rsl.shipment_unit_price, rsh.shipment_num,
rsh.freight_carrier_code, rsh.num_of_containers, rsh.waybill_airbill_num,
rsh.ussgl_transaction_code, rp.receiving_account_id
from rcv_transactions rt, mtl_system_items msi,
rcv_shipment_headers rsh, rcv_shipment_lines rsl, rcv_parameters rp
where
rt.transaction_id = &your_transaction_id
and rt.TRANSACTION_TYPE = 'DELIVER'
and rt.DESTINATION_TYPE_CODE = 'INVENTORY'
and rt.shipment_header_id = rsh.shipment_header_id
and rsl.shipment_header_id = rsh.shipment_header_id
and rt.shipment_line_id = rsl.shipment_line_id
Read More >>

Can we cancel Drop Ship Sales Order line with OE_ORDER_PUB

2012-02-17T12:45:00.000-08:00

Yes, With Process Order API , we can cancel a Drop Ship Sales order line and it will also cancel requisition and PO (if allowed) that are associated with the drop ship line. Well that is old feature , but I explored it recently.
Source Code for OE_ORDER_PUB

declare
p_header_id number := &p_header_id;
p_line_id NUMBER := &p_line_id;
l_api_version_number NUMBER := 1;
l_return_status VARCHAR2(2000);
l_msg_count NUMBER;
l_msg_data VARCHAR2(2000);
l_xxstatus VARCHAR2(1000);
Read More >>

what is Indivisible Items

2012-02-11T00:03:00.000-08:00

In Oracle Inventory we have feature to define items that can only be ordered in integers and not in decimal quantities.We call these items as "Indivisible Items"

For example, you can order pencils in integers (e.g. 1, 2, 3) rather than in decimals (1.1, 1.2, 1.3).

Navigation path >

Navigate to the Physical Attributes tabbed region in the Master Items window to set upthe item attribute, OM Indivisible, to enter items using decimal quantities.

For example,

Archive and Purging Strategy for Oracle Advance Pricing

2012-02-09T16:34:00.000-08:00

In my last post I talk about Oracle Advance Pricing I have pointed out that we should always have Purge Strategy in place to purge the Unnecessary data (data from past promotions/discounts /campagins etc).

Best of Oracle is they already have Archive/Purge Strategy process in Place as part of Standard process.

Archive process will delete data from QP table and insert them into Archive table.
Purge process will delete data from Archive tables.

Archive /Purge Process – Please note that Archive Process willdelete data from Modifier list lines and Price list lines, though it archive the Modifier and Price list header, but it still keep the Price list and Modifier header data.
Archive /Purge for Price List /Modifier will archive/purge their respective qualifiers too.
Read More >>

Strategies to Improve Oracle Advance Pricing Performance.

2012-02-09T16:15:00.000-08:00

In this post I will talk about a general and simple approach about the Strategies to Improve the Performance of Pricing Engine.

There are tones of material available in metalink about how to improve the performance of the Pricing engine, so I am not going into details, I will just high light some of those approaches.

As all of us knows that Volume of data always Impact the performance, but that doesn’t mean we stop adding the data in the system, but when ever we define the Rules/Qualifiers/Attribute in the system, just take the long team approach and not short team, point that I want to make here is don’t define Qualifiers based based on the Individual records like Item/Customer/Address if possible define in terms of Category/Class/type etc.But many a time business need is to define in terms if Individual records , so that’s fine.

Drop Ship processing in Oracle Order Management

2012-02-08T18:28:00.000-08:00

For a drop ship sales Order ,any attempt to do the partial receipt against the corresponding PO (created for drop ship sales order line) will result in drop ship order line split.

After the drop ship sales order line got split , PO shipment will point to the newly created open line (created after the split ) and shipped qty set to NULL , their will be no relation ship between PO Shipment and the Original sales order line.

Read More >>

Internal Sales Order and Split

2012-02-08T12:30:00.001-08:00

A internal sales order is sales order in the Order Management system that is generated from an internal requisition in the Purchasing system and loaded into OM through Order Import.

Internal order lines are never split, either manually or by the system.Any attempt to manual split internal Sales Order lines will results in error message "You are not allowed to split Order Line because: Cannot split an Internal Sales Order Line"

Also , Order Management does not support item substitutions for Internal Orders.

Cancellation of IR if ISO is still open

2012-02-03T14:27:00.000-08:00

If Internal Sales Order (ISO) created from Internal Requisition (IR) is open , then system will not allow user to Cancel the IR.
Any attempt to cancel IR by means of tools > Control will raise message "says"no control actions found for this document".

But if ISO is shipped /closed system will let you cancel the IR

Scheduling and Reservation with Process Order API.....

2012-02-02T10:11:00.000-08:00

Process order API can be used to perform scheduling actions on order lines. Scheduling
actions include:

schedule
unschedule,
reserve and
unreserve.

The schedule_action_code field provided on the order line record (line_rec_type) can be used to provide the action which needs to be performed on the order line.

Reservations can also be performed by passing the reserved_quantity on the order line record. You do not need to send in the schedule action if reserved_quantity is passed.

Process Order API will also automatically schedule or re-schedule the lines if the schedule_ship_date or schedule_arrival_date field is passed or updated respectively.