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, 2024

Applies to:

Goal

Qn1:On : 2.6.0.1.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.
 

Solution

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