Clearing Compass tables cache

Run the infor.clear_table stored procedure to clear the Compass object definition for the specified objects. This stored procedure is used to clear Compass when the object's metadata definition in the Data Catalog has been updated.
Note: This step is not applicable for Infor Government Solutions (IGS) customers. Compass query feature is not yet supported in the IGS environment.
  1. Open Infor OS Portal’s navigation menu.
  2. In the Applications, select OS > Data Fabric.
  3. Select Data Lake > Compass
  4. Copy each command and click Run Query.
    EXEC INFOR.CLEAR_TABLE('FSM_Account', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_AssociatedItem', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_AutoMatchResultInvoice','True') 
    EXEC INFOR.CLEAR_TABLE('FSM_AutoMatchResult','True') 
    EXEC INFOR.CLEAR_TABLE('FSM_BankStatement', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_BankStatementLine', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_Buyer', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_CashCode', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_CashLedgerGLDistribution', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_CashLedgerPayablesPayment', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_CashLedgerPayment', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_CashLedgerTransaction', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_CashManagementAccount', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_CashManagementLocation', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_CashTransactionCategory', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_ClosePeriod', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_ClosePeriodTask', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_CloseTask', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_Contract', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_ContractLine', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_ContractLineDistribution', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_ContractLineMember', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_ContractTierMember', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_ContractTierQualifier', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_Employee', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_FinanceTeamMember', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_FinancialInstitution', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_FinancialInstitutionBranch', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_GeneralLedgerCalendarPeriodXref', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_IIHItemLocation', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_InventoryCompany', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_InventoryLocation', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_InventoryLocationAccountGroup', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_InventoryTransactionLine', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_InventoryTransactionLineDetail', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_InventoryTransactionLineDistribution', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_InventoryUsageHistory', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_InvoiceRoutingCode', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_InvoiceRoutingCodeResource', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_Item', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_ItemGTIN', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_ItemLocation', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_ItemReplenishmentSource', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_MatchInvoiceMessage', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_PayablesCompany', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_PayablesInvoice', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_PayablesInvoiceAudit', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_PayablesInvoiceDetail', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_PayablesInvoiceDistribution', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_PayablesInvoicePayment', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_PayablesInvoiceTax', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_PayablesOnHold','True') 
    EXEC INFOR.CLEAR_TABLE('FSM_PurchaseOrder', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_PurchaseOrderBuyerMessage', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_PurchaseOrderLine', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_PurchaseOrderLineDistribution', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_PurchaseOrderLineDistributionDetail', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_PurchaseOrderLineSource', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_PurchaseOrderReceiptLine', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_PurchaseOrderReceipt', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_PurchaseOrderRevision', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_RequestingLocation', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_Requisition', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_RequisitionLine', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_RequisitionLineDistribution', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_Supplier', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_SystemCalendarDate', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_TaskReasonCodeUsage', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_Vendor', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_VendorAddress', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_VendorItem', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_VendorReturnLine', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_VendorReturn', 'True')
    EXEC INFOR.CLEAR_TABLE('FSM_VendorReturnLineDistribution', 'True')