• Kaushik Sivakumar
    Topic posted June 19, 2019 by Kaushik SivakumarGreen Ribbon: 100+ Points, tagged Manufacturing MDM, Manufacturing Analytics, Production Execution, Production Scheduling, Public Sector, Tip, White Paper, Work Execution, Work Request Management in Manufacturing & Maintenance > Manufacturing public
    FAB August 19th & 20th @ Oracle HQ
    If you are a PARTNER and have not received and invitation from us for our annual MAINTENANCE & MANUFACTURING FIELD ADVISORY BOARD (FAB) and are interested in attending - please email me:
    We are hosting this event August 19th & 20th, 2019 @ Oracle HQ.  There is no fee but as a partner - you must have a valid Partner Participation Confidentiality Agreement (PPCA) in place.
    Please see the attached DRAFT agenda for more information and let me know if you have any questions.
    Hope to see you in August!
  • Al Satchu
    Whitepaper - Retrieving Multi-Row Attributes for an Item in...
    Topic posted Yesterday by Al SatchuBlue Ribbon: 750+ Points, tagged Configurator, Tip, White Paper in Order Management > Configurator public
    Whitepaper - Retrieving Multi-Row Attributes for an Item in PIM using a CX

    Currently, Configurator Cloud does not have support for multi-row attributes that may be defined for a particular model or its components upon import from PIM into the Configurator Modeling Environment. This document describes a simple approach to retrieve all the attributes defined for an item in PIM using a CX. The example provided in the document is just that and is not meant for production use. The sample code takes the Item Name for an item defined in PIM as an input and returns all the item attributes for the item, including multi-row attributes. Customers can use this sample code as a starting point for retrieving item attributes and using them within a CX rule to satisfy their specific modeling requirements.

  • aqil shaik
    Color Gradient of Heat Map2
    Topic posted July 17, 2019 by aqil shaik, tagged How-to, Tip, User Experience in Supply Chain Planning and Collaboration public
    Color Gradient of Heat Map
    Heat Map


    We are trying to setup data to show the few competing items in the Infotile 'Shipment History Comparison'. which comapres the Final Shipment History with Shipment History 1 yr ago.

    We are seeing the Volume ( Size) of the heat map area ..correctly indicated. However I wanted to undersatdn the Color gradient. Is the darker color change with respect to itself. example

    A) if the Final  shipment history last 12 month is 100K and the SHipment History 1 Yr ago is 75K.

    B) IF the Final  shipment history last 12 month is 500 K and the SHipment History 1 Yr ago is 350 K.

    Which color gradient will be darker? A or B? I was expecting the Option  A to be deeper as it is the % difference that should be counted.

    Is my understanding correct? What is your experience understanding the color gradient? Thanks

    What is the difference between the qualification and...1
    Topic posted July 17, 2019 by DIEGO SCHENQUERMANBlue Ribbon: 750+ Points, tagged Assessment, FAQ, How-To, Initiative, Qualification, Qualification Area, Qualification Model, Qualification Question, Qualification Rule Set, Questionnaire, Questionnaire Response, Tip, White Paper in Procurement > Supplier Qualification Management public
    What is the difference between the qualification and assessment?
    What is the difference between the qualification and assessment?

    What is the difference between the qualification and assessment?

    We want to use Procurement Qualification module to create initiative and request some information and document to update the supplier Profile. This is for an existing suppliers. I will not use this for Supplier Registration or Qualification. Just to request income tax information, bank account information etc.

    I am not sure if I need to use the Initiative with Qualification or Assessment.

  • Kelly Cooper
    SCM – Implementing Maintenance Programs: Tips and Best P...
    Topic posted July 16, 2019 by Kelly CooperGold Trophy: 10,000+ Points, tagged Asset Master Data Management, Maintenance Analytics, Preventive Maintenance, Safety Management, Tip in Manufacturing & Maintenance > Maintenance public
    SCM – Implementing Maintenance Programs: Tips and Best Practices, 25 July 2019, 9 a.m. PT - Submit Questions

    Submit your questions for the SCM –  Implementing Maintenance Programs:  Tips and Best Practices session to have them answered during the live event. Post your questions by posting a new comment to this topic.

    Please submit your questions by Wednesday, 24 July 2019.

  • Ramesh Choudhary
    Question: Considerations while implementing Standalone Sales...1
    Topic posted July 16, 2019 by Ramesh ChoudharyRed Ribbon: 250+ Points, tagged Demand Management Cloud, How-to, Planning Central Cloud, Sales & Operations Planning Cloud, Supply Chain Collaboration Cloud, Supply Planning Cloud, Tip, User Experience in Supply Chain Planning and Collaboration public
    Question: Considerations while implementing Standalone Sales & Operation Planning (S & OP)
    Question: Considerations while implementing Standalone Sales & Operation Planning (S & OP)

    Hi All,

    We are going to start implementing the Standalone Sales & Operation Planning Module (S & OP) .
    Can anyone please give us brief on how do we start this type of implementation.

    What all are the considerations which we should look into when we starting the implementation and what all resources/FBDI Files/Docs which are to be used for implementing the Standalone S & OP?

    Any best practices ?

    Your advise on this will be great help to us.


  • Amar
    SQL script for Roles , Privileges, Inherit roles & Data...Answered3
    Topic posted July 15, 2019 by AmarRed Ribbon: 250+ Points, tagged BI Publisher, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    SQL script for Roles , Privileges, Inherit roles & Data Security Policies
    SQL script for Roles , Privileges, Inherit roles & Data Security Policies

    Trying to built a query to fetch Application Roles, Privileges, Data Security & Role Hierarchies, where i am able to get roles and their privileges but could not able to fetch the data security policies & roles inherited.

    I have tried using the application security tables ASE_ROLES_V, ASE_ROLE_ROLE_MBR, ASE_PRIV_ROLE_MBR, ASE_PRIVILEGE_VL, also not able to view data from data model.




  • Ashok
    Tip: Requisition Fund Status in IMT Flows upon receiving the...15.0
    Topic posted July 14, 2019 by AshokGold Crown: 30,000+ Points, tagged Budget/Encumbrance, FAQ, Tip in Procurement > Self Service Procurement public
    Tip: Requisition Fund Status in IMT Flows upon receiving the item
    Requisition Fund Status in IMT Flows upon receiving the item

    Customers / Support

    I have seen a reasonable number of questions around this tip which is why I wanted to provide a quick reminder of how Funds Status operates in the context of Internal Material Transfer (IMT) flows.

    Business Flow:

    The customers in this case wanted to know if there was a bug in the system where the Funds Status on the Requisition never changed to Liquidated from Reserved even after the goods were received. The context of this concern were IMT flows.


    My colleague Mara provided the clarification that I think is quite useful to know the next time this question arises in anyone's mind or if Support gets asked this question in SRs:


    In the internal material transfer flow you won't see the funds status change from Reserved to Liquidated in the requisition pages. 
    This is because Inventory is not supporting budgetary control at the moment. However, Cost Management handles budgetary control and encumbrance accounting processing of the expenditure after final delivery for requisition sourced transfer orders. 

    In the Budgetary Control workarea you should be able to see the budget impact with the report Review Budgetary Control Transactions. There should be an entry for the expenditure created by Costing, which will mean that the corresponding commitment in the requisition is released/liquidated. 


  • Joydeepta Bhattacharjee
    Kubernetes on Oracle OCI OKE : Quick Developer handouts1
    Topic posted July 13, 2019 by Joydeepta Bhattacharjee, tagged Containers, Docker, Kubernetes, Registry, Tip in Infrastructure > Containers and Kubernetes public
    Kubernetes on Oracle OCI OKE : Quick Developer handouts
    This would be constant effort to derive a ideal architecture and reference to derive a K8 MSA architecture with side car facilities like service mesh etc. for developers and architects to relate to Op

    In preparation of Oracle Cloud Infra based Micro-services platform with Kubernetes as a reference standpoint , trying to consolidate salient steps to built a resilient MS architecture. We can explore setting up Istio sidecar implementation as well with this for better governance and delivery but this tutorial would be more focused from developer angle hosting a consistent infrastructure to create development environment with 2 worker nodes of considerable size for hosting multiple containers. Below is a basic block diagram for creating a Kubernetes Infrastructure. To understand more on detail of Istio over OKE please refer the attached link

    The installation can also be done with clear articulated steps as per Helm Charts which helps to bundle and install almost all the required components.

    Now, based on the understanding of the current version of OKE provisioned we could architect a below reference diagram of Kubernetes over OCI stack. The OCI Image Registry would contained the build docker images of the app to be pulled into the Kubernetes PODs during runtime while bringing the containers up and running, On left the control plane has been shown with Master node showing up the api server, etcd database to store runtime information of pods and scheduler which are the internal components and have been incorporated as the Kubernetes release by community. On right hand side we have data plane to host application containers and services managed by Kubectl tool as the Worker nodes. We have provisioned only two worker nodes in OCI OKE with optimum sizing to host a minimal spring boot based micro service app. The default Ingress Load-balancer also shipped as part of Kubernetes. The API server inbuilt as part of Master Node architecture is responsible for routing the requests from outside the Kube cluster to the pods through the scheduler selected by the runtime on basis of present snapshot in etcd store.

    As a part of side car features there could be extra installation and configuration service mesh like Istio or monitoring tools like Prometheus and Grafana etc. These are all open source tools supported by Kubernetes community and provides lots of interesting features which also can be articulated in due time. Kubernetes has become a breakthrough inception for container orchestration with large set of features and capabilities and many vendors like Azure, Amazon, Oracle has started embracing and slowing maturing their stacks in a phenomenal diversification. Container orchestration has become very important in cloud fraternity to adapt to horizontal scaling, fault tolerance, automation and what more, The OCI native monitoring capability along with Kubernetes dashboard to configure metric and alters is also going in an interesting turn around to combine bare metal computation capability of vendor with global community driven Ops stack with many native options. IT is advisable to provision both the master and workers across multiple AD’s to give better availability and redundancy as well within a region for a Compartment assigned to the OCI account of customer. In fact as Oracle document quotes below “To ensure high availability, Container Engine for Kubernetes creates the Kubernetes Control Plane on multiple Oracle-managed master nodes (distributed across different availability domains in a region where supported).”

    Steps to Provisioning VM & configure workers and other basic installations:

    Document link from Oracle is pretty straight forward to create OCI OKE cluster

    Steps to Configure the OKE cluster:

    To create a cluster, you must either belong to the tenancy's Administrators group, or belong to a group to which a policy grants the CLUSTER_MANAGE permission.

    Once the cluster gets configured with all default setup we are now ready to create and deploy a service instance in the pod through the Master node of OCI OKE cluster. We can leverage Developer cloud services to build the code, create the docker image of the spring boot code from Job definition in CI-CD pipeline in Developer Cloud. Before that we would also create a deployment or pod definition configuration file in .yml which would finally been loaded approximately in a dockerized solution.

    Now lets go in detail to help creating the pods from the My-Services from a OCI Navigation in left and connect to the developer cloud services provisioned from console. The developer cloud services with current release has been a phenomenal to create a complete native pipeline to build both spring boot rest api and UI services , create images and then deploy in OKE clusters configured with it's cloud native Jobs configured. A typical JOB configured in the cloud native build pipeline has steps which can be configured from console for docker login, maven build , docker build and push image to Registry. I am not aware if Oracle still allows to integrate 3 rd party registry which is needed for interoperability between various cloud vendors.

    Once the image is built and pushed successfully versioned in the Image repository , the next step in the pipeline is to review the yaml in git for deployment and pod creation specific to Kubernetes shipped to specific Kubernetes vendor. The Kubernetes tooling has already been installed in Cloud VM in connection with master would now be utilized to sequentially create the pods with specific docker image runtime and provision in default inbuilt load balencer Ingress as part of Kubernetes setup . A typical docker image to build a spring boot api and create a pod and service to publish through Kubectl are sampled out as below. In developer cloud service under a typical project home all the artifacts and build jobs are organised so the specific user accessing devcs should have desired role for above visibility :

    Docker File in Spring boot Project context root, with a poc to update db store in Oracle Autonomous db cloud would be :

    FROM openjdk:8-jdk-alpine
    VOLUME /tmp
    ADD ./src/main/resources/Wallet_KXX /tmp/Wallet_KXX--- Wallet to securily connect the oracle db autonomous instance from a docker runtime
    COPY target/FirstPOCService-0.0.1-SNAPSHOT.jar app.jar
    ENTRYPOINT ["java","","-jar","/app.jar","--debug"]

    while the pod yaml to create a service type loadbalencer to register in OOTB Ingress with Kubernetes is as below .


    apiVersion: apps/v1beta1
    kind: Deployment
      name: app-dbboot-deployment
      replicas: 1
          app: app
            app: app
            - name: appdbtest
              image: ".............../firstspringpocdbimage:1.1"
         imagePullPolicy: "Always"
                - containerPort: 8099 #Endpoint is at port 80 in the container
              name: CCCC
    apiVersion: v1
    kind: Service
      name: springbootapp-db-service
      type: LoadBalancer #Exposes the service as a node port
      - port: 80
        protocol: TCP
        targetPort: 8099
        app: app

    Now , the typical steps to be executed ultimately to bring into life the pods as and that with the mighty Devcs automation is as below :

    echo "" >> $HOME/.oci/config
    echo "pass_phrase=bXXXX" >> $HOME/.oci/config
    cat $HOME/.oci/config
    mkdir -p $HOME/.kube
    oci ce cluster create-kubeconfig --cluster-id ocid.XXXXX--file $HOME/.kube/config --region eu-F>>>
    export KUBECONFIG=$HOME/.kube/config
    kubectl get pods
    kubectl config view
    kubectl get nodes
    kubectl delete service springbootapp-po-service
    kubectl delete deployment app-po-deployment
    kubectl create -f ./PO/po/springboot_db_deploy.yml
    sleep 60
    kubectl get services  springbootapp-po-service
    kubectl get pods

    This would be added as a Unix shell connected in built step and running below commands with kubectl . These are typical commands common to any K8 managed service by any cloud vendor and runs gracefully oracle as expected.


    Once this run successfully the Job logs under the specific build would list down the URL endpoint in the console itself and we dont need to really login to oci cli and bother with Black screen syndrome. I would also like to provide some experience around publishing a nginx container with angular app running on it in same way down the line so let's be on. Now those who are interested looking for further contribution and challenges you are facing to adopt this might K8 by Oracle stack. , meanwhile.

  • Neha Barnawal
    US Bank Virtual Card Pay
    Topic posted July 13, 2019 by Neha Barnawal, tagged Cash Management, Configuration, Financials, Payables, Setup / Administration, Subledger Accounting, Tip in Financials > Payables & Cash Management public
    US Bank Virtual Card Pay
    Implementing Virtual card payment in Payables Cloud

    Request to share your experience on implementing Virtual Pay Card in Oracle Payables Cloud.

    We understand a new Payment Method, PPP and templates will need to be created for this new payment type.

    Would like to know any challenges/Oracle limitation encountered for using virtual card payments.

    How did you setup card information in Oracle?

    Any input in this regard will be highly appreciated.


    Thanks and Regards,