ERP Fusion Cloud Cost Rollup Process using OIC via API's

-

 Cost Rollup

  • It is a process of adding all the cost of the underlying materials to obtain the total manufacturing cost per unit.
  • Using OIC, for this cost rollup, we have to first create the cost scenarios with the item numbers added into the same and then using the ERP ESS Scheduled job, we need to pass the Scenario Number to sum the costs i.e. Cost Rollup.
  • Below is the Payload for creating multiple cost scenario's with the item numbers added into it.
          REST API:- /fscmRestApi/resources/11.13.18.05/costScenarios

NOTE:- The structure of the below JSON payload is little bit different from the other REST API's in the ERP Fusion Cloud.
While testing in POSTMAN tool, just give URL as "https://<hostname>/fscmRestApi/resources/11.13.18.05"  as we giving "/costScenarios" in the body itself and under the headers section the key as Content-Type and value as "application/vnd.oracle.adf.batch+json"

{

"parts" : [

{

"id" : "part1",

"path" : "/costScenarios",

"operation" : "create",

"payload" :

{

"ScenarioNumber": "TEST3",

            "CostOrgName": "Orgname",

            "CostBookCode": "FQUI_US_HOL_PCB",

            "EffectiveStartDate": "2023-12-05",

            "ExplosionSequence": "PCN",

            "ExplosionBasis": "TOP_DOWN",

            "RollupScope": "SELECTED_ITEMS",

            "WorkDefName": "Main",

            "WorkDefinitionCriteriaDetails": [

{

"ItemNumber": "100099584"

}

]

}

},

{

"id" : "part2",

"path" : "/costScenarios",

"operation" : "create",

"payload" :

{

"ScenarioNumber": "TEST4",

            "CostOrgName": "Orgname",

            "CostBookCode": "FQUI_US_HOL_PCB",

            "EffectiveStartDate": "2023-12-05",

            "ExplosionSequence": "PCN",

            "ExplosionBasis": "TOP_DOWN",

            "RollupScope": "SELECTED_ITEMS",

            "WorkDefName": "Engineering and Pricing and Catalog Item Cost",

            "WorkDefinitionCriteriaDetails": [

{

"ItemNumber": "100099567"

}

]

}

}

]

}


Comments

  1. Index InfotechSeptember 7, 2024 at 5:23 AM

    Services that assist companies in assessing and utilizing their ERP software. You can also check out about erp solutions for small business here.

    ReplyDelete

Post a Comment

Popular posts from this blog

How to give NewLine feed to the text in OIC using xslt function

-
Image
The requirement here is , if you get from the source system the text with some delimiters for e.g. here in this case the delimiter used as ## to give uniqueness and we want the text to split into new line wherever you see '##' for that we can use the \n hexadecimal code as &#10; as shown below in OIC mapping. In this case, from source system we got input as below    '(J0D) BRAZILWOOD//(WE) BRAZILWOOD##Laminate Color:(J0D) BRAZILWOOD##Edge Color:(WE) BRAZILWOOD' Now here we want to replace '##' with the new line '\n', use the below code snippet according to your use case in order send the output to the target system.         <xsl: value-of select="translate ($GlobalVarConfigDetails,'##', '&#10;' )"/> Note:- After you use this expression in the mapping, at runtime you won't be able to see the text with new line. We have to go and check the target system there you will be able to see the exact result of this funct...
Read more

Oracle Fusion Cloud SCM REST and SOAP API's to use in OIC( Oracle Integration Cloud)

-
Below is the list of ERP Fusion Cloud REST  and SOAP API's to be used in sequence for the ERP Fusion Manufacturing Flow Item Creation  https://<<hostname>>/fscmRestApi/resources/11.13.18.05/itemsV2 Item Structure (BOM : Bill of Material) https://<<hostname>>/fscmRestApi/resources/11.13.18.05/itemStructures Work Definition Creation ( GET Operation Not Supported) https://<<hostname>>/fscmRestApi/resources/11.13.18.05/workDefinitionRequests PriceList https://<<hostname>>/fscmRestApi/resources/11.13.18.05/priceLists : Using this REST API, fetch the PricelistId to pass in the below REST API to create items in the ERP Fusion PriceList https://<<hostname>>/fscmRestApi/resources/11.13.18.05/priceLists/{PriceListId}/child/items Enterprise Sales Contract (SOAP API)   https://<<hostname>:<<port>>/fscmService/ContractServiceV2 To Create Enterprise Contract in ERP Fusion Cloud :- Operation : cre...
Read more