Financials – General

Get Involved. Join the Conversation.

Posts

  • Mei Kwan
    Smartview reports include disabled CCID data or not?
    Topic posted December 5, 2019 by Mei KwanSilver Medal: 2,000+ Points, tagged Financials, General Ledger 
    Title:
    Smartview reports include disabled CCID data or not?
    Summary:
    Our Smartview reports were out of balance after removing the check mark on "Enabled" in "Manage Account Combinations" for some CCIDs back in 2016.
    Content:

    In 2016, after we unchecked the "Enabled" box in "Manage Account Combinations" for several code combinations, our Smartview reports were out-of-balances.  To correct the Smartview reporting issues, we did the following:

    • Re-checked the "Enabled" box
    • Put an End Date on "To Date" on those code combinations
    • Checked "Preserved Attributes"

    Due to this finding, we either run "Inherit Segment Value Attributes" or manually enter End Date in "To Date"and check "Preserve Attributes" in "Manage Account Combinations" to disable the CCIDs.

    Recently we created a new CVR for the interest income accounts in test pod, then ran "Manage Cross-Validation Rule Violations".  The process removed the check mark from "Enabled" and checked "Preserve Attributes" for all those invalid code combinations in "Manage Account Combinations".

    I compared the Aug-2019 Smartview P&L reports between production & test pods and they were matched but not Sep-2019.  The Sep-2019 difference was in the interest income section. I do not know if the difference was due to timing difference (additional entries posted in production pod subsequent to the P2T in test pod) or the Smartview reports continue to exclude "Disabled" CCID data.

    Does anyone know if Oracle has corrected this Smartview data issue in the later versions? 

  • Stephen Bryant
    Can an AFF Segment Label/Name be defaulted dynamically?2
    Topic posted December 3, 2019 by Stephen BryantBronze Trophy: 5,000+ Points, tagged Financials, General Ledger, Public Sector, Setup / Administration, User Interface 
    Title:
    Can an AFF Segment Label/Name be defaulted dynamically?
    Summary:
    Business Unit default Segment Label/Name?
    Content:

    Hello,

    Our client has an interesting requirement.  There are two groups of users, Private and Federal.  Each group uses the exact same chart of accounts segments (security rules to handle values) with one difference.  They would like to default the name of the account segment to be "Account" for Private and "Object" for Federal.  We are considering using Business Unit to default the name/label.

    Is this possible?  Is there another way to do this?  We considered multiple charts of accounts but the client does not want that.  We could also name the segment "Account:Object" but that was not good enough.  Our industry can be particular at times and we would like to try to accommodate them.

    Thanks for your help.

    Steve

    Version:
    19C
  • Maria Centeno
    ERP – Oracle Financials Cloud: Overview and Investment S...1
    Topic posted December 2, 2019 by Maria CentenoSilver Medal: 2,000+ Points, tagged Financials 
    Title:
    ERP – Oracle Financials Cloud: Overview and Investment Strategy, 11 December 2019, 9 a.m. PT - Submit Questions
    Content:

    Submit your questions for the ERP – Oracle Financials Cloud: Overview and Investment Strategy 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 Tuesday, 10 December 2019.

  • Swamy
    GDPR Data columns in finance for masking
    Topic posted November 27, 2019 by SwamyGreen Ribbon: 100+ Points, tagged Cash Management, Financials, General Ledger, Revenue Management, Security, Setup / Administration 
    Title:
    GDPR Data columns in finance for masking
    Summary:
    GDPR Data columns in finance for masking
    Content:

    Hi:

    What are the GDPR data which needs to be masked in Oracle finance GL and Cash management? In HCM, we used to mask the National ID, Date of birth etc but not sure on the finance especially on the GL and Cash.

    Could you please advise?

  • Edward Higgins
    Financials dashboards1
    Topic posted November 25, 2019 by Edward Higgins, tagged Collections, Financials, General Ledger, Reports 
    Title:
    Financials dashboards
    Summary:
    Are there any OOTB financials dashboards?
    Content:

    The dashboards folder on our system is empty.  I have seen references to a Collections dashboard on the forum, and this would be of interest to us.  Have they been recently deprecated, do they need to be loaded and enabled?

    Version:
    OBIEE 11.1.1.9 Fincials 19C
  • Maria Centeno
    ERP – Accounting Automation: A Path Ahead, 20 November 2...16
    Topic posted November 12, 2019 by Maria CentenoSilver Medal: 2,000+ Points, tagged Financials, General Ledger 
    Title:
    ERP – Accounting Automation: A Path Ahead, 20 November 2019, 8 a.m PT - Submit Questions
    Content:

    Submit your questions for the ERP – Accounting Automation: A Path Ahead 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 Tuesday, 19 November 2019.

  • Matt Nease
    Data Access by Legal Entity instead of Business UnitAnswered55.0
    Topic posted November 7, 2019 by Matt NeaseGreen Ribbon: 100+ Points, tagged Financials, Receivables, Security, Setup / Administration 
    Title:
    Data Access by Legal Entity instead of Business Unit
    Summary:
    How to assign data access to users by Legal Entity using custom Database Resource
    Content:

    A client has a requirement for billing managers to manage receivables activities by Legal Entity. Currently we have set up custom job roles that use Data Security Policies driven by Business Unit. However their are multiple LEs per BU, and the customer wants to restrict by LE, not BU. 

    I know under 'Security Console > Administration > General > Manage Database Resources' you can create a custom Database Resource, which is clear. However, FUN_USER_ROLE_DATA_ASGNMNTS does not have a Legal Entity column, so you seemingly cannot assign Legal Entities to users via 'Manage Data Access for Users', so I don't know what to do with the custom Database Resource . Is there another way to assign potentially multiple Legal Entities to a user other than 'Manage Data Access for Users' (or derive it somehow), that I could then use as a Condition SQL Predicate in a custom Database Resource? A billing clerk could handle 2 or more LEs, so I don't think it can be derived from their HR record.

  • gabriel kinovisques
    Is there any Localization Reports for EcuadorAnswered1
    Topic posted November 6, 2019 by gabriel kinovisquesRed Ribbon: 250+ Points, tagged Financials, General Ledger 
    Title:
    Is there any Localization Reports for Ecuador
    Summary:
    Is there any Localization Reports for Ecuador
    Content:

    Hello

    I was wondering if there is any localization reports for Ecuador ?

    Please Advise

  • Federica Colosimo
    Support Request: Create a Contract2
    Topic posted November 4, 2019 by Federica ColosimoGreen Ribbon: 100+ Points, tagged Allocations, Assets, Budgetary Control, Cash Management, Collections, Configuration, Expenses, Financials, General Ledger, Payables, Receivables, Setup / Administration, Subledger Accounting 
    Title:
    Support Request: Create a Contract
    Summary:
    When I try to create a contract, there aren't BU to insert in the BU field
    Content:

    Hi,

     

    I want to create a contract but when I try to create a contract in the Contract Work Area, The System doesn't show any business unit, any legal entity, any contract Type even thought I've already created BU, Legal Entity and Contract Types.

     

    I've already assign "Enterprise Contract Administrator/Manager" role with BU Data access and I've already enable the user with this role as a resource. 

     

    Have you an idea to solve this problem? 

     

    Thank u very much 

     

    Federica

    Image:
  • harsha vardhan
    How customize Invoice Approval Email Notification35.0
    Topic posted October 30, 2019 by harsha vardhanGreen Ribbon: 100+ Points, tagged Financials, Payables 
    Title:
    How customize Invoice Approval Email Notification
    Summary:
    How to Add Vendor Bank details on Invoice Approval Email Notification
    Content:

    I customized Invoice Approval Notification Report to add vendor bank details but not able to see changes.

    Any one please share exact BI report path for Invoice Approval Email notification.