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.
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
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
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.
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)
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.
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
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
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
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
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.
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 –
As set of pages and Other activities in a large application.
As a region, providing navigation between page fragments in a single containing page.
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.