Skip to main content
Question

NEXTVAL migration job find selected value

  • August 29, 2024
  • 1 reply
  • 81 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+10
  • NiyomalN
  • Hero (Partner)
  • 102 replies
  • September 24, 2024
SAKE wrote:

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
P
1 person likes this
  • P
    Pilar Franco

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings