Posts

Posts

  • Pinaki Das
    Cloud instance name45.0
    Topic posted March 26, 2019 by Pinaki DasRed Ribbon: 250+ Points, tagged Financials, Fusion Applications Integration, Procurement, Project Portfolio Management, SaaS Integration in Integrations and Extensions public
    Title:
    Cloud instance name
    Summary:
    Query to fetch cloud instance name
    Content:

    Table: ASK_DEPLOYED_DOMAINS

    Schema: FUSION_SETUP

    The field EXTERNAL_VIRTUAL_HOST stores the external link

    Condition: DEPLOYED_DOMAIN_NAME='FADomain' (Check the domain name and replace the value)

    select         DEPLOYED_DOMAIN_ID,

     DEPLOYED_DOMAIN_NAME,

     EM_HOME_URL,

     INTERNAL_VIRTUAL_HOST,

     INTERNAL_VIRTUAL_PORT,

     EXTERNAL_VIRTUAL_HOST,

     EXTERNAL_VIRTUAL_PORT,

     JMX_PORT,

     NODE_MANAGER_PORT,

     ADMIN_HOST,

     ADMIN_PORT,

     LOGICAL_DOMAIN_ID,

     NODE_MANAGER_PROTOCOL,

     ADMIN_SERVER_NAME,

     APPLICATION_CLOUD_ID,

     INTERNAL_SERVER_PROTOCOL,

     EXTERNAL_SERVER_PROTOCOL,

     ADMIN_SERVER_PROTOCOL,

     OBJECT_VERSION_NUMBER,

     ENTERPRISE_ID,

     CREATION_DATE,

     CREATED_BY,

     LAST_UPDATED_BY,

     LAST_UPDATE_DATE,

     LAST_UPDATE_LOGIN

    From        ASK_DEPLOYED_DOMAINS

    Where  DEPLOYED_DOMAIN_NAME='FADomain'

    Version:
    18C
  • Sunny Chugh
    ESS Jobs Functional and Data Security4
    Topic posted October 13, 2019 by Sunny ChughSilver Medal: 2,000+ Points, tagged Financials, HCM, Procurement, Project Portfolio Management, SCM, Security in Applications Security public
    Title:
    ESS Jobs Functional and Data Security
    Summary:
    we have few custom ess jobs of BIP type and we would like to know how to secure the ess jobs based on roles/Duties and how to enable data level security on the ESS Job LOVs
    Content:

    Hi

    we have custom ess jobs of BIP type and we would like to know how to secure the ess jobs based on roles/Duties and how to enable data level security on the ESS Job LOVs

    Kindly share if anybody has got the same requirement.

    thanks!

    Regards

    Sunny

  • Neena S
    Security in PPM3
    Topic posted August 1, 2017 by Neena SGreen Ribbon: 100+ Points, tagged Project Portfolio Management, Security in Applications Security public
    Title:
    Security in PPM
    Summary:
    Query for Security in PPM
    Content:

    Hi

    Is anyone able to provide me with the query which adds security to PPM reports? This would be for Fusion R12 BIP reports. 

    The requirement is to add the same security which is on the screens( access to projects, BU etc.) onto the custom BIP reports which have been developed. And also to incorporate changes in security which is part of R12.

    Thanks

  • Bradley Hughes
    Release 12 - Security Console Challenges and Colleague...44.3
    Topic posted April 26, 2017 by Bradley HughesSilver Trophy: 7,500+ Points, tagged Financials, HCM, Other, Procurement, Project Portfolio Management, Sales, SCM, Security, Tip in Applications Security public
    Title:
    Release 12 - Security Console Challenges and Colleague Password Reset Queries
    Summary:
    Help to resolve password resets for colleagues that have no Email and now no security questions
    Content:

    Hello,

    After reviewing the functionality within the Security Console for R12, we have discovered there are now no Security Questions available. The only functionality we can see that allows a colleague to reset their forgotten password, will require a Work Email Address. If Colleagues have no Work Email address, they will have to contact the operation in order to reset their password.

    The colleague can then log into Fusion immediately, without being prompted to change their password after initial log in. The Employee can reset their password by 'set preferences' but this is a manual task.

    Is anybody aware of any available functionality that allows a user, without an email address in the system to reset their password? or any workarounds that will prevent a huge volume of calls to the operation, due to a high volume of colleagues having no Work Email address,

    Kind Regards,

    Brad

  • Kesava Rao Katuri
    PPM Project - ErpObjectAttachmentService - Update Attachment135.0
    Topic posted August 19, 2019 by Kesava Rao KaturiRed Ribbon: 250+ Points, tagged File Based Data Integration - FBDI, Import Bulk Data, Integrated Cloud Services, PaaS - SaaS Extensions, Project Portfolio Management in Integrations and Extensions public
    Title:
    PPM Project - ErpObjectAttachmentService - Update Attachment
    Summary:
    How to update/override the existing attachement in ERP
    Content:

    Hi All

    Using ErpObjectAttachmentService (SOAP), we can either upload or download the attachment(s) which are attached to a particular project.

    Is there a way to update/delete the existing attachment  through API?

    Thanks

    Kesava

  • Kunal Daya
    Fusion Apps - License ConsumptionAnswered74.0
    Topic posted July 31, 2019 by Kunal DayaRed Ribbon: 250+ Points, tagged Financials, HCM, Other, Procurement, Project Portfolio Management, Sales, SCM, Security, Tip in Applications Security public
    Title:
    Fusion Apps - License Consumption
    Summary:
    Trying to understand how license consumption per user works
    Content:

    Hi Community,

    Can anyone explain how license consumption works in Fusion Applications. IS the consumptions done by by users and what roles they have or is it dependant on what features are enabled?

    Example Issue: We have users high number of users consuming Inventory licenses, however we only should have 10 users using Inventory module.

    Objective; Reduce number of inventory license users and other modules

    Any assistance would be appreciated

    Kind Regards

     

    Version:
    19B
  • Kesava Rao Katuri
    PPM - Project Date Cascade Options1
    Topic posted August 9, 2019 by Kesava Rao KaturiRed Ribbon: 250+ Points, tagged Project Portfolio Management, REST Services in Integrations and Extensions public
    Title:
    PPM - Project Date Cascade Options
    Summary:
    PPM Rest API to implement Project Date Cascade Options
    Content:

    Hi Experts

    Please suggest the procedure to implement the "Cascade project Finish Date Change to affected Tasks" using REST api(s). 

    Thanks

    Keava

  • Kesava Rao Katuri
    PPM Project - Attachment Service10
    Topic posted August 9, 2019 by Kesava Rao KaturiRed Ribbon: 250+ Points, tagged PaaS - SaaS Extensions, Project Portfolio Management, REST Services in Integrations and Extensions public
    Title:
    PPM Project - Attachment Service
    Summary:
    PPM Project - Attachment Service
    Content:

    I'd like to attach a document to the project newly created.

    Created a project using PPM REST API /fscmRestApi/resources/11.13.18.05/projects

    Now planning to attach a document using the ERP soap service : https://ucf5-zgbl-fa-ext.oracledemos.com:443/fscmService/ErpObjectAttachmentService?WSDL

    But need the proper values to be passed for entityName,categoryName. Please suggest

     

          <typ:uploadAttachment>
             <typ:entityName>RA_CUSTOMER_TRX_ALL</typ:entityName>
             <typ:categoryName>CUSTOMER_TRX</typ:categoryName>
             <typ:allowDuplicate>yes</typ:allowDuplicate>
             <!--Zero or more repetitions:-->
             <typ:attachmentRows>
                <erp:UserKeyA>Vision University BU</erp:UserKeyA>
                <erp:UserKeyB>300000024352134</erp:UserKeyB>
                <erp:UserKeyC>WTW0008</erp:UserKeyC>
                <erp:UserKeyD></erp:UserKeyD>
                <erp:UserKeyE></erp:UserKeyE>
                <erp:AttachmentType>FILE</erp:AttachmentType>
                <erp:Title>Attachment.pdf</erp:Title>
                <erp:Content></erp:Content>
             </typ:attachmentRows>
          </typ:uploadAttachment>

  • David Hernández Garibay
    Publish a sandbox by legal entity or organization3
    Topic posted May 27, 2019 by David Hernández Garibay, tagged Financials, HCM, Other, Procurement, Project Portfolio Management, Public Sector, Sales, SCM, Security, Tip in Applications Security public
    Title:
    Publish a sandbox by legal entity or organization
    Summary:
    I want to change the theme of the ERP Cloud menu only in a specific legal entity
    Content:

    I want to change the theme of the ERP Cloud menu, this change I'm making in a SandBox, but I want that when publishing this SandBox only the changes for a specific legal entity apply

    Version:
    R13 19B
  • Kunal Daya
    Report that shows a role and all the duties and privleges it...34.5
    Topic posted April 8, 2019 by Kunal DayaRed Ribbon: 250+ Points, tagged Financials, HCM, Other, Procurement, Project Portfolio Management, Security in Applications Security public
    Title:
    Report that shows a role and all the duties and privleges it inherits
    Summary:
    Report that shows a role and all the duties and privleges it inherits
    Content:

    Hi All,

    I am trying to build a report that shows roles and what it inherits in terms of data roles, duties and privleges. Does anyone know a report that exists with this information or the tables where this information is stored?