PL/SQL (MOSC)

MOSC Banner

Assignment Table After Statement trigger issue

edited May 19, 2020 5:03AM in PL/SQL (MOSC) 2 commentsAnswered

Hi,

We are having an odd issue and I thought I would check in here to see if anyone has had a similar problem and if there is a fix for it.

It happens when we try to set a future dated location on an assignment.

1) We set the after effective date value in EBS to the future value we want.

2) We change the location on the assignment we want and save the record.

3) So the old assignment record should have its effective_end_date updated and a new insert record should be created.

4) There are numerous triggers that fire but the important two are as follows

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