Skip to main content
Question

NEXTVAL migration job find selected value

  • August 29, 2024
  • 1 reply
  • 125 views
S
Sidekick (Customer)
Forum|alt.badge.img+6
  • SAKE
  • Sidekick (Customer)
  • 10 replies

Hi All,

We're developing a excel migration job for creation of parts.
We're using ENG_PART_MASTER_SEQ.NEXTVAL in this job.
We would like to see in the excel migration job what the number is.

So,  if we want to use the part after creating the part with the migration job, we don't have to search in IFS to find the created part_no.

Any idea's how to manage this?

 

 

 

1 reply

NiyomalN
Hero (Partner)
Forum|alt.badge.img+11
  • NiyomalN
  • Hero (Partner)
  • 104 replies
  • September 24, 2024

Hi All,

We're developing a excel migration job for creation of parts.
We're using ENG_PART_MASTER_SEQ.NEXTVAL in this job.
We would like to see in the excel migration job what the number is.

So,  if we want to use the part after creating the part with the migration job, we don't have to search in IFS to find the created part_no.

Any idea's how to manage this?

 

 

 

@SAKE What I would normally do is I will create a select statement using key values to fetch the sequence number to the child object. for example, you create the engineering part using the oracle sequence,  then in the child level I will write a select statement against the engineering part master window passing the part description and contract to fetch the sequence number .

 

hope this helps,

 

kind Regards!

Niyomal.

LinkedIn : www.linkedin.com/in/ niyomal-nathanielsz-18112341


Terms & ConditionsCookie settingsAccessibility statement