Posts

Posts

  • Irina Feldesh, CPA, CGA
    Smart View “No Data / Missing” Option Suppressing Zeroes1
    Topic posted June 12, 2019 by Irina Feldesh, CPA, CGAGold Medal: 3,500+ Points, tagged Analysis, EPBCS, Financial Planning, PBCS, Planning, Public Sector, Reporting, Smart View in Enterprise Performance Mgmt > Planning public
    Title:
    Smart View “No Data / Missing” Option Suppressing Zeroes
    Summary:
    The latest Windows version of Smart View incorrectly suppresses zeroes when “No Data / Missing” suppression is selected in the Smart View Data Options
    Content:

    It appears that as of the May 2019 update (Version 11.1.2.5.900 Build 093), users can no longer leverage the “No Data / Missing” suppression options, instead they must use the “Suppress Missing Blocks” option when running Ad Hoc Analysis reports via the Smart View for Office Add-In (Microsoft Excel for Office 365 MSO, 64-bit) in order to suppress rows or columns that do not have data while retaining any rows or columns that have a zero value.

    Has anyone else noticed this odd behaviour? If so, have you filed an SR with Oracle reporting the bug?

    Regards,
    Irina

    Version:
    EPBCS 19.05.57 & Oracle Smart View for Office 11.1.2.5.900 Build 093 & Microsoft Excel for Office 365 MSO (16.0.10730.20344) 64-bit
    Image:
  • Ramesh Radhakrishnan
    "Update Supplier Keyword Search Index and Source to...2
    Topic posted June 9, 2019 by Ramesh RadhakrishnanGold Crown: 30,000+ Points, tagged Public Sector, Sourcing Programs in Procurement > Supplier Management public
    Title:
    "Update Supplier Keyword Search Index and Source to Settle Counts Runs In every 30 Minutes and Errors
    Content:

    "Update Supplier Keyword Search Index and Source to Settle Counts Runs In every 30 Minutes  and Errors and it is not generating any error log. Any pointers about this program how to troubleshoot this program. Also I see below note relevant to this program

    "Update Supplier Keyword Search Index and Source to Settle Counts Runs In every 30 Minutes (Doc ID 2474423.1)

     

    Version:
    R13-19B
  • Ashok
    Announcement: Update 19B Features in Self Service...5.0
    Topic posted June 8, 2019 by AshokGold Crown: 30,000+ Points, tagged Budget/Encumbrance, Create Requisition, Public Sector, Requisition Processing in Procurement > Self Service Procurement public
    Title:
    Announcement: Update 19B Features in Self Service Procurement
    Summary:
    Announcement: Update 19B Features in Self Service Procurement
    Content:

    Dear Customers / Support

    Here are the list of features that have been released as part of Update 19B for Fusion Self Service Procurement:

    A. FULFILL PROJECT MATERIAL REQUIREMENTS FROM INTERNAL SOURCES:

    The capabilities supported in this update include: Create project-striped internal requisition with an expense destination type Create project commitment on requisition approval Create project-striped transfer orders with expense destination type Charge the expenditure to the project at destination

    B. OVERRIDE AGREEMENT PRICE ON REQUISITIONS:

    With this enhancement, you can change the item price on the Edit Requisition page and through the requisition import program when the blanket purchase agreement allows price override. You can modify the price within the price limit specified on the agreement line. This feature empowers you as an advanced procurement requester to set negotiated prices with suppliers when the price on the agreement is considered to be a guideline. 

    C. ALLOW APPROVERS TO REJECT UPDATED BUDGETARY-CONTROLLED REQUISITIONS THAT FAILED FUNDS CHECK:

    s an approver, you can now reject budgetary-controlled requisitions that you edited, but could not submit due to a failure of funds check. Requesters can then cancel the requisitions if needed. Without this feature, you would not be able to order any items for yourself, or to update any other budgetary-controlled requisitions, because your checkout process would be blocked.

    Additional details can be downloaded from this document link:

    https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/proc/releases/19B/19B-procurement-wn.pdf

  • Scott Calnon
    Multiple Parameter List - With 2 Column Values Concatenated...
    Topic posted June 6, 2019 by Scott Calnon, tagged BI Publisher, Fusion Financial reporting, Public Sector, Reports in Reporting and Analytics for ERP public
    Title:
    Multiple Parameter List - With 2 Column Values Concatenated (BI Publisher)
    Summary:
    ORA-00909: invalid number of arguments message when executing report with multiple parms.
    Content:

    It is a business requirement to have Cost Centre code and Description in the drop down list.  Ie.

    nnnn-<description>

    Example 1:

    1105-Chief Executives Office

    1108-Board & Chair

    When executing the BI publisher report and selecting multiple values the query (snippet) as follows has a ORA-00909 error. (codes.segment2 is the cost centre code eg. 1105   and the parameter :p_costcentre contains multiple values selected (see Example 1 above).

    ..
    AND (codes.segment2 IN (SELECT substr(token,1,instr(token,'-')-1)
             from  (select regexp_substr(:p_costcentre, '[^,]+', 1, LEVEL) token
                                                                 from dual
                                                                 connect by LEVEL <= length(:p_costcentre) - length(REPLACE(:p_costcentre,',','')) + 1
                      )
        )
    .
    .Is there any way to get around this error, without just listing the cost centre code on its own.
    Code Snippet:
  • Ramesh Radhakrishnan
    Modify Supplier Registration Account Creation e-mailAnswered115.0
    Topic posted June 5, 2019 by Ramesh RadhakrishnanGold Crown: 30,000+ Points, tagged How-To, Public Sector, Supplier Registration, Supplier User Account in Procurement > Supplier Management public
    Title:
    Modify Supplier Registration Account Creation e-mail
    Summary:
    Modify Supplier Registration Account Creation e-mail
    Content:

    We would like to Modify Supplier Registration Account Creation e-mail Like the email subject and some of the contents in the email.

    Please let know the options to modify the email notification.

    Version:
    R13-19B
    Image:
  • William McLarty
    Can payment auditor receive an FYI regarding travel...
    Topic posted June 5, 2019 by William McLartyBlue Ribbon: 750+ Points, tagged Expenses, Public Sector in Financials > Expenses public
    Title:
    Can payment auditor receive an FYI regarding travel authorizations
    Summary:
    Can payment auditor receive an FYI regarding travel authorizations
    Content:

    Is it possible to configure a notification to a user/user group regarding a travel authorization being approved?  If so, what steps are needed to accomplish this?

    Thanks,

    Bill

    Version:
    R13 19B
  • Vineet Gangwar
    Supplier Registration email concerns if SSO is enabled35.0
    Topic posted June 4, 2019 by Vineet GangwarRed Ribbon: 250+ Points, tagged How-To, Public Sector, Security, Setup, Supplier Communication, Supplier Creation, Supplier Registration, Supplier User Account, Tip in Procurement > Supplier Management public
    Title:
    Supplier Registration email concerns if SSO is enabled
    Summary:
    When SSO is enabled, organisations are suppose to disable the user account related email and this disables the emails for new account creations for supplier as well.
    Content:

    If SSO is enabled, user account creation emails are generally disabled and this causes a challenge to implement supplier portal. As suppliers do not get communicated about their account creations automatically as soon as the account is created, followings are the possible solutions (and their challenges) which can be suggested to clients (there can be few more but these are based on my understandings of the application):

    1: Once supplier is registered and account is crated, go to security console, change the user category and reset the password to resend the emails to suppliers.

    Challenges - In most of the public (even in private) sectors, this activity is performed by a dedicated team of supplier admins/managers and they are not supposed to have the access of "Security Console" because of organisations security policies. Hence this solution doesn't sound feasible to clients.

     

    2- Keep notifications enabled and modify the content of user account email. Detail clear cut instructions for employees and suppliers on how they can access the application but again it comes with the risk that employees (new) might miss the instruction and start using it with the credentials provided in email rather that the SSO ones, which is again big concern for organisations.

     

    These are the 2 possible solutions which I could have thought of based on my understanding of Cloud application. Please feel free to correct me or suggest any alternate solution if you have come across similar requirement.  

    Thanks

    Vineet Gangwar

    Version:
    19b
  • William McLarty
    Expense Charge Account does not default in on creating an...4
    Topic posted June 3, 2019 by William McLartyBlue Ribbon: 750+ Points, tagged Expenses, Public Sector in Financials > Expenses public
    Title:
    Expense Charge Account does not default in on creating an Expense Item
    Summary:
    Expense Charge Account does not default in on creating an Expense Item
    Content:

    We have enabled EXM_ALLOW_FULL_ACCT_OVERRIDE and added the Override Expense Account Allocation privilege to all users - this allows us to update the account on an expense item.  In one environment, the Expense Charge account is defaulted in (and the account is updated from the Expense Item template account), however in another environment (both 19B) the Expense Charge account comes in blank.
    Obviously I have missed a setup step - anyone have any ideas on what I need to do?

    Version:
    R13 19B
  • Ekansh Jain
    How to use the Operating Organization, Location Organization...
    Topic posted May 30, 2019 by Ekansh JainBlue Ribbon: 750+ Points, tagged Asset Master Data Management, Maintenance Analytics, Preventive Maintenance, Public Sector, Safety Management, Tip, White Paper in Manufacturing & Maintenance > Maintenance public
    Title:
    How to use the Operating Organization, Location Organization and Maintenance Organization for setting up the Maintenance Organization Structure
    Summary:
    How to use the Operating Organization, Location Organization and Maintenance Organization for setting up the Maintenance Organization Structure
    Content:

    Hi,

    I am trying to design the Maintenance Organization structure for our client, currently, they are not maintaining any inventory (they have inventory but they are not maintaining it).

    1. Therefore, all the assets they have does not have parts list as well. I have suggested them to create the inventory organization and provide the parts list for each and every asset. But this seems to be a lot of work for our client.
    2. Therefore, I have thought of the solution where only one inventory org should be created and all other places where maintenance activities are going on should be created as sub-inventories.
    3. Now, the maintenance organization can be associated with one inventory organization. How to use the Operating Organization, Location Organization and Maintenance Organization for setting up the Maintenance Organization Structure
    4. Also, can we create items as expense items which will be procured from maintenance work orders directly using the functionality of manual purchase orders creation from maintenance work orders?

    Thanks

    Ekansh

     

  • Ekansh Jain
    How to setup resource overhead cost for Maintenance work...Answered3
    Topic posted May 30, 2019 by Ekansh JainBlue Ribbon: 750+ Points, tagged Asset Master Data Management, Maintenance Analytics, Preventive Maintenance, Public Sector, Safety Management, Tip, White Paper in Manufacturing & Maintenance > Maintenance public
    Title:
    How to setup resource overhead cost for Maintenance work orders in Oracle Maintenance Cost
    Summary:
    How to setup resource overhead cost for Maintenance work orders in Oracle Maintenance Cost
    Content:

    Hi,

    Our users are looking for a solution which will be used to calculate the resource overhead in addition to the time charged by resource against the maintenance work order.

    The overheads are like Benefits = 18%* Resource Cost, then other additional percentage calculation. Also, they want to account the expenses which are not in percentage, for example, mileage expense charges(Gas used to travel to different locations for performing maintenance activity).

    Please let me know how can we implement all the above scenarios using resource rate and overhead rate setups?

    Also, when I am trying to set up the Overhead cost, I am not able to find the resource rate as a parameter on top of which I can calculate the percentage which will get further added to the total resource cost.

    Thanks

    Ekansh