Reconciliation Update Stock Quantity (INPOPOST) Runs with Conversion Error: “From conversion rate/ To conversion rate must not be a Decimal” (Doc ID 2265903.1)

Last updated on MAY 15, 2017

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

When run Reconciliation Update Stock Quantity (INPOPOST Cobol process) the process finishes with error if previously the Item Counts can be saved in other UOM (EA) than the Default Stocking UOM (CS) that is defined as Decimal in Quantity Precision item setup. the error is < SQLRT: INVALID DBTYPE:"INPOPOST ORACLE >

The item setup is the following:
EA = Item Standard UOM defined Decimal in Quantity Precision for Ordering, Shipping and Stocking
BOX = 1.3333 EA defined Decimal in Quantity Precision for Ordering, Shipping only
CS = 4 EA Default Stocking UOM and defined Decimal in Quantity Precision for Ordering, Shipping

SO when run Cobol process INPOPOST in the Message Log appears the error message
“From conversion rate/ To conversion rate must not be a Decimal”.

Setup:
----------------------------
1. UOM decimal conversion
EA = Item Standard UOM defined Decimal in Quantity Precision for Ordering, Shipping and Stocking
BOX = 1.3333 EA defined Decimal in Quantity Precision for Ordering, Shipping only
CS = 4 EA Default Stocking UOM and defined Decimal in Quantity Precision for Ordering, Shipping

2. Setup Count Event
Inventory > Inventory Counts > Prepare Counting Event > Setup Counting Event (COUNT_SETUP1_INV)

Replication steps
-----------------------
1. Create Counting Event - INPCCREA Cobol SQL
Inventory > Inventory Counts > Prepare Counting Event > Create Counting Event
Cycle Count Option = Family
2. Run IN Event Creation – INPCCREA Cobol SQL
3. Create counting sheet - INS9051 sqr
Inventory > Inventory Counts > Prepare Counting Event > Create Counting Sheet
4. Create Counting Sheet - IN Counting Sheet INS9051 SQR Report
The results without errors.
5. Update Counting Event
Click on Search and Enter 10006C and click OK
Enter Count Qty = 19 CS defaults since is defined as Default Stocking UOM , but user is changed to EA – Item Standard UOM EA
Select EA instead of CS and save
6. Run Reconciliation Update Stock Quantity– INPOPOST Cobol SQL
Reconciliation process INPOPOST finished with error:

“From conversion rate/ To conversion rate must not be a Decimal”



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms