🧠 Oracle IAM User has more than one active API key - prod.logic.yaml🟢

• Contextual name: 🧠 prod.logic.yaml🟢
• ID: /ce/ca/oracle/iam/user-has-more-than-one-active-api-key/prod.logic.yaml
• Tags:
  • 🟢 Logic test success
  • 🟢 Logic with extracts
  • 🟢 Logic with test data

Uses

• 📗 Oracle IAM User
• 🔌 Oracle IAM User API Key - object.extracts.yaml
• 🔌 Oracle IAM User - object.extracts.yaml
• 🧪 test-data.json

Test Results 🟢

Generated at: 2026-05-02T12:07:25.703177926Z Open

Result	Id	Condition Index	Condition Text	Runtime Error
🟢	test1	✔️ 299	✔️ CA10O1__Oracle_IAM_User_API_Keys__r.count(COMPLIANT) > number(1.0)	✔️ null
🟢	test2	✔️ 300	✔️ otherwise	✔️ null
🟢	test3	✔️ 300	✔️ otherwise	✔️ null
🟢	test4	✔️ 199	✔️ extract('CA10O1__lifecycleState__c') != 'ACTIVE'	✔️ null

Generation Bundle

	File	MD5
Open	/ce/ca/oracle/iam/user-has-more-than-one-active-api-key/policy.yaml	00670D8F030C8F80A1FC40005A91C852
Open	/ce/ca/oracle/iam/user-has-more-than-one-active-api-key/prod.logic.yaml	A7DAB30DB4FC65725E3AD11784E07D2B
Open	/ce/ca/oracle/iam/user-has-more-than-one-active-api-key/test-data.json	631D80373263588B32C4AD5183E9B363
Open	/types/CA10O1__CaOracleIamUserApiKey__c/object.extracts.yaml	AA56F5592EB714844CCA7BC8D8BA5839
Open	/types/CA10O1__CaOracleIamUser__c/object.extracts.yaml	47F91526ED7905B2BD0F0545EF1BCEAA

Available Commands

repo-manager policies generate FULL /ce/ca/oracle/iam/user-has-more-than-one-active-api-key/prod.logic.yaml
repo-manager policies generate DEBUG /ce/ca/oracle/iam/user-has-more-than-one-active-api-key/prod.logic.yaml
repo-manager policies generate CAPTURE_TEST_DATA /ce/ca/oracle/iam/user-has-more-than-one-active-api-key/prod.logic.yaml
repo-manager policies generate TESTS /ce/ca/oracle/iam/user-has-more-than-one-active-api-key/prod.logic.yaml
# Execute tests
repo-manager policies test /ce/ca/oracle/iam/user-has-more-than-one-active-api-key/prod.logic.yaml

Content

Open File

---
inputType: "CA10O1__CaOracleIamUser__c"
testData:
  - file: test-data.json
importExtracts:
  - file: /types/CA10O1__CaOracleIamUser__c/object.extracts.yaml
conditions:
  - status: "INAPPLICABLE"
    currentStateMessage: "This Oracle IAM user is not active."
    check:
      NOT_EQUAL:
        left:
          EXTRACT: "CA10O1__lifecycleState__c"
        right:
          TEXT: "ACTIVE"
  - status: "INCOMPLIANT"
    currentStateMessage: "This active Oracle IAM user has more than one active API key."
    remediationMessage: "Delete redundant active API keys so only one remains for this Oracle IAM user."
    check:
      GREATER_THAN:
        left:
          RELATED_LIST_COUNT:
            status: "COMPLIANT"
            relationshipName: "CA10O1__Oracle_IAM_User_API_Keys__r"
        right:
          NUMBER: 1.0
otherwise:
  status: "COMPLIANT"
  currentStateMessage: "This active Oracle IAM user has no more than one active API key."
relatedLists:
  - relationshipName: "CA10O1__Oracle_IAM_User_API_Keys__r"
    importExtracts:
      - file: /types/CA10O1__CaOracleIamUserApiKey__c/object.extracts.yaml
    conditions:
      - status: "COMPLIANT"
        currentStateMessage: "This Oracle IAM API key is active."
        check:
          IS_EQUAL:
            left:
              EXTRACT: "CA10O1__lifecycleState__c"
            right:
              TEXT: "ACTIVE"
    otherwise:
      status: "INAPPLICABLE"
      currentStateMessage: "This Oracle IAM API key is not active."