Oracle Blogs

QUERY TO GET ALL INVENTORY ORGANIZATIONS IN OPERATING UNITS SELECT  LGR.NAME "Ledger"           ,   XLE.NAME "Legal Entity"           ,   HOU1.NAME "Operating Unit"        ,   HOU.NAME "Inventory Organization" ,   hou.organization_id,   MP.ORGANIZATION_CODE "Organization Code"    FROM HR_ALL_ORGANIZATION_UNITS HOU ,   HR_ORGANIZATION_INFORMATION HOI1    ,   HR_ORGANIZATION_INFORMATION HOI2    ,   MTL_PARAMETERS MP                   ,   GL_LEDGERS LGR                      ,   XLE_ENTITY_PROFILES XLE             ...

AIM : Update a field based on other fields or any other logic using server scripts  Groovy script  Groovyscript In this doc shows thw same using a exmple to SUPPLY CHAIN EXECUTION > QUALITY MANAGEMENT > QUALITY ISSUE In picture Based on yellow field we need to fill the green field Step 1 : Create a sandbox and enter into Applicaiton Composer Step 2 : Application Composer > ERP SCM cloud > Quality Issue > Server Scripts > Field Trigger script : if (QualityTypeName == "Non-Conformance - Work in Process") {     setAttribute("Workflow", 300000031016276) } else if (QualityTypeName == "Non-Conformance - Receiving") {     setAttribute("Workflow", 300000031016275) } you can find this workflow ids using report or using GET rest api /fscmRestApi/resources/11.13.18.05/qualityIssues/ Click save and close and publish the sand box.