Posts

Posts

  • MShrini
    After R12 upgrade BIP and OTBI reports are not defaulted to...2
    Topic posted November 3, 2017 by MShriniGold Trophy: 10,000+ Points, tagged Accounting Hub Cloud Service, Allocations, Assets, Budgetary control, Cash Management, Collections, Compliance, Configuration, Core HR, Expenses, Financials, General Ledger, Intercompany, Invoice Imaging, Payables, Period Close / Reconciliation, Public Sector, Receivables, Reports, Revenue Management, Sample Reports, Security, Setup / Administration, Subledger Accounting, Update, User Interface in Integrations and Extensions public
    Title:
    After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role
    Summary:
    After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role
    Content:

    After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role but user were accessed in R11.  Please help  us with solution if you are faced the same in R12 upgrade.

  • Tausif Mulla
    Alfresco with Oracle Cloud Payables for DMS (Document...3
    Topic posted April 2, 2019 by Tausif MullaBronze Medal: 1,250+ Points, tagged Accounting Hub Cloud Service, Allocations, Assets, Compliance, Configuration, Expenses, Financials, General Ledger, Help Center, Intercompany, Invoice Imaging, Payables, Period Close / Reconciliation, Receivables, Reports, Search, Security, Setup / Administration, Subledger Accounting, Subscriptions, Tip, Update, User Interface in Core Financials > Payables & Cash Management public
    Title:
    Alfresco with Oracle Cloud Payables for DMS (Document Management system)
    Summary:
    Alfresco with Oracle Cloud Payables for DMS (Document Management system)
    Content:

    Hi,

    We are looking for solutions where Alfresco could be used as a DMS with Oracle Cloud Payables.

    Is it possible that the users while creating invoices can attach a link of DMS i.e. alfresco and through back end the invoice is saved in Alfresco automatically ?

    How would the integration work with Oracle cloud and DMS if the requirement is to store documents in Alresco while creating invoices in Oracle Payables.

    Thank you for your inputs !

    Tausif Mulla

  • 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
  • Victoria Marinucci
    Allocation creating negative debits/creditsAnswered1
    Topic posted August 2, 2017 by Victoria MarinucciGreen Ribbon: 100+ Points, tagged Allocations, Financials, General Ledger in Core Financials > General Ledger & Intercompany public
    Title:
    Allocation creating negative debits/credits
    Summary:
    Oracle Issue where Allocation creating negative debits/credits, which impacts automation - anyone else experiencing this?
    Content:

    Anyone else experience this issue? If so, how is it impacting you?


    My Team is using allocation rules and the journals that are being created are entering negative debit and/or credit values such that all entries to the target are all debits (all credits) and the allocation offset string is a credit (debit). 

    I expect the rule to enter negative debits as credits. 

    Specifically, the reason we find this issue inconvenient is  we are unable to combine elimination allocation rules into a ruleset with a clearing allocation rules, because manual intervention is required in between those two steps. Diminishes  automation. 

    This is currently reported as an ER (though it feels like a bug) here w/ no ETA: 
    Bug 24578828 : ALLOCATION PUTS TARGET ON DEBIT AND OFFSET CREDIT EVEN IF AMOUNT IS NEGATIVE 

  • Ryan Tilles
    Allocation ExclusionsAnswered4
    Topic posted June 14, 2017 by Ryan TillesGreen Ribbon: 100+ Points, tagged Allocations in Core Financials > General Ledger & Intercompany public
    Title:
    Allocation Exclusions
    Summary:
    Are Exclusions considered in the Basis?
    Content:

    We have a parent department 1500, which has 20 children. We only want to allocate to 15 of them.

    So, in the Allocation Range, we use parent 1500.

    In the Exclude step, we enter the 5 that we don't want.

    In the Basis, we cannot pick the department segment, since it defaults in from the Allocation Range.

    However, it appears that the Basis is using the parent department 1500 and is NOT considering the 5 exclusions.

    Is this a bug or intended functionality? In other words, does the Allocation engine only consider Exclusions against the Allocation Range and not while analyzing the basis?

     

  • 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

  • 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

  • Ayeshan Peiris
    Allocation target members104.0
    Topic posted August 19, 2018 by Ayeshan PeirisSilver Medal: 2,000+ Points, tagged Allocations in Enterprise Performance Mgmt > Profitability and Cost Management public
    Title:
    Allocation target members
    Content:

    Hi All,

    I have defined two dimensions within PCM, Account and Entity (Cost Center). When defining allocation rules, in the target, I decided not to select the option "Same as Source for Entity member and I gave different destination cost center instead. I did this because merely for ease of my reporting purpose. To me, It seems funds flow is interrupted here.(Allocation out is from one cost center and Allocation in is for Another cost center, but account member it is same.)what are the implications of doing that. is this a best practice?

    Thanks

  • Mohamed Shawky
    Allocation using Calculation Manager1
    Topic posted October 12, 2018 by Mohamed Shawky, tagged Allocations in Core Financials > General Ledger & Intercompany public
    Title:
    Allocation using Calculation Manager
    Summary:
    We need to allocate amounts based on certian segments and statistical values
    Content:

    Hi,

    We need to allocate Ending Balances of certain accounts based on percentages that change every month. Below is a brief description of the case:

    1- The accounts that need to be allocated are included within a parent account

    2- The allocation source is the total ending balances for each of the respective natural accounts irrespective of the balancing segment and other segment values.

    3- The allocation target should be the same natural accounts and only the balancing segment values will be assigned to a different value, whereas all the other segments will be defaulted to the default values.

    4- The allocation should be based on a percentage that changes from month to month. We will enter STAT journals for those percentages every month,

    5- The offset of the allocation should be to a fixed natural account and balancing segment while other segments should show the default values.

     

  • Kevin Johnson
    AllocationsAnswered6
    Topic posted January 11, 2017 by Kevin JohnsonBronze Medal: 1,250+ Points, tagged Allocations, Financials in Core Financials > General Ledger & Intercompany public
    Title:
    Allocations
    Summary:
    Allocating a Parent to The same Parent
    Content:

    We are implementing Oracle Fusion right now. We are currently working in the Calculation Manager creating allocations. One thing we noticed is that we can have an Source account be a parent in a hierarchy but we can not have a parent be the Offset. Our question is, does any one know how to bring in a range of accounts for the Offset? For Example If accounts 1 and 2 roll Up to Parent *** and we specify the *** parent as our source account, we would like to specify *** as our account Offset also. This would basically "clear out" Accounts 1 and 2. We don't need to do it as a parent level if a range is possible in the Source Account also. Does any one have any ideas of how to do this with out creating an allocation for each account?