My Oracle Support Banner

Freight Terms Lookup Code 'ORA_PREPAID_AND_CHARGE_BACK' Not Accepted By Supplier Sites File Upload Spreadsheet Or Interface (Doc ID 2400726.1)

Last updated on OCTOBER 22, 2019

Applies to:

Oracle Fusion Payables Cloud Service - Version 11.13.17.11.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.17.11.0 version, Performance

The standard oracle freight terms lookup code 'ORA_PREPAID_AND_CHARGE_BACK' is not getting accepted by Supplier Sites FBDI as it is more than 25 characters. The Freight terms field in the FBDI can only accept up to 25 characters. 

For those records the log file shows these error:


ERROR
-----------------------

Record 4: Rejected - Error on table POZ_SUPPLIER_SITES_INT, column FREIGHT_TERMS_LOOKUP_CODE.
ORA-12899: value too large for column "FUSION"."POZ_SUPPLIER_SITES_INT"."FREIGHT_TERMS_LOOKUP_CODE" (actual: 27, maximum: 25)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enter Freight Term Lookup code ORA_PREPAID_AND_CHARGE_BACK in Spreadsheet for Supplier Site File upload
2. Run the file upload for supplier

-> Ends in error for the record, message:

Record 4: Rejected - Error on table POZ_SUPPLIER_SITES_INT, column FREIGHT_TERMS_LOOKUP_CODE.
ORA-12899: value too large for column "FUSION"."POZ_SUPPLIER_SITES_INT"."FREIGHT_TERMS_LOOKUP_CODE" (actual: 27, maximum: 25)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot upload suppliers via the interface with correct freight terms

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
Cause
Solution


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