RMA line essentials

With Reference to my previos Post  on RMA RMALine(about ct. not able to Progress the RMA lines, as RMA lines got closed after booking).
Apart from the Shippable and transatable flag , following flag should also marked.

1. Returnable
2. Customer Orderable
3. Customer Order Enable.

Not able to Receive RMA Lines

Recently we encounter the issue where our custmomer was not able to process the RMA lines , as soon as they booked the RMA lines , these lines reached to DEFER_FULFILL status and when workflow background process got executed , RMA lines got closed.
Customer Indicated that RMA process was working in past , but now he was not able to progress RMA.
Earlier he was able to progress RMA like

• RMA Creation.
• RAM Booking.
• Receiving.
• Inspection.
• Close.

On Analysis we found that for the items customer not able to create RMA, these items not marked as "Shippable" or "Transactable". We advise ct. to look for their setup and make sure these items are marked as "Shippable" and "Transactable".
customer confirmwd latter that they are able to resolve the issue with my recommendation

Oracle COGS Workflow Customization to Get Account Value

Every Organization has different need based on business requirement; recently I need to give a demo to my customer about how to customized COGS workflow to derive the Cogs account.

Oracle is Provide a very flexible COGS workflow where customer can derive the values for their account flexfield from

1.    Order Line Type.
2.    Item on the Order Line
3.    Sales Rep revenue Account
4.    Model for an option

With all the above option we can derive the COGS account from any one of these options or with the combination of all these.

In my Demo I have selected Oracle Vision Accounting Structure where Accounting KFF has 5 segments.

In my case customer. requirement was derive the

• Company Code from Order Type
• Department   from   Item on Order line ID
• Rest 3 segments from revenue account associated with the Sales Rep.

 Below are step by Step info about how to customized the COGS workflow

Cancel a Drop Ship Order Line with Approve Purchase Order

Many a time customer has following business requirements.

1.    Customer has Drop Ship Sales Order and that has corresponding Approve PO.
2.    Customer performs multiple receiving, that results in Order line split.
3.    Purchase has still some quantity left for receiving, but customer no more interested in more receiving and they want to cancel the Order line. Let me explain with example
    A.Order Qty = 10
    B.PO Qty = 10 (Approved).
    C.Receiving Qty = 2
        i.Sales Order Line  1.1  - Qty = 2  Status = Closed
        ii.Sales Order Line 1.3  -  Qty = 8 Status = Awaiting receipt
    D.Another Receiving with Qty = 3
        i.Sales Order Line  1.1  - Qty = 2  Status = Closed
        ii.Sales Order Line 1.2  -  Qty =3 Status = Closed
        iii.Sales Order Line1.3  -  Qty =5 Status = Awaiting receipt

Now customer no more interested in receiving qty 5 .Now if he /she try to cancel the line 1.3, system will prompt error message that this line has a Approve PO associated with it.

Solution  - Though this is not full Proof  , but it is good if you have 1 or 2 such cases.
Go to Processing constraints Disable the cancel Line Processing  Constarint associated for “PO Approved”.
Navigate to OM and cancel the line 1.3. cancel process will cancel the line 1.3 as well as update the PO with PO Qty = 2+3 = 5.
Enable the processing constraints.
As I said this is not best solution , but is a good workaround.

Template General_Purpose.dbc does not exist.

Template General_Purpose.dbc does not exist. Please specify an existing template for database creation.

I got this error during the Installation of  11gR2.Did Install /UnInstall couple of times , but not able to resolve the issues.

Latter I Unzip both the Files Disk1/2 in One folder  ( Copied the Files Disk2>database>stage>components , in same location of Disk1).

And able to install it sucessfully.

Hope that helps

COGS Process for ATO/PTO Model in Oracle Applications

Recently  , actually not recently but quite some time back one of Reader asked  about how to recognize the COGS in past , I have suggested workaround by means of creation of database trigger ,and solution work   for him ( You can read about that at  Past Dated COGS  ) , lately he asked me question about the how Oracle Apps handle COGS for the line that we do ship but not INVOICE , like ATO/PTO etc.

---------------
COGS applies to Shippable lines from Inventory and, REVENUE occurs on lines that are invoiced by AR. In the case of ATO and PTO, the lines that are shipped are not necessarily the same lines that are invoiced. Upon Revenue recognition of an invoicable line, AR will notify Costing.  Costing follows the below strategy in revenue/COGS matching for configured items (* items)

STRATEGY -
Revenue / COGS matching for configured items is achieved most logically by matching a shipped line (line with cost) to the Invoicable line that it most closely relates to.  If the shipped line is itself invoiced, then the revenue recognition schedule for that line should drive COGS recognition.  If the shipped line is not invoiced, COGS for that line should be driven by the revenue recognition for the nearest invoiced line that it rolls up to.
---------------------

Improve Oracle Advance Pricing Performance - Part 2 ( R11i and R12i).

In this post I will just talk briefly about the new feature introduced in R12 Oracle Advance pricing (Oracle Apps) to improve the performance. As all of us know that performance is very key in pricing and oracle release after release made lot/tons of successful efforts to improve performance.

In R12 oracle has introduced new features to improve performance.
1.    Enhance Price Engine Search.

For enhance price engine search – Oracle has introduce new search algorithm ti improve search time. And this can be activated by means of running the concurrent program and setting a profile option.

CP Name – Existing user need to run concurrent program QP : Pattern Upgrade’  , this is one time and user need not to run once they executed it once. This will basically upgrade existing setup to Pattern based search setup.

Profile ‘ QP:Pattern Search’ has to be setup as ‘ Both Modifiers and Price Lists’ at site  level. Additional user can set the profile “QP: Pattern Search Path”, available value are Search Headers First
Search Lines First

Some questions Third Party Payments on R12 Oracle Payables

Recently One of reader ask me few questions on 3rd Party Payments feature Offered in Oracle Payable in R12.

1.Can payment batches be processed for the remit to suppliers .

Answer - Yes

2.If the invoices are being bought through ap invoice interface, will the relationship still need to be setup even if we bring in the remit to supplier and supplier site data on the interface.

Answer - Yes , for Third Party , we have to define the relationship in supplier setup. By just populating into the Interface table with "remit to " values will not work.
For complete info on 3rd Party payment in R12 Oracle Payable refer 3rd Party Payments





Hope that will be helpful.

Improve Oracle Advance Pricing Performance - Part 1 ( R11i and R12i).

In this post I will just talk briefly about the new feature introduced in R12/11i Oracle Advance pricing to improve the performance. As all of us know that performance is very key in pricing and oracle release after release made lot/tons of successful efforts to improve performance.

In R12/11i oracle has introduced new features to improve performance.
1.    By pass the pricing of insignificant order lines.

By pass the pricing of insignificant order lines.
Thumb rule, more lines you have for pricing, and more time it will take. Many a time it has been observed that pricing engine price even those lines that doesn’t required pricing, eg. Options and Class lines for a Model or exhibits items etc. After huge unnecessary processing, the pricing engine returns a zero price for such line , we can improve performance by ignoring these lines while calling the Pricing engine.

Oracle has provide a new custom hook API QP_CUSTOM_IGNORE.IGNORE_ITEMLINE_FOR_PRICING,  to the customers where they can define logic to identify and tag such lines.
This API is called for every Order line /config line to check if pricing call is required for it or not during Pricing Engine Processing.
The profile option QP: custom ignore pricing need to be set to Y to use this custom API. Bypassing pricing of such insignificant lines shows tremendous improvement

How to Design ADF Bounded Task flow Pages.

In this post I will discuss , What is Bounded taskflow and How to design bounded taskflow with Oracle JDeveloper.


What is Bounded Task flow - As name says these are the task flows with well-defined boundary.
They have activities of type -View, Router, Method call , task flow call and return etc.

Some of Important characteristics of bounded task flows are
1.Single point of entry & zero or more exit points.
2.Use as region on a page with Page Fragments.
3.You can pass parameters to bounded task flows.
4.It must be called to invoke it etc

There are 2 methods to create bounded task flow

1. Initially create bounded task flow flow with pages and then convert into fragments after testing pages completely. Please note that you cannot run individual fragments itself.
2. Create unbounded task flow and then extract part of it as unbounded task flow.

Jdev provide us option to convert Bounded task flow with pages into Bounded task flow with fragments and vice – versa in single click of mouse.

Application of Bounded task flow –

1. As set of pages and Other activities in a large application.
2. As a region, providing navigation between page fragments in a single containing page.
3. Use as a modal dialog box, launched from a page.

For More Info on ADF Pages , refer my posts on ADF.

Test Case
In this example, I will explain how a Unbounded task flow Page work.
For my test case I have design a JSF Page with Panel Accordin (with 2 Panels).
Panel 1 has simple Button that calls Unbounded Task flow
Panel 2 has bounded task flow with 3 fragments along with Train Control.

Here, I will discuss unbounded task flow only.


Create one Unbounded task flow as shown below

How to export ADF table data into excel Sheet.

Oracle ADF provides lot of utilities and controls. Among them is how to export data from ADF table to Excel Sheet.
In my example I am taking case to add this in Menu Item.

Following are steps to do that.

• Add Toolbar , Menu and Menu Item to your ADF Page.
• Give a meaningful name to your Menu Item.
• Add Table control.
• From "Component Palette" go to "Operation" and drag “Export Collection Action Listener” and drop it over your Menu Item.
• In the Popup “Insert Export Collection Action Listener” enter value for table you want to export in “ExportedId” and “Type” as shown below.