Sunday, June 7, 2020

POWERSHELL SCRIPT TO STOP AND START VIRTUAL MACHINES


Command to start Virtual Machine:

Start AZVM -ResourceGroupName ResourceGroup -Name VMName


Command to start Virtual Machine:

Stop AZVM -ResourceGroupName ResourceGroup -Name VMName

Monday, May 4, 2020

EBS TABLES AND CORRESPONDING FUSION TABLES

EBS TABLE NAME

FUSION TABLE

PO_REQUISITION_HEADERS_ALL

POR_REQUISITION_HEADERS_ALL

PO_REQUISITION_LINES_ALL

POR_REQUISITION_LINES_ALL

PO_REQ_DISTRIBUTIONS_ALL

POR_REQ_DISTRIBUTIONS_ALL

PO_HEADERS_ALL

PO_HEADERS_ALL

PO_LINES_ALL

PO_LINES_ALL

PO_DISTRIBUTIONS_ALL

PO_DISTRIBUTIONS_ALL

RCV_TRANSACTIONS

RCV_TRANSACTIONS

PO_ACTION_HISTORY

PO_ACTION_HISTORY

RCV_SHIPMENT_HEADERS

RCV_SHIPMENT_HEADERS

RCV_SHIPMENT_LINES

RCV_SHIPMENT_LINES

AP_INVOICES_ALL

AP_INVOICES_ALL

AP_INVOICE_LINES_ALL

AP_INVOICE_LINES_ALL

AP_INVOICE_DISTRIBUTIONS_ALL

AP_INVOICE_DISTRIBUTIONS_ALL

AP_INVOICE_PAYMENTS_ALL

AP_INVOICE_PAYMENTS_ALL

AP_INV_APRVL_HIST_ALL

AP_INV_APRVL_HIST_ALL

AP_HOLDS_ALL

AP_HOLDS_ALL

AP_PAYMENT_TEMPLATES

AP_PAYMENT_TEMPLATES

IBY_ACCOUNT_OWNERS

IBY_ACCOUNT_OWNERS

IBY_DOCS_PAYABLE_ALL

IBY_DOCS_PAYABLE_ALL

IBY_EXT_PARTY_PMT_MTHDS

IBY_EXT_PARTY_PMT_MTHDS

IBY_EXTERNAL_PAYEES_ALL

IBY_EXTERNAL_PAYEES_ALL

IBY_PAYMENT_METHODS_TL

IBY_PAYMENT_METHODS_TL

IBY_PAYMENTS_ALL

IBY_PAYMENTS_ALL

PO_LINE_LOCATIONS_ALL

PO_LINE_LOCATIONS_ALL

AP_CHECKS_ALL

AP_CHECKS_ALL

AP_CARDS_ALL

EXM_CARDS

AP_PAYMENT_SCHEDULES_ALL

AP_PAYMENT_SCHEDULES_ALL

AP_PAYMENT_HIST_DISTS

AP_PAYMENT_HIST_DISTS

AP_PREPAY_APP_DISTS

AP_PREPAY_APP_DISTS

FA_CATEGORIES_TL

FA_CATEGORIES_TL

FA_FISCAL_YEAR

FA_FISCAL_YEAR

FA_ADDITIONS_B

FA_ADDITIONS_B

FA_ADDITIONS_TL

FA_ADDITIONS_TL

FA_ASSET_INVOICES

FA_ASSET_INVOICES

FA_RETIREMENTS

FA_RETIREMENTS

FA_BOOK_CONTROLS

FA_BOOK_CONTROLS

GL_LEDGERS

GL_LEDGERS

GL_PERIOD_STATUSES

GL_PERIOD_STATUSES

GL_PERIODS

GL_PERIODS

GL_DAILY_CONVERSION_TYPES

GL_DAILY_CONVERSION_TYPES

GL_DAILY_RATES

GL_DAILY_RATES

GL_DATE_PERIOD_MAP

GL_DATE_PERIOD_MAP

GL_PERIOD_SETS

GL_PERIOD_SETS

FINANCIALS_SYSTEM_PARAMS_ALL

FINANCIALS_SYSTEM_PARAMS_ALL

GL_COA_MAPPINGS

GL_COA_MAPPINGS

FND_APPLICATION

FND_APPLICATION

FND_FLEX_VALUE_SETS

FND_FLEX_VALUE_SETS

FND_FLEX_VALUES

FND_FLEX_VALUES

FND_FLEX_VALUES_TL

FND_FLEX_VALUES_TL

FND_ID_FLEX_SEGMENTS

FND_ID_FLEX_SEGMENTS

FND_ID_FLEXS

FND_ID_FLEXS

FND_LOOKUP_VALUES

FND_LOOKUP_VALUES

HR_ALL_ORGANIZATION_UNITS

HR_ALL_ORGANIZATION_UNITS

HR_LOCATIONS_ALL

HR_LOCATIONS_ALL

HR_LOCATIONS_ALL_TL

HR_LOCATIONS_ALL_TL

HZ_CONTACT_POINTS

HZ_CONTACT_POINTS

HZ_ORGANIZATION_PROFILES

HZ_ORGANIZATION_PROFILES

HZ_PARTIES

HZ_PARTIES

HZ_RELATIONSHIPS

HZ_RELATIONSHIPS

HZ_CODE_ASSIGNMENTS

HZ_CODE_ASSIGNMENTS

HR_ALL_ORGANIZATION_UNITS_TL

HR_ALL_ORGANIZATION_UNITS_TL

PER_ALL_ASSIGNMENTS_F

PER_ALL_ASSIGNMENTS_F

PER_ALL_PEOPLE_F

PER_ALL_PEOPLE_F

PER_PERIODS_OF_SERVICE

PER_PERIODS_OF_SERVICE

FND_USER

PER_USERS

FND_TERRITORIES

FND_TERRITORIES

XLA_EVENT_TYPES_B

XLA_EVENT_TYPES_B

XLA_EVENT_TYPES_TL

XLA_EVENT_TYPES_TL

XLA_EVENTS

XLA_EVENTS

ZX_RATES_B

ZX_RATES_B

PA_EXPENDITURE_COMMENTS

PJC_EXP_COMMENTS

PA_EXPENDITURE_ITEMS_ALL

PJC_EXP_ITEMS_ALL

PA_PROJECT_ASSET_LINES_ALL

PJC_PRJ_ASSET_LNS_ALL

PA_PROJECT_ASSETS_ALL

PJC_PRJ_ASSETS_ALL

PA_CLASS_CATEGORIES

PJF_CLASS_CATEGORIES_B

PA_CLASS_CODES

PJF_CLASS_CODES_B

PA_PERIODS_ALL

PJF_PERIODS_ALL

PA_PROJ_ELEMENT_VERSIONS

PJF_PROJ_ELEMENT_VERSION

PA_TASKS

PJF_PROJ_ELEMENTS_B TASK,
    PJF_PROJ_ELEMENTS_TL PPETL
WHERE
    TASK.PROJ_ELEMENT_ID = PPETL.PROJ_ELEMENT_ID AND PPETL.LANGUAGE = USERENV('LANG')

PA_PROJECT_ROLE_TYPES_B

PJF_PROJ_ROLE_TYPES_B A,PJF_PROJ_ROLE_TYPES_TL B
WHERE
A.PROJECT_ROLE_ID = B.PROJECT_ROLE_ID 

PA_PROJECT_ROLE_TYPES_TL

PJF_PROJ_ROLE_TYPES_TL

PA_PROJECT_CLASSES

PJF_PROJECT_CLASSES

PA_PROJECT_STATUSES

PJF_PROJECT_STATUSES_B A , PJF_PROJECT_STATUSES_TL B
 WHERE
A.PROJECT_STATUS_CODE  = B.PROJECT_STATUS_CODE

PA_PROJECT_TYPES_ALL

PJF_PROJECT_TYPES_B B,PJF_PROJECT_TYPES_TL TL
 WHERE B.PROJECT_TYPE_ID=TL.PROJECT_TYPE_ID 

PA_PROJECTS_ALL

PJF_PROJECTS_ALL_B B,PJF_PROJECTS_ALL_TL TL,PJF_PROJECT_TYPES_TL PT
 WHERE B.PROJECT_ID=TL.PROJECT_ID AND
PT.PROJECT_TYPE_ID=B.PROJECT_TYPE_ID 

PA_BUDGET_VERSIONS

PJO_PLAN_VERSIONS_B

PA_PROJECT_ACCUM_ACTUALS

PJO_PROJECT_PLAN_ACTUALS

PA_BUDGET_LINES

PJO_PLAN_LINE_DETAILS

AP_CREDIT_CARD_TRXNS_ALL

EXM_CREDIT_CARD_TRXNS

AP_EXP_REPORT_DISTS_ALL

EXM_EXPENSE_DISTS

AP_EXPENSE_REPORT_HEADERS_ALL

EXM_EXPENSE_REPORTS

AP_EXPENSE_REPORT_LINES_ALL

EXM_EXPENSES

AP_POL_VIOLATIONS_ALL

EXM_EXPENSE_VIOLATIONS

GL_ALLOC_RULESETS

GL_ALLOC_RULESETS

GL_ALLOC_RULES

GL_ALLOC_RULES

GL_ALLOC_RTP

GL_ALLOC_RTP

FND_RESPONSIBILITY_TL

PER_ROLES_DN_TL

PER_PERSON_TYPE_USAGES_M

PER_PERSON_TYPE_USAGES_M

PER_USER_ROLES

PER_USER_ROLES

PA_RESOURCE_ASSIGNMENTS

PJF_RBS_PRJ_ASSIGNMENTS

XLA_ACCOUNTING_ERRORS

XLA_ACCOUNTING_ERRORS

XLA_AE_HEADERS

XLA_AE_HEADERS

XLA_AE_LINES

XLA_AE_LINES

XLA_DISTRIBUTION_LINKS

XLA_DISTRIBUTION_LINKS

XLA_TRANSACTION_ENTITIES

XLA_TRANSACTION_ENTITIES

GL_IMPORT_REFERENCES

GL_IMPORT_REFERENCES

GL_JE_BATCHES

GL_JE_BATCHES

GL_JE_HEADERS

GL_JE_HEADERS

GL_JE_LINES

GL_JE_LINES

GL_JE_LINES_RECON

GL_JE_LINES_RECON

AP_SUPPLIER_SITES_ALL_A

POZ_SUPPLIER_SITES_ALL_M_

FA_BOOKS

FA_BOOKS

FA_DEPRN_PERIODS

FA_DEPRN_PERIODS

FA_ASSET_HISTORY

FA_ASSET_HISTORY

FA_DEPRN_DETAIL

FA_DEPRN_DETAIL

FA_DEPRN_SUMMARY

FA_DEPRN_SUMMARY

FA_DISTRIBUTION_HISTORY

FA_DISTRIBUTION_HISTORY

FA_TRANSACTION_HEADERS

FA_TRANSACTION_HEADERS

FA_ASSET_KEYWORDS

FA_ASSET_KEYWORDS

FA_ADJUSTMENTS

FA_ADJUSTMENTS

IBY_EXT_BANK_ACCOUNTS_A

IBY_EXT_BANK_ACCOUNTS_

IBY_EXT_PARTY_PMT_MTHDS_A

IBY_EXT_PARTY_PMT_MTHDS_

AP_SYSTEM_PARAMETERS_ALL

AP_SYSTEM_PARAMETERS_ALL

XLA_AE_LINE_ACS

XLA_AE_LINE_ACS

ZX_PARTY_TAX_PROFILE_A

ZX_PARTY_TAX_PROFILE