Importing Blank to Money Field Fails with Fatal Exception Occurred Empty String
(Doc ID 2571691.1)
Last updated on JANUARY 24, 2024
Applies to:
Oracle Agile Product Cost Management - Version 9.3.6.0 and laterInformation in this document applies to any platform.
Symptoms
Fails to import blank value to Money field with below error
Error
Fatal Exception occurred empty String
Steps
- Login to Java Client as admin user
- Goto Admin tab > Data Settings > Classes > Published Prices class > User Interface Tabs > Price Lines > Attributes, and enable Text01, Numeric01 and Money01 attributes
- Login to Web Client, and create Manufacturer Part MP0002 with Manufacturer Name: Oracle
- Do Actions > Create New > Price, and create new Published Price
PRICE00002. Set Supplier: MR00001 and Save - Open the created Price
- Goto Price Lines, and add Price Line with below Information:
Ship To: City A
Price Effective From: 2019/3/1
Price Effective To: 2019/3/2
Qty: 100
Currency Code: USD
Text01: 1
Numeric01: 2
Money01: 100 - Create Import data file with below header attributes and data:
Manufacturer Part: MP0002
Manufacturer: Oracle
Price Number: PRICE00002
Supplier: MR00001
Ship From: (Blank)
Ship To: City A
Qty: 105
Currency Code: USD
Text01: (Blank)
Numeric01:(Blank)
Money01: (Blank)
Effective From Date: 2019/3/1
Effective To Date: 2019/3/2 - Login to Web Client, goto Tools > Import
- Select the file created in step 7 as file to import
- Click Preference, and make sure Blank Data Action is set to "Overwrite"
- In the Specify File Content screen, select Published Price Lines, and Next
- Map all the attributes in the file
- For Redline Options, select "Update do not require redlining"
- Next, and Import
- Gets Error: Fatal Exception occurred empty String
- Open the import data file
- Input value to Money01 field, and save
- Run import again. This time import completes successfully.
However, unable to clear the Money01 field
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |