Posts in: SQL
ESS - Jobs Completed Last Hour With Success Message
Count ESS jobs completed successfully in the last hour.
Read More →ESS - Jobs Running or Cancelling More Than 24 Hours
Identify ESS jobs in running or cancelling state for more than 24 hours.
Read More →ESS - Jobs Failed Due to BIP
List ESS jobs that failed due to BIP errors with associated job URL.
Read More →Business Units
Retrieve all business units with relevant manager, ledger, and status details.
Read More →LEDG_LE_BU_INV_MFG_CST
Retrieve Ledger, Legal Entity, Business Unit, Inventory and Manufacturing organization details including cost organizations.
Read More →