PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Error adding new item to database in an empty table.

Campus solution 9.20.025

PeopleTools 8.56.14

Database Type: MS SQL Server


I am very new to PS development. I am creating a very simple component with single effective dated table described here. I have creaed a page where the field CODE is at level 0 and remainder of the fields are in a scroll at level 1. The component search record is MyTable.

MyTable

CODE     -- KEY 1, Searchable = Y.

DESCRIPTION

EFFDT    -- KEY 2, Searchable = N. Default = %date

EFF_STATUS -- Default value 'A'


To add a new record, I use the 'Add New Value' tab on the Search page which brings me to the page I created to enter decription, effdt, and status. I enter description and leave the defaults for the effective date (1/1/1901) and status (A). When I hit save, I get 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... " whenver I am creating a new code. It happens even when MyTable is emply and there are no rows in it.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center