BI Publisher (MOSC)

MOSC Banner

Update Each Record generated in data Model to table in database.

edited Mar 24, 2019 5:00AM in BI Publisher (MOSC) 4 commentsAnswered

Hi ,

When data Model generates a set of records , for each row generated , should join with table in database and update some columns in table

For Example :

Input Param1 ( values 'yes' or 'N')

param2 date

Id    code                reason

1       A                   REASON1

2       C                  REASON2

3       F                  REASON3

4       D                  REASON4

the above data is generated in data model , for each row of ID , should join with tableA using ID column and update each row of tableA.

please advice what is the best way to achieve.

Thanks

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