EGL9.2.Account Creation With Excel To CI Template ACCOUNT_CF Doesn't Check the Maximum Lenght Allowed By Standard Configuration Into PeopleSoft (Doc ID 2887182.1)

Last updated on AUGUST 02, 2022

Applies to:

Symptoms

When using ACCOUNT_CF Excel to CI to create a new account, the system is not checking the maximum allowed limit of Chartfield from Standard Configuration for account, allowing the user to enter a value with more characters than it is setup into the system.

Issue can be replicated by following the next steps :

1.Check the setup on Standard Configuration (Set Up Financials/Supply Chain>Common Definitions>   Design ChartFields >Define Standard Config and notice that the allowed length for account is 10 .

2.Change the length to 6 and save and click on Configure button and run the FS_CFCONFIG process

3.Go to Setup Fin>Common Definition >Design Chartfields>Define Values >Define Chartfield Value> Account and try to add a value for account with more than 6 characters in PSFT : -not allowed

4.Try to create a new account with Excel to CI| ACCOUNT_CF

5.Enter data in Data input tab – account value=12345678

6.Click on Add-ins and Stage Data for Submission

7.Choose Submit Data and enter user and password VP1

8.Status OK

9.Go and search for the value in PSFT and notice that is has been uploaded,not taking into consideration the limit setup in Standard Configuration!

Check the replication document attached.

Changes

Cause

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