Physical Inventory FBDI Errors out when entering a value in Asset Location. (Doc ID 2573067.1)

Last updated on FEBRUARY 08, 2024

Applies to:

Goal

Receiving error message Invalid Whole Number when entering values in fields Asset Location Segments 1-6 and Employee Email Address.

When tried to upload the data using FBDI sheet
https://docs.oracle.com/en/cloud/saas/financials/19a/oefbf/Physical-Inventory-Interface-314223061-fbdi-32.html
FixedAssetPhysicalInventoryTemplate.xlsm  --
Getting the error Invalid Whole number when entering values in Asset Location
and the error is
"Please enter a positive whole Number"
STEPS TO REPRODUCE
==================
Download FBDI sheet for Physical Inventory  https://www.oracle.com/webfolder/technetwork/docs/fbdi-19a/fbdi/xlsm/FixedAssetPhysicalInventoryTemplate.xlsm
and try to enter a value for Asset location and one can see the error "Please enter a positive whole Number".

EXPECTED BEHAVIOR
=================
One should be able to enter the Location Segment Value

BUSINESS IMPACT
===============
Errors out and customer has to remove the data validation in order to enter
the value

Solution

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