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.
- Open Infor OS Portal’s navigation menu.
- In the Applications, select OS > Data Fabric.
- Select Data Lake > Compass
-
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')