Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

Interactive Application Fail to Update Table After Alter Table

edited Feb 5, 2021 3:37AM in Design Tools & Output Technologies - JDE1 (MOSC) 3 commentsAnswered ✓

Hi Experts,


I've created an Interactive Application with EDIT button. This application using V554252A (F4211/F5542520)

Column for left join 92 between F4211 and F5542520 is DOCO, LNID and DCTO

Normally, when users click the EDIT button, ER logic will check is there a record exist in F5542520

If not exist, ER logic will insert into F5542520, else update the existing data as below :

// Check F5542520 by SO
VA frm_PickNoInt = 0
F5542520.Fetch Single
VA frm_StatusStr = "OPEN"
If VA frm_PickNoInt is equal to <Zero>
	// New
	Get Next Unique Key ID
	F5542520.Insert
Else
	// Edit
	F5542520.Update
End If

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