E1: ORCH: Logic Extension - How To Update Specific Records In an E1 Table Using Table I/O For Multiple Rows Based On a Specific Condition (Doc ID 3015124.1)

Last updated on APRIL 05, 2024

Applies to:

Goal

How to fetch multiple records (detail) from a table based on a grid data field (e.g. Effective Date), loop through the data and update the field based on certain criteria.

For Example: 

• Fetch Bill of Material records in F3002. 
• Some BoM has multiple rows and each detail has an EffectiveThruDate field. 
• Based on the EffectiveThruDate (EFFT), update/preserve the data. 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.