Showing posts with label Item Structures. Show all posts
Showing posts with label Item Structures. Show all 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 ========================================

query to get Shipment number based on Order number

 SELECT DISTINCT     wnd.delivery_name,     wnd.actual_ship_date,     wdd.sales_order_number FROM     wsh_new_deliveries       wnd,     wsh_...

Popular Posts