Bind Variables Is Displayed As Duplicate Row After Pressing Manage Dependencies Icon on Some Parameter of ESS Job (Doc ID 2960391.1)

Last updated on JULY 10, 2023

Applies to:

Symptoms

On Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications task, when opening existing ESS Job's Job Definition window, press Cancel button.

Later, on Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications task, go back to Manage Job Definitions and press Edit button for the same ESS Job. Press Manage Dependencies icon on some parameter.

The Bind Variables will be displayed as duplicate row.

Steps
1. Setup and Maintenance > Task > Search

Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications

2. Manage Job Definitions > Create

Display Name : TEST_ESS_0831
Name : TEST_ESS_0831
Path : /oracle/apps/ess/custom/
Description : TEST_ESS_0831
Job Application Name : FscmEss
Job Type : BIPJobType
Report ID : /Custom/Supply%20Chain%20Management/TEST/TEST_ESS_BIP_TESTXDO1_REPORT.xdo

Enable submission from Scheduled Processes : check

3. TEST_ESS_0831: Parameters > Create

Create Parameter

Parameter Prompot : Parameter 1
Data Type : String
Page Element : Choice List
List of Values Source : ArLookupPVO
Attribute : LookupCode
Derived Attributes

View Attribute List Attribute
----------------------------------
Parameter 1          LookupCode

Display Attributes

Selected Attributes
----------------------------
LookupCode

Required : check

==> Save and Close
==> Save and Close

4. Search : TEST_ESS_0831
5. Edit
6. Click TEST_ESS_0831: Parameters > Parameter 1
7. Click Manage Dependencies icon
8. Manage List of Values Dependencies appear.

Parameter Prompt : Parameter 1
List of Values Source : oracle.apps.financials.receivables.publicView.ArLookupPVO
View Criteria Name

Selected View Criteria : MatchLookupCodeVC <==== Move this from Available View Criteria

Bind Variables

View Criteria Name          Bind Variable Name Default Value
----------------------------------------------------------------------------
MatchLookupCodeVC        lookupCode             'XXJAF_YES_NO'

==> Add Default Value as 'XXJAF_YES_NO'
==> Press OK button
==> Save and Close

9. Go back to

Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications

On Manage Job Definitions

Click : TEST_ESS_0831

and press Edit button

10. Click TEST_ESS_0831: Parameters > Parameter 1
11. Click Manage Dependencies icon
12. Confirm Bind Variables. Only 1 row. Click OK.

Bind Variables

View Criteria Name    Bind Variable Name   Default Value
----------------------------------------------------------------------------
MatchLookupCodeVC  lookupCode              'XXJAF_YES_NO'

13. On Edit Job Definition window for TEST_ESS_0831, press Cancel button
14. On

Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications

Manage Job Definitions

Click : TEST_ESS_0831

and press Edit button

15. Click TEST_ESS_0831: Parameters > Parameter 1
16. Click Manage Dependencies icon
17. Confirm Bind Variables. 2 duplicate row appears. Click OK. (Issue is reproduced)

View Criteria Name    Bind Variable Name   Default Value
----------------------------------------------------------------------------
MatchLookupCodeVC  lookupCode              'XXJAF_YES_NO'
MatchLookupCodeVC  lookupCode              'XXJAF_YES_NO'

Cause

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