OM: Over Shipment Tolerance(Internal Name - OM_OVER_SHIPMENT_TOLERANCE)

This is short post about usages of Oracle Order Management profile option OM: Over Shipment Tolerance(Internal Name - OM_OVER_SHIPMENT_TOLERANCE) at various level (Site, Organization , Responsibility)

This profile option indicates the percentage by which an order line can be over-shipped. Any value greater than or equal to zero (0) is a valid value. This profile option is set at the site level. Default value is zero (0).
This profile is also applicable to Inbound Lines (RMA).

 

As of now as per standard functionality this profile option is supported at Site level. Value populated in this profile options are stored in the column SHIP_TOLERANCE_ABOVE of OE_ORDER_LINES_ALL and then same values that interfaced to column SHIP_TOLERANCE_ABOVE of the WSH_DELIVERY_DETAILS.

 

 As per Standard functionality, documented in the user guide this profile option should be set at the SITE level, but many a times we have requirement to set this profile options at different level, like 

• Organization
• Responsibility

 I did a few test case by setting the profile option at the organization and responsibility level and it work for me(please note that this is my observation and not standard behavior).In case you want to set this profile at Organization or responsibility level JUST make sure that after you set the profile at these levels column SHIP_TOLERANCE_ABOVE in OE_ORDER_LINES_ALL and WSH_DELIVERY_DETAILS has expected value(set at the Org /Resp level profile).

Oracle Payable R12 Invoice Approval Workflow Part-3

This is 3rd and last post on "Oracle Payable R12 Invoice Approval Workflow", for First and Second post please refer links

Part-1

Part-2
In addition to the feature that I have explained in part-1 and 2.

• Oracle Payable applies the validation rule to Invoice Approval process based on the setup we made in the Payable options like
• If we select "validate before approval" in Payable Options then system will not initiate the approval process untill invoice is validated, same is the case with "generate accounting before approval".
• In R12 now we can drill to Invoice lines/distributions from the approval Notifications and if required we have option to change the Amount or Quantity.In R12 Approver can now initiate the negotation process while doing the approval by means of changing the Amount or Quantity.

           Below are the steps by Step deatils of Negotation -

1. While doing approval , if approver found some discrepencies in the amount or quantity , he can initate the Negotation process by means if chaning amountg or Quantity.
2. Any change in Amount /Quantity will enable negotation button on the Approval Notification UI. After making change in the Amount and Quantity , approver inform Vendor by click the Negotation button , which in turns sent an email to suplier about the changes.
3. Supplier has option to cancel the invoice and send a new invoice or can Re-Negotate the price again.

• Non-PO match invoice entered through iSupplier portal always go through the approval process ( as Status will alway sbe "required approval").
• For PO-Matched Invoices approver and approval process is based on the Setuo defined in Oracle Approval Management.

FULFILL_LINE actvity in DEFERRED Status

In Seed workflow for Oracle Order Management FULFILL_LINE workflow activity is not Deferred activity , but once in a while we came across the issue where order lines stuck at FULFILL_LINE activity with status as DEFERRED. In such case executing thehworkflow background process will pick these lines and process them
There could be many reason for why FULFILL_LINE activity is in deferred status , but 2 very common that I have noticed are
1.User customized the workflow and mark this activity as DEFERRED by means of setting the cost > 0.50

2.While processing the Model and it's line for FULFILL_LINE activity  , if workflow background process not able to  lock all the lines of the model , it will set the status of the FULFILL_LINE  activity as Deferred.. Executing workflow background process AGAIN usually pick and lock all the lines and Model and  process them. But if executing WBP again and again still not progress the lines from FULFILL_LINE activity then their is possibility that Deferred queue for Order lines got corrupted and there  is need to rebuild the Deferred Queue ( Refere Note - 466535.1. about how to rebuild the queue).

Oracle Payable R12 Invoice Approval Workflow Part-2

In Continuation to my  previous post on Payable Invoice approval workflow  Oracle Payable R12 Invoice Approval Workflow Part-1  
below are the additional features of Payable Invoice Approval Workflow

• In case approver  Rejected the Invoice we have option to
• Force the Approval Process
• Manually approve the invoice.
• Initiate the approval process again
• Cancel the Approval process by means of canceling the invoicing.

                  Note - Please note rejection process end the workflow, but once we Initiate it again , it will
                             RE-START the workflow.

• We can delegate the Invoice approval process to a person who is out of Approval Chain.But if we delegate the response to out of chain person then workflow approvel process will send only one reminder to this person , but if he still not respond NO escalation will be raised.Let's say approval process is like A to B and B to C ,but  in case B delegate the approval person to user OUTOFCHAIN, in that case when OUTOFCHAIN will approve the Invoice approval process will automatically inform the next user in the chain (in our case it is C), but in case user OUTOFCHAIN doesnot respond , in that case approver process will send only one reminder to him , if he still not respond then NO ESCALATION will be raised.

• As I have said Payable Invoice approval process will triggered only when Approval Status = Required/Reapproval -required.In case approval status = Not Required then payable approval process will not triggered at all.Below are the valid scenarios when approval_status = Not - Required.
• Expired Invoices.
• Recurring Invoices.
• Invoice created before Invoice Approval Workflow Process  implemented.
• None of AME Invoice approval rule satisfied.

• If we STOP an approval process we can initiate approval workflow process again ,  but if we CANCEL approval process workflow canot be re-initiated.

• FORCE approval - with force approval option , we can force the approval process by means of approving a Non-Validated invoice irrespective of the validation rules.e.g Workflow for the Invoice is error out , and we need to make immediate payment to Vendor. In such cases rather than waiting for fixing the workflow we can FORCE the approval process and approve the invoice.

that's for now , will discuss more feature in next post.

Scheduling at KIT,

Recently , I came across a issue where customer has stated that

1. They have set up the ATP KIT level (usually majority of the cases ATP set at included item level).
2. Workflow for the KIT item is at the HOLD activity just before the scheduling.
3. Workflow for all the Included item are at the Scheduling activity 
4. Scheduling performed by means of Scheduling workflow background process( and not auto scheduling).

Please note that if ATP is setup at the KIT level , then Scheduling of the INCLUDED item wait for scheduling of the KIT ,and this was working fine for customer , but now they stated that once in a while even the scheduling for KIT has not performed  and workflow for KIT is still at the HOLD activity (just before the scheduling activity) included item got scheduled.

During my analysis I found the for the the cases where the things are not working , some one navigate to the Sales Order and manually enter SCHEDULE SHIP DATE , and it is this Manually entering of the SSD that trigger the scheduling activity of the KIT and thus result in the scheduling of the INCLUDED item .Please Note that as soon as you enter the SSD it will trigger the scheduling ( even though the workflow of the line is not at the schedule activity ).

Advised customer to educate end user for same.

Delivery Number missing in Delivery LOV for Trip Stop

In Oracle Order Management we have option to run ITS for a

1. Trip #
2. Delivery#

But many a time Delivery # doesn't not appears in the Delivery LOV for Delivery # Parameter , even when delivery is not yet Interfaced. In such case try to populate Inventory Org Parameter for the ITS and then navigate back to Delivery # parameter and check if delivery # now appears in the Delivery LOV or not , if it still not appears then check if delivery has multiple legs or Single leg.

If Delivery has single and it still not appear in LOV , then best option is talk to Oracle Support /forum, but if delivery has multiple legs then expected behavior is and delivery # will not appear in Delivery LOV for ITS.

In nuttshell if delivery has multiple legs then it will not appear in the Delivery LOV ( for Delivery # parameter) for ITS concurrent Program

Back to Back Sales Order Process in Oracle Order Management (Oracle Applications).

This is short You Tube presentation that covers the Process flow for  B2B sales Order in Oracle Order management.
Topics that I will talk about here are -

1. Creation and Progress of back to Back to Back Sales Order.
2. When data from OM interfaced Requisition Interface tables.
3. Creation of Requisition and PO
4. Receiving Against PO and progress of Order line workflow to create data into Receivable Interface table.
5. Creation of vendor Invoice and Payment in Oracle Payables.

Trip is not appears in LOV for interface trip stop.

Many a time we don't see the trip name appears in the trip LOV of the ITS concurrent program even though trip is not yet interfaced.
Possible reason for this could be pending_interface_flag in the trip stop table doesn't have proper value. For trip name to appears in the LOV, pending interface column in the trip stop table should have value P , if it not then my suggestion is fire an update for the trip stop and set the value to to P


- Posted using BlogPress

B2B Sales Order Process Flow in Oracle Order Management

Back to Back Sales Order Process Flow in Oracle Order Management.(You Tube Presentation with Voice comming soon).

Script to drive Approver name from Oracle Approval Management (AME)

Below is script to drive the APPROVER name that is associated with a Quote.

API in this example drive the approver name from the list that AME(Oracle Approval Management ) module generate based in the Rules that we define in AME.

Note - Rules in AME are based on
Attribute
Condition
Action Type
Action
Approval group based on 

Declare
l_complete              VARCHAR2(1);
l_next_approvers        ame_util.approversTable2;
l_next_approver         ame_util.approverRecord2;
l_index                 ame_util.idList;
l_ids                   ame_util.stringList;
l_class                 ame_util.stringList;
L_Source                Ame_Util.Longstringlist;
Begin
   Ame_Api2.Getnextapprovers1(Applicationidin => 880,  --for Oracle Quote
                        Transactiontypein => 'Quote', --for Oracle Quotes
                        transactionIdIn => '17356',   -- Quote ID for which you want to check Approval
                        flagApproversAsNotifiedIn => ame_util.booleanFalse,
                        approvalProcessCompleteYNOut => l_complete,
                        nextApproversOut => l_next_approvers,
                        itemIndexesOut => l_index,
                        itemIdsOut => l_ids,
                        itemClassesOut => l_class,
                        Itemsourcesout => L_Source
                        );
  dbms_output.put_line('nextApproversOut = '||l_next_approvers(1).name);                     
End;

iphone ADF Mobile Browser app to creates sales order in Oracle Application.

This is very interesting post about iphone Mobile Browser App Created with Oracle ADF to creates sales order in Oracle Application.

Here we will discuss about

•  Oracle Mobile ADF Browser
• Demo of Simple Mobile Apps to Create Sales Order in Oracle Application with Mobile ADF Browser

 With Oracle ADF not only we can build Extensions for Oracle Applications but also build Mobile Apps for Oracle Application.There are 2 approaches to design mobile apps with ADF

• ADF Mobile Browser
• ADF Native Client

In this post I will explain about building appliaction with "ADF Mobile Browser"

ADF Mobile browser application is almost identical to ADF Web application development , except the ADF Mobile browser application development uses only mobile JSF pages that consist of Apache Myfaces Trinidad components. In this way we can re-use the desktop browser application’s model and controller layers to assemble a new view layer for mobile devices by using similar Apache MyFaces Trinidad Components.


More Info. about the ADF Mobile Browser are available in Below  Demo.  


--------------------
P.s - Yours commets are very much appreciated.
Free free to contact me for any enquires related to development to Mobile ADF Browser Application for Oracle Apps  at sgupta@eoracleapps.com

iphone Mobile Browser Application to create sales order

View more presentations from eoracle apps