Popular Posts

Thursday, November 13, 2025

Sample Postman call to expand the Components and filter only active components under a work structures

Requirement is to get the Only active components that means item structures having active components .


 https://{instance-url}/fscmRestApi/resources/11.13.18.05/itemStructures?q=OrganizationCode =28102 and StructureName='Primary' and ItemNumber='FD-0506-TD-' and Component.EndDateTime =''&expand=Component





and also we need to add below custom header -

REST-Framework-Version =4



Monday, November 3, 2025

Sample Request Payload to Create Item Structure in Oracle Fusion 25D.

============Request Payload============== { "OrganizationCode" : "28102", "ItemNumber" : "Item_Main", "StructureName" : "Primary", "EffectivityControl" : 1, "EffectivityControlValue" : "Date", "Component" : [ { "ComponentItemNumber" : "Comp_item1", "ItemSequenceNumber" : 10, "FindNumber" : 1, "Quantity" : 50 } ] } ======================================== Request Url: /fscmRestApi/resources/11.13.18.05/itemStructures ======================================== Operation Name : POST ========================================

SQL to Get dates missing in a table for given date range

 WITH all_dates AS (     SELECT DATE '2025-01-01' + LEVEL - 1 AS dt     FROM dual     CONNECT BY LEVEL <= (DATE '2026-01-01...