My Oracle Support Banner

EAR 9.2: Error Message (18,2) When Uploading Third Attachment File Under Customer Conversations (Doc ID 2681749.1)

Last updated on JUNE 19, 2020

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms


It has been detected that when trying to upload a third attachment file into a Customer's Conversations transaction, the system will throw Error Message (18,2) stating that the data being added into the system conflicts with existing one.

This happens since PeopleSoft Enterprise FSCM 9.2 Image #32 has been implemented. It used to work on prior Image levels.

REPLICATION STEPS:

    1.- Log into the FSCM Online Application as System Administrator User
    2.- Navigate to: Set Up Financials/Supply Chain > Common Definitions > File Attachments > Administer File Attachments
    3.- Ensure that the Pick Active Server drop down is pointing to a File Server Type of DB (Database)
    4.- Navigate to: PeopleTools > Utilities > Administration > URLs
    5.- Open the existing URL ID CUST_CONVER_ATT
    6.- In the URL ID field, place the value:    record://PSFILE_ATTDET
    7.- Navigate to: PeopleTools > Portal > Branding > Branding System Options
    8.- Ensure that the configuration defined is the below one:
            a) Default Branding Theme = DEFAULT_THEME_FLUID
            b) Theme Style Type = Classic Plus
            c) Default Style Sheet Name = PSSTYLEDEF_TANGERINE
    9.- Log out of the FSCM Online Application
    10.- Log into the FSCM Online Application as an Accounts Receivable User
    11.- Navigate to: Accounts Receivable > Customer Interactions > Conversations > View/Update Conversations
    12.- Find an existing Conversation transaction, and open it
    13.- Go to the Attachments tab (Page CONVER_DATA5_SS)
    14.- Proceed to upload one first file as an attachment, and save the changes
    15.- Proceed to upload a second file as an attachment, and save the changes
    16.- Finally, proceed to upload a third file as an attachment on this same Customer Conversation
    17.- The system throws an Error Message

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

ERROR MESSAGE:

    " Data being added conflicts with existing data. (18,2)
      When adding a new item to the database, the system found a conflicting item already exists.
      This problem can happen if another user has entered similar information at the same time as you.  Note the changes you have made, cancel the page, then retry your changes.
      If the problem persists, it may be because of an application or other programming error and should be reported to technical support staff.
      This error occurs when the keys on the record being inserted match a record that is already in the database.  The application must ensure that each inserted record has unique keys. "

Users are unable to upload more than 2 files as attachments on any given Customer Conversation, which prevents them from properly documenting disputes, and providing clarifications on the conversations maintained with customers.

The system should allow Users to upload as many attachment files as needed to properly document and support the conversations taking place.

NOTE: In the images/screenshots/examples mentioned and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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


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