Financials – General

Get Involved. Join the Conversation.

Posts

  • Jordan Thompson
    How to best analyze ESS Job Schedules?35.0
    Topic posted December 9, 2019 by Jordan ThompsonGreen Ribbon: 100+ Points, tagged Financials, Search, Setup / Administration, User Interface 
    Title:
    How to best analyze ESS Job Schedules?
    Summary:
    How to best analyze ESS Job Schedules?
    Content:

    We have a basic need which we are struggling to find an answer to:

    How do we best analyze the jobs from ESS schedule? 

    Per our SR with Oracle, we cannot write a BIP SQL to extract the data from ESS tables because the NAMES of the jobs are not stored in the database. This means that the SQLs we can write are of no use to use because it does not contain the basic element NAME along with all the other relevent info.

    We also cannot effectively use the ESS UI because the search functionality is very limited, including not allowing a large download of the ESS data. SQL would be much better.

    We need some support on how to get this data because we are experiencing performance issues, especially in our non-production pods. We have many duplicate jobs running and have thousands of users who can launch them. 

    Any ideas? Thanks!

    Jordan

  • Krishna Thotapalli
    Import Daily exchange rates3
    Topic posted December 6, 2019 by Krishna Thotapalli, tagged Receivables 
    Title:
    Import Daily exchange rates
    Summary:
    Import Daily rates
    Content:

    How can we default daily rate instead of corporate rate for EUR to USD  while entering sales order?can we automate process to import daily rates from external system?

  • 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? 

  • Pavan Yakkala
    Is there any SOAP or REST service available to test CV Rules...1
    Topic posted December 4, 2019 by Pavan Yakkala 
    Title:
    Is there any SOAP or REST service available to test CV Rules ?
    Summary:
    cross validation rules
    Content:
    Is there any SOAP or REST service available to test CV Rules ?

    Hi All,

    Please help me, Is there any SOAP or REST service available to test CV Rules ?

    Thanks

    Pavan

  • 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...2
    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 masking2
    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?

  • Aly Yassin
    How to change the revenue account imported from sales order...1
    Topic posted November 27, 2019 by Aly Yassin, tagged Receivables, Subledger Accounting 
    Title:
    How to change the revenue account imported from sales order by SLA
    Content:

    How to change the revenue account line with discount imported from sales order by SLA

    when I import the sales order with discount line after autoinvoice process and create AR transaction

    DR/ Receivables   100

      CR /Revenue  110

      CR/ Revenue - 10 ( discount from SO ) 

    Customer need to use another GL account for discount line other than the revenue account

    How can i use SLA for this requirement?

  • Edward Higgins
    Financials dashboards3
    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
  • Traci Saige
    Automation of Post Refresh Tasks2
    Topic posted November 20, 2019 by Traci SaigeRed Ribbon: 250+ Points 
    Title:
    Automation of Post Refresh Tasks
    Summary:
    Has anyone set up automated steps post a refresh to prepare an environment? For example, production custom profile values to development/test profile values.