Supplemental Information on Pricing Related Method in JP420000 and JP410000

Purpose of Document

This document is to give supplemental information on the implementation of business service on,

getCustomerItemPriceV2
getItemListPrice
getItemPriceAndAvailabilityV3

Note that you can access the detail method of published business service of JP420000 as below,

Go to <Document 1361438.1> Oracle JD Edwards Technical Catalog
Click Hyperlink for The Oracle Technical Catalog from above document (or, click here)
Agree to the disclaimer
Select the product "JD Edwards EnterpriseOne"
(Left Hand side panel) Additional Information > Business Interfaces - Review Business Services, Real Time Events and Batch
Search "JP420000" and click "Go", which returns below,

7. Click the Hyperlink on the first link of JP420000, which is "Pricing"

8. where the Business Object "Sales Order", which returns below methods

JP420000 - SalesOrderManager
- getCustomerItemPrice
- getCustomerItemPriceV2
- getItemListPrice
- getItemPriceAndAvailability
- getItemPriceAndAvailabilityV2
- getItemPriceAndAvailabilityV3
JP410000 - InventoryManager
- getItemPrice
- getSupplierCatalogPrice
- getSupplierCatalogPriceV2
- processSupplierCatalogPrice
- processSupplierCatalogPriceV2

However, Oracle Technical Catalog does not give you any implementation detail for above method. So this document is to guide you to detail mapping and example of request.

Published business service implementation guide. 1

69.2.13 getCustomerItemPriceV2. 2

69.2.11 getItemPriceAndAvailabilityV3. 3

Pre-requisite for testing above listed methods. 3

Information collected. 3

Request and response. 3

getCustomerItemPriceV2 (J4200040). 3

getItemListPrice (J4200060). 5

getItemPriceAndAvailabilityV3 (J4200030). 6

Business Method Flow Diagram.. 8

getCustomerItemPriceV2. 8

getItemListPrice (JP420000). 8

getItemPriceAndAvailabilityV3 (J4200030). 9

Methods to be explained

: Method description and flow chart for below methods (belongs to published JP420000)

getCustomerItemPriceV2
getItemListPrice
getItemPriceAndAvailabilityV3

Published business service implementation guide

Basic information:

Overview
Method	Description
getCustomerItemPriceV2 (J4200040)	Use this operation to retrieve item pricing for a specified customer, including the taxed prices and taxed amounts with line level discounts and/or markups using the base price or advanced pricing, from the JD Edwards EnterpriseOne Inventory Management system, when the Enable Sales Taxed Prices constant is selected. Note: There are several operations that provide item pricing information to the consumer. Use this operation to review item prices, including line-level discounts and markups, for specific customers.
getItemListPrice (J4200060)	Use this operation to retrieve a list of base prices from the JD Edwards EnterpriseOne Inventory Management system for a specified item. Note: There are several operations that provide item pricing information to the consumer. Use this operation to review base prices for specified items. This operation does not provide customer-specific prices or availability information.
getItemPriceAndAvailabilityV3 (J4200030)	Use this operation to retrieve item pricing and item availability information, along with GLN, from the JD Edwards EnterpriseOne Inventory Management system.

Note: this table is made using the Implementation guide as below,

Home / Applications / Oracle JD Edwards EnterpriseOne Applications Documentation, Release 9.2 / Cross-Product

|--- JD Edwards EnterpriseOne Applications Business Interfaces Implementation Guide (https://docs.oracle.com/cd/E64610_01/EOAAA/scm_sales_order.htm#EOAAA1280)

69.2.13 getCustomerItemPriceV2

Review the information in the getCustomerItemPrice section of this chapter before using the getCustomerItemPriceV2 web service operation. All of the information in the getCustomerItemPrice section also applies to getCustomerItemPriceV2.

getCustomerItemPriceV2 is a new version of the getCustomerItemPrice web service operation. This web service operation is used to retrieve the sales price of the item, including the taxed prices and taxed amounts with line level discounts and/or markups using the base price or advanced pricing, when the Sales Taxed Prices constant is selected. This new version executes the getCustomerItemPrice (J4200040) web service operation.

69.2.11 getItemPriceAndAvailabilityV3

Review the information in the getItemPriceAndAvailability section of this chapter before using the getItemPriceAndAvailabilityV3 web service operation. All of the information in the getItemPriceAndAvailability section also applies to getItemPriceAndAvailabilityV3.

The getItemPriceAndAvailabilityV3 operation is a version of the getItemPriceAndAvailabilityV2 web service operation. This web service operation is used to retrieve the sales price of the item, including GLNs, using the base price or advanced pricing for the specific branch plant and item availability. This version executes the getItemPriceAndAvailability (J4200030) web service operation.

Pre-requisite for testing above listed methods

Add a new customer
Add a new item
Added Adjustment Detail and attached it to the Adjustment Schedule to determine how it handles

Information collected

Copied request and response using soupUI 5.2.1
Retrieved jasdebug.log to verity methods gets called
Retrieved jdedebug.log to determine wrapper function to return requested values

Request and response

getCustomerItemPriceV2 (J4200040)

Request:

   <soapenv:Body>
      <orac:getCustomerItemPriceV2>
         <businessUnit>M30</businessUnit>
                  <agreementID>DMSCH</agreementID>
         <currencyCode>USD</currencyCode>
         <customer>
            <shipTo>
               <entityId>74242</entityId>
            </shipTo>
            <soldTo>
               <entityId>74242</entityId>
            </soldTo>
         </customer>
         <processing>
            <processingVersion>ZJDE0001</processingVersion>
         </processing>
         <product>
            <businessUnit>M30</businessUnit>
            <item>
               <itemCatalog>KOPI-O</itemCatalog>
               <itemUOMPrimary>EA</itemUOMPrimary>
            </item>
            <shipTo>
               <entityId>74242</entityId>
            </shipTo>
         </product>
         <transactionQuantity>100</transactionQuantity>
         <unitOfMeasureCodePricing>EA</unitOfMeasureCodePricing>
         <unitOfMeasureCodeTransaction>EA</unitOfMeasureCodeTransaction>
      </orac:getCustomerItemPriceV2>
   </soapenv:Body>

getItemListPrice (J4200060)

Request:

   <soapenv:Body>
      <orac:getItemListPrice>
         <businessUnit>M30</businessUnit>
         <currencyCode>USD</currencyCode>
         <customer>
            <entityId>74242</entityId>
         </customer>
         <item>
            <itemProduct>KOPI-O</itemProduct>
            <itemUOMPrimary>EA</itemUOMPrimary>
         </item>
         <unitOfMeasureCode>EA</unitOfMeasureCode>
      </orac:getItemListPrice>
   </soapenv:Body>

Example of query in BSSV server:

SELECT BPMCU,BPAN8,BPITM,BPUOM,BPLOTN,BPLOCN,BPLOTG,BPFRMP,BPEFTJ,BPEXDJ,BPCRCD,BPUPRC FROM PDCUR.F4106 WHERE ((((((BPMCU = ' M30' ) AND BPAN8 = 74242 ) AND BPITM = 764060 ) AND BPUOM = EA ) AND BPCRCD = 'USD' )) ORDER BY BPITM ASC

: this method returns value only when F4106 have a value with F4106.AN8.

getItemPriceAndAvailabilityV3 (J4200030)

Request:

   <soapenv:Body>
      <orac:getItemPriceAndAvailabilityV3>
         <adjustmentScheduleCode>DMSCH</adjustmentScheduleCode>
         <businessUnit>M30</businessUnit>
         <currencyCode>USD</currencyCode>
         <customer>
            <entityId>74242</entityId>
         </customer>
         <processing>
            <processingVersion>ZJDE0001</processingVersion>
         </processing>
         <product>
            <item>
               <itemProduct>KOPI-O</itemProduct>
               <itemUOMPrimary>EA</itemUOMPrimary>
            </item>
            <quantityOrdered>100</quantityOrdered>
            <unitOfMeasureCodeTransaction>EA</unitOfMeasureCodeTransaction>
         </product>
      </orac:getItemPriceAndAvailabilityV3>
   </soapenv:Body>

Note: The attachments contain response for above request.

Business Method Flow Diagram

getCustomerItemPriceV2

getItemListPrice (JP420000)

getListPrice

getItemPriceAndAvailabilityV3 (J4200030)

getItemPriceAndAvailbility

Note that above diagram is composed based on the request used above.