Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get Lineage/History table data using SQL?

Sunumol K SSep 18 2019 — edited Sep 24 2019

Hi,

How can i get the full Lineage/History table data of a spec using SQL?

I couldn't find an entry for action (Create New Copy) - "6" from SPECLINEAGEHISTORY table.

I have a spec with lineage history as below, the sql returns only 2nd row data, how can I get both the rows.

pastedImage_0.png

Thanks,

Sunu

Comments
Post Details
Added on Sep 18 2019
5 comments
79 views