Showing posts with label REST API. Show all posts
Showing posts with label REST API. Show all posts

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

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

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