Request For Available Framework Component To Populate C2M Table D1_GTT4 Via Groovy Or Config Tools
(Doc ID 2553633.1)
Last updated on JUNE 02, 2022
Applies to:Oracle Utilities Customer to Meter Base - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Qn1:On : 18.104.22.168.0 version, Framework
Request for available framework component to populate C2M table D1_GTT4 via Groovy or Config Tools
User would like to consult if there is an existing framework component to populate C2M table D1_GTT4 via Groovy or Config Tools. User have a custom module that will utilize Global Temporary Table 4 (D1_GTT4) for list of SPs and Measurements. As per Groovy limitation, user can no longer insert records directly into database via SQL.
For C2M table D1_GTT1 (Global Temporary Table 1), there is an existing base Business Service D1-InsertMCsIntoGTT1 (Insert Constituent MCs into GTT1). Base Business Service D1-InsertItemsIntoGTT3 also exists for C2M table D1_GTT3 (Global Temporary Table 3).
Does C2M table D1_GTT4 has corresponding base business service?
Qn2:Currently we are testing population of D1_GTT1 table (base Business Service is existing) for a related functionality but after creating D1_GTT1 records, none seen in the SQL Developer for D1_GTT1 records. As per logs, D1_GTT1 records were added but not visible in the corresponding table via SQL Developer. Is this the expected behavior for using D1_GTT1 table?
Related to D1_GTT4, we would like to confirm if this is possible:
- Batch Extract 1 will add records in D1_GTT4 (e.g. via available post processing script)
- Batch Extract 2 will read records from D1_GTT4 to create a flat file extract. Will Batch Extract 2 can still read the records created by Batch Extract 1 in D1_GTT4 even they no longer have the same session? Kindly advise.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document