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

Query to Get PO Header , PO Lines , PO Schedules and po distribution details

SQL Query to Get PO Header , PO Lines , PO Schedules and po distribution details 

SELECT DISTINCT

    poh.po_header_id,

    poh.segment1 AS po_number,

    pol.po_line_id,

    pol.line_num,

    pol.item_id,

    pol.quantity line_quantity,

    pod.po_distribution_id,

    pod.distribution_num,

    pod.quantity_ordered,

    pll.quantity schedule_qty,

    pll.need_by_date,

    pll.promised_date,

    pll.requested_ship_date

FROM

    po_headers_all        poh,

    po_lines_all          pol,

    po_distributions_all  pod,

    po_line_locations_all pll

WHERE

        pol.po_header_id = poh.po_header_id

    AND pod.po_line_id = pol.po_line_id

    AND pll.po_line_id = pol.po_line_id

    AND pod.line_location_id = pll.line_location_id and poh.segment1 =:PURCHASE_ORDER_NUMBER ORDER BY poh.segment1

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 ========================================

Sample Request Payload to Create Work Defintion Request In Oracle Fusion 25D

Sample Payload to Create Work Definition In Oracle Fusion.Request Payload JSON.{

    "SourceSystemType": "EXTERNAL",

    "workDefinitionHeaders": [{

            "ActionCode": "CREATE",

            "ItemNumber": "XX-yy-P7-",

            "OrganizationCode": "102",

            "VersionNumber": 101,

            "WorkMethodCode": "DISCRETE_MANUFACTURING",

            "WorkDefinitionCode": "ORA_MAIN",

            "ItemStructureName": "Primary",

            "operations": [{

                    "ActionCode": "CREATE",

                    "OperationSequenceNumber": 10,

                    "AutoTransactFlag": "N",

                    "ReferencedFlag": "N",

                    "StandardOperationCode": "test_WIP",

                    "OperationType": "IN_HOUSE"

                }

            ],

            "resources": [{

                    "ActionCode": "CREATE",

                    "ResourceSequenceNumber": 10,

                    "OperationSequenceNumber": 20,

                    "ResourceCode": "test_OVERHEAD_RES",

                    "UsageRate": 90.9,

                    "AssignedUnits": null,

                    "BasisType": "1",

                    "UsageRate": null,

                    "PrincipalFlag": false,

                    "ScheduledIndicator": "NO",

                    "PrincipalFlag": null

                }

            ],

            "materials": [{

                    "ActionCode": "CREATE",

                    "MaterialSequenceNumber": 10,

                    "OperationSequenceNumber": 10,

                    "AdhocItemFlag": "false",

                    "ItemNumber": "yy-4-C2-",

                    "Quantity": 50,

                    "InverseQuantity": "0.02",

                    "SupplyType": "1",

                    "SupplySubinventory": "WP-WIP",

                    "SupplyLocator": "WIP-WP-00-00-00",

                    "YieldFactor": "",

                    "FindNumber": "1"

                }

            ]

        }

    ]

}

===  ===  ===  ===  ===  ===  ===  ===  ===  ===  ===  ===  ===

 Request URL -  http:/{FUSION_URL}/ fscmRestApi / resources / 11.13.18.05 / workDefinitionRequests ===  ===  ===  ===  ===  ===  ===  ===  ===  ==