Skip to Main Content

Customer Solutions

Announcement

This area allows you to enter ideas for Oracle Utilities products. You can help promote an idea by:

  • Being as specific as possible about your request.
  • Clearly articulating the benefits. For example, reducing implementation effort or reducing cost to serve.
  • Calling out if you have seen this requirement from other utilities.
  • Voting for suggestions you think should be implemented.

Add FK Reference program info for Account Auto Pay, or an easy way to implement FK Ref info program using scripting/groovy

Bobot OrganistaMar 17 2026 — edited 4 days ago

FK Reference info string is mostly made for parent MO tables or config control tables. However, they do not support children tables with auto generated primary keys like CI_ACCT_APAY.ACCT_APAY_ID. At a particular client, they use a characteristic type for Autopay Id. Although the FK-type characteristic can be saved, it does not display a description because info programs are not supported for that table (only displays ‘No Foreign Key Reference information available’). On-prem projects can implement custom Java programs, but it is not possible with CCS.

Request product to implement an info program for an FK Refence to CI_AUTO_PAY (e.g., ‘AutoPayInfoRetriever’) to display - - , or a way via Scripting/Groovy to easily implement a new Info Program into an FK Reference.

We have tried using GenericMOInfoRetriever creating a custom MO with a custom Info algorithm but doesn't work.

Comments
Post Details
Added on Mar 17 2026
In Review
0 people have voted for this idea
0 comments
21 views