E1: 42: Unable to Prevent Intercompany (SI) Sales Order if Cost is Zero (P4210/P42101/R47011) (Doc ID 2826191.1)

Last updated on SEPTEMBER 26, 2023

Applies to:

Symptoms

Sales Order Entry (P4210 and P42101) does not return an error on a Sales Intercompany (SI) order if the Unit Cost on the Sales Detail Record (F4211.UNCS) is defaulted as zero.

The issue was reproduced in Oracle's Test environment with the following steps:

1. Create a new Item with two Item Branch Records (P41026)
   1. Canadian Branch 77
   2. US Branch M30
2. Create Item Base Price (P4106) records
   1. Canadian Base Price is 200 CAD
   2. No Base Price record created for US Branch
3. Item Availability Inquiry (P41202) shows inventory available in US Branch but not in Canadian Branch.
4. Create a Version of Sales Intercompany Order Entry (P4210)
   1. Order Type is SI
   2. Cost or Base Price Markup is 2 (Use Base Price)
   3. Intercompany Invoice is 1 (create intercompany invoice)
   4. Interbranch Order Type is SI
5. Create a Sales Intercompany Order with the Canadian Branch in the Header and the US Branch in the Detail.
   1. Notice the cost defaults as zero because a user forgot to create a base price record in the Detail Item Branch. Profit Margin for the Line is 100%.
      
      

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.