PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

ExcelToCI Load with blank keys that are not required

edited Aug 2, 2011 4:37AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 5 commentsAnswered
I am trying to load two tables BN_RATE_TBL and BN_RATE_DATA using ExcelToCI.  BN_RATE_DATA has 5 key fields RATE_TBL_ID, EFFDT, BN_RATE_KEY01, BN_RATE_KEY02, BN_RATE_KEY03.  I can add a new rate id using Create and a I can add a new effdt row using Update but I cannot update an existing row of data when BN_RATE_KEY01, 02 AND 03 are blank.  The component allows these key fields to be blank when the rate type = 2, Flat Rate Table.  When I try to update an existing row that has those these key fields blank, I get "No key match was found for collection BN_RATE_DATA". 

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