Posts

Posts

  • Sunil KK
    Allocation based on Account balance (without STAT...3
    Topic posted October 18, 2019 by Sunil KKGreen Ribbon: 100+ Points, tagged Allocations, Financials, General Ledger in Core Financials > General Ledger & Intercompany public
    Title:
    Allocation based on Account balance (without STAT journal)
    Summary:
    Allocation based on Account balance
    Content:

    Hi All,

    I would like to know if anyone has achieved similar allocation as below:

    Scenario:

    Jan-19 PTD Balances are as follows:

    A1) All expenses are recorded in Account    50001 and product 101 , say 100 USD (This is for expenses belong to both product 101 and 102)

    B1) Revenue is correctly recorded against : 40001 and product 101, say 200 USD

    B2) Revenue is correctly recorded against :  40002 and product 102, say 100 USD

    I would like to allocate Expenses from 50001.101 to 50002.102 based on % revenue derived from B1 and B2 ). i.e, Target amount A2 = (B2/B1+B2) * A1 

    Offset Account = A1

    As seen above, the allocation is based on balance instead of STAT journal. Is this possible using either formula or Allocation ? Any thoughts?

     

    Thanks,

    Sunil

    Version:
    19C
  • Rohan Kamat
    Disable summarization by code combinationsi n allocation...
    Topic posted October 15, 2019 by Rohan KamatBronze Trophy: 5,000+ Points, tagged Allocations, General Ledger in Core Financials > General Ledger & Intercompany public
    Title:
    Disable summarization by code combinationsi n allocation rules
    Content:

    Hi team 

    If we have same target accounts ( having same combinations in a formula journal ) ,allocation engine summarizes the account balance , is there a way to avoid the summarization 

    For example 

    Formula journal is written 

    01-000-21200-000 100

    01-000-21200-000  120

    01-000-31000-000                 220

     

    After running allocaiton , we get 

    01-000-21200-000 220

    01-000-31000-000         220 

    but we want seperate lines in journal entries . Any ideas how this can be achieved without writing 2 seperate rules

     

    Thanks

    Rohan

    Version:
    19C
  • Dev Thota
    How to delete/change strategies that are assigned to...1
    Topic posted October 12, 2019 by Dev ThotaGold Trophy: 10,000+ Points, tagged Accounting Hub Cloud Service, Allocations, Assets, Budgetary Control, Cash Management, Collections, Compliance, Configuration, Core HR, Financials, General Ledger, Help Center, Receivables, Revenue Management, Setup / Administration, Subledger Accounting in Core Financials > Receivables & Collections public
    Title:
    How to delete/change strategies that are assigned to delinquent customers
    Summary:
    How to delete/change strategies that are assigned to delinquent customers
    Content:

    We are implementing the advanced collections in our dev instance and completed the required setups. After running the collections scoring and strategy assignment program the strategies those are assigned are seems wrong. We have disabled all seeded strategy groups and created a custom one but in the screen the seeded one is showing as disabled and in use "Yes" and customers are assigned  with this strategy but we are expecting custom strategy to be assigned for all customers. Is it possible to delete this delinquency data. Can anyone review the screen shots and advise.

    Version:
    19C
    Image:
  • Craig Anderson
    Allocation Run-Time Prompt (RTP) Variables3
    Topic posted September 30, 2019 by Craig Anderson, tagged Allocations, General Ledger in Core Financials > General Ledger & Intercompany public
    Title:
    Allocation Run-Time Prompt (RTP) Variables
    Summary:
    Looking to have a RTP variable for allocations for a value that is not tied to a dimension.
    Content:

    Hello,

    Thanks in advance for any help. What I'm looking to do is have a run time prompt (RTP) for an allocation we're looking to set up that would not be tied to a specific dimension we have. It would essentially be it's own new variable.

    Since we cannot allocate based on multiple currencies across ledgers (or have not figured out how to), we're moving both USD and CAD balances to a STAT currency to have one "standard pooled currency". What we're trying to have is a RTP come up that we can populate based on foreign exchange rates for our USD balance in the US Ledger be moved to the CDN equivalent in the STAT currency. Please let me know if this is not clear.

    Thanks,

    Craig

  • Dev Thota
    Unable to cancel schedule jobs.35.0
    Topic posted September 30, 2019 by Dev ThotaGold Trophy: 10,000+ Points, tagged Accounting Hub Cloud Service, Allocations, Assets, Budgetary Control, Cash Management, Collections, Compliance, Configuration, Core HR, Expenses, Financials, General Ledger, Help Center, Intercompany, Invoice Imaging, Payables, Period Close / Reconciliation, Public Sector, Receivables, Reports, Revenue Management in Core Financials > Payables & Cash Management public
    Title:
    Unable to cancel schedule jobs.
    Summary:
    Unable to cancel schedule jobs
    Content:

    Hi all,

    I am trying to cancel a schedule jobs

    1. Validate Payables Invoices
    2. Import Payables Invoices

    We are unable to cancel these jobs.

     

    Thanks,

    Dev Thota

    Version:
    19C
  • AL
    Exclude members in an allocation rule.1
    Topic posted September 30, 2019 by ALRed Ribbon: 250+ Points, tagged Allocations, Calculation in Enterprise Performance Mgmt > Profitability and Cost Management public
    Title:
    Exclude members in an allocation rule.
    Content:

    Hi Experts,

     

    I was wondering if there is any option to exclude members in a allocation rule.

     

    Thanks and regards,

     

  • Karthikeyan Sukumar
    Oracle Will Not Support Internet Explorer 11 After Update...15.0
    Topic posted September 29, 2019 by Karthikeyan SukumarGold Trophy: 10,000+ Points, tagged Accounting Hub Cloud Service, Allocations, Assets, Budgetary Control, Cash Management, Collections, Compliance, Configuration, Core HR, Expenses, Financials, General Ledger, Help Center, Intercompany, Invoice Imaging, Payables, Period Close / Reconciliation, Public Sector, Receivables, Reports, Revenue Management, Sample Reports, Search, Security, Setup / Administration, Subledger Accounting, Subscriptions, Tip, Update, User Interface in Core Financials > Financials – General public
    Title:
    Oracle Will Not Support Internet Explorer 11 After Update 19D
    Summary:
    Oracle Will Not Support Internet Explorer 11 After Update 19D
    Content:

    Oracle Will Not Support Internet Explorer 11 After Update 19D.Since the release of Microsoft's Edge browser in 2015, Internet Explorer (IE) has not added support for many modern web standards, nor has this browser received major updates. Therefore, with Fusion Applications Update 19D, Oracle will no longer provide support for IE. Please see Microsoft's Lifecycle FAQs - Internet Explorer and Edge for more information.

    Oracle goal is to utilize the most modern web standards to deliver an exceptional customer experience, and for that reason, Oracle made the decision to end IE support. Oracle recommend you choose one of their supported modern browsers such as Google Chrome, Microsoft Edge, Apple Safari or Mozilla Firefox.

    Please note that while you can still technically use IE11, Oracle will not deliver fixes that are specific to IE11, and will begin introducing features that may not work with IE11.

    Thanks!

    Karthik

  • Parmit Choudhury
    Allocation Rule Execution is not finishing2
    Topic posted September 27, 2019 by Parmit ChoudhuryGreen Ribbon: 100+ Points, tagged Allocations, PCM, Rules in Enterprise Performance Mgmt > Profitability and Cost Management public
    Title:
    Allocation Rule Execution is not finishing
    Summary:
    Rule execution is taking too much time and we have to restart essbase service to kill the rule.
    Content:

    Hi Guys,

    We are getting the following error when we are restarting the Essbase service to stop the Rule after it runs for about an hour.

    “Number of updated cells count is Zero for Rule” or

    “Allocation Rule failed

    Cannot set active application/cube. Essbase Error (1051544): message on contacting or from application: Local////Error (1013204) Client Commands are Currently Not Being Accepted.

     

    Please can anybody share Best Practices document for PCMCS.

    Any help on getting the rule to work will be much appreciated.

     Below is the scenario of the rule.

    The Rule is of type pro rata as per specifications.

    In the source definition currently we have specific or all or any members for all dimensions apart from a single dimension for which we have taken three separate members.

     

    In case of Driver basis, for Account dimension we have taken an alternate hierarchy with two shared members, as we are not able to add the two members separately and a single member from another dimension.

    In the specifications document it is given  that few of the Destination members would be same as Source and Basis. So destination members, which are same as driver basis, we followed a rule that we specified those members in destination rather than specifying them in Driver basis. Our understanding is that if we specify the same members in Destination then Driver basis will also pick up the same members during rule execution

    For destination, most of the members are any or all members of separate individual  dimensions. To take any or all members of a separate individual  dimensions we have created dynamic hierarchies for all those dimensions with shared members in them. We have also created an alternate hierarchy for another dimension with over 30 shared members and taken that hierarchy in destination definition

    For other destination members, which are same as source, we have ticked the “Same as Source” option.

    Offset Location is taken as Source

     

    So given the above scenario if anybody can suggest a better approach or design of the rule, it will be very helpful.

     Also if you can also suggest a better way to specify all or any member selection from any particular dimension in source or destination that will also be helpful

  • Alecsandra Mlynarzek
    PCM Out-of-the-Box (OOTB): 5.Queries
    Topic posted September 24, 2019 by Alecsandra MlynarzekBronze Trophy: 5,000+ Points, tagged Activity Based Costing, Allocations, Costing, Customer Profitability, PCM, Profitability Analysis in Enterprise Performance Mgmt > Profitability and Cost Management public
    Title:
    PCM Out-of-the-Box (OOTB): 5.Queries
    Summary:
    Learn how to leverage PCM queries for data extract and data analysis
    Content:

    At the end of this post you should be familiar with the following topics:

    1. Define PCM Queries
    2. Queries Use Cases
    3. How to Launch Queries in PCM
    4. Query Options
    5. Data Extract Format
    6. Common Errors and Warnings
    7. Alternate Uses of PCM Queries

    *The contents of this blog post are based on the standard Bikes (BkML30) application. Deploying the PCM Demo Bikes application can be achieved via the PCM landing page — “Creating a Sample application button” (from version 19.06 onwards).

    1. What is a PCM Query? 

    PCM Queries are predefined statements with execution mechanics like Smart View retrievals.

    Queries can be launched in one of three ways:

    1. Via the PCM Graphical User Interface (GUI)
    2. Automatically through EPM Automate/REST API commands
    3. Within Dashboards and Intelligence analysis reports (covered in greater detail in this previous post).

    2. Queries Use Cases 

    Queries are versatile artifacts that have a list of use cases limited only by the user’s imagination. The most common use cases are:

    1. Data Validation – leveraged both for input as well as post-allocated results. Queries can be created and stored in a PCMCS instance. Their definition is similar to a Smart View query, with Columns, Rows, and Point of View (POV) selections. More details are found in the queries options section. PCM Queries have drill-through capability – applicable only to base level queries, leveraging the Cloud Data Management functionality.
    2. Driver/Adjustment Data Entry Template – while queries do not rise to the capabilities of a PBCS/EPBCS web data entry form, they manage to solve the issue of “directional intersections” in an elegant manner. By defining the base level intersections where driver data should reside and storing that query definition, users avoid the need for offline sheets for data entry.
    3. Refined Data Clear Selection – queries can be leveraged to trigger narrow or specific data clears aimed at replacing partial data sets. During a clear POV action, users can select a predefined query to restrict the clear scope. This feature optimizes data loads enabling users to restrict the replacement of input data to only those intersections that are required to be replaced. Think of it as a predefined FIX statement or a predefined tuple.
    4. Simplified Task Lists  – An example of this capability is explained in detail within the “Alternative uses” section of this blog.
    5. Journal Entry or Data Warehouse export – formatted data exports that can be leveraged as Journals within a GL submission process, in .csv extracts, without any custom formatting functionality like header, footer, record count, date/time stamp, etc.

    3. How to Launch PCM Queries 

    There are several Graphical User Interfaces (GUI) as well as automation options to launch queries.

    1.  Intelligence Menu Section – clicking the query name opens a Smart View connection within an Excel session, prompting users to enter their Cloud credentials. If the Excel session is not terminated, credentials will persist for all subsequent query launches.
    Blog Post.Alec Intelligence Menu Section Picture

    From the Actions button, users can also launch a direct .csv export of each query. The exported file will be placed within the File Explorer section and is available for download. Users can define the number of decimals they choose to extract – up to a maximum of 7 – and whether or not they choose to perform a base-level export or an aggregated data export.

    2.  Manage Queries Section – this menu includes all the capabilities found within the Intelligence menu section along with the ability to edit, delete, or create new queries.

    3.  EPM Automate Command – if the desire is to launch a query and generate a .csv file in an automated manner, the requirement can be achieved by executing the following command: epmautomate exportqueryresults APPLICATION_NAME fileName = FILE_NAME [queryName = QUERY_NAME] [exportOnlyLevel0Flg=true]The .csv file generated is very similar to a data warehouse extract file with all dimensions displayed in columns and separated by a space delimiter.

    By omitting the queryName parameter, the automation will execute a full base-level data extract of the PCM application in the native ASO format. (non-columnar, optimized for native ASO data load).

    Alternatively, if the query must be used in a targeted data clear, the request can be launched via automation:  epmautomate clearpov APPLICATION_NAME POV_NAME [QUERY_NAME] PARAMETER = VALUEstringDelimiter = “DELIMITER”

    Example:

    epmautomate clearpov BksML 2019_Jan_Actual queryName=BksML_2019_Jan_clear_query isManageRule=false is InputData=false isAllocatedValuses=fasle is AjustmentValues=false stringDelimiter

    When uisng targeted data clears, no other parameters can be enabled, such as isManagerRule, isInputData, isAllocatedValue, or isAdjustmentValues.

    4.  Rest API Command – just like EPM Automate, REST API is used for automation (lights-out processing). EPM Automate leverages REST API in the background. The difference between REST API and EPM Automate is not the scope of this post; however, one of the main differences between the two is the enhanced logging level available with REST API, which is why implementation partners may favor REST vs EPM Automate.

    https://<SERVICE_NAME>-<TENANT_NAME>.<SERVICE_TYPE>.<dcX>.oraclecloud.com/epm/rest/v1/applications/Ex3F3/jobs/exportQueryResultsJob

    {“queryName”: “Proftiability – Product”,”fileName”: “ProfitabilityProduct2019.txt”,”exportOnlyLevel0Flg”:”true”}

    The syntax for a targeted data clear is the following:

    https://<SERVICE_NAME>-<TENANT_NAME>.<SERVICE_TYPE>.<dcX>.oraclecloud.com/epm/rest/{api_version}/applications/{application}/povs/{povGroupMember}/jobs/clearPOVJob

    {“isInputData”:”true”,”queryName”:”myQueryName”,”stringDelimiter”:”_”}

    [...] Continue reading this post on ranzal.blog.

    Version:
    PCM 19.09
  • Dev Thota
    Can we transmit a single payment which was created through...15.0
    Topic posted September 24, 2019 by Dev ThotaGold Trophy: 10,000+ Points, tagged Accounting Hub Cloud Service, Allocations, Assets, Budgetary Control, Cash Management, Collections, Compliance, Configuration, Core HR, Expenses, Financials, General Ledger, Help Center, Intercompany, Invoice Imaging, Payables, Period Close / Reconciliation, Public Sector, Receivables, Reports, Revenue Management, Sample Reports, Search, Security, Setup / Administration, Subledger Accounting, Subscriptions, Tip, Update, User Interface in Core Financials > Payables & Cash Management public
    Title:
    Can we transmit a single payment which was created through " Create Payment" option?
    Summary:
    Can we transmit a single payment which was created through " Create Payment" option?
    Content:

    Hi all,

    Can we transmit a single payment which was created through the " Create Payment" option?

     

    Thanks,

    Dev Thota.

    Version:
    19C