General Ledger & Intercompany

Get Involved. Join the Conversation.

Posts

  • Dan Rinaldi
    Daylight Savings Time and Report Run Timing
    Topic posted 9:07 AM by Dan RinaldiGreen Ribbon: 100+ Points, tagged Financials, General Ledger, Reports 
    Title:
    Daylight Savings Time and Report Run Timing
    Content:

    In BI Publisher, we schedule reports using EST time zone.

    Whenever daylight savings time occurs, we have to re-schedule our reports as they are off one hour.

    Is there a way to avoid this?

    Thanks,

    Dan

  • Mark Simpson
    Creating a new Legal Entity - correct steps?Answered5
    Topic posted November 6, 2019 by Mark SimpsonRed Ribbon: 250+ Points, tagged General Ledger 
    Title:
    Creating a new Legal Entity - correct steps?
    Summary:
    Following steps to create a new LE but something isn't happening right
    Content:

    Hi All,

    We had some new codes created in our chart of account segment for entitiy but the actual creation of new legal entities relating to them wasn't done therefore we are trying to do that setup retrospectively. We have completed the first two steps in their creation:

    • Manage Legal Entity Address
    • Manage Legal Entity

    The next 3 steps had already occurred:

    • Manage Chart of Accounts Value Sets
    • Manage Account Hierarchies
    • Publish Account Hierarchies

    We understand this left us with three final activities, shown below:

    • Assign Balancing Segment Values to Legal Entities
    • Assign Legal Entities
    • Review and Submit Accounting Configuration

    ... however, when we go into the 'Assign BSV to Legal Entites' form the new Legal Entities are not available/visible in the drop-down?

    If we try the 'Assign LE' form having skipped the above we can see the LE and code value but the Company value then shows < No value > instead of the associated value set code and an error message to complete the Assign BSV to LE step first.

    Can anyone advise what we are missing/not doing?

     

     

    Version:
    Fusion 19C
  • Sunil KK
    Sequencing by LE and Interco Balancing Rules2
    Topic posted October 22, 2019 by Sunil KKGreen Ribbon: 100+ Points, tagged General Ledger, Intercompany 
    Title:
    Sequencing by LE and Interco Balancing Rules
    Summary:
    Sequencing by LE and Interco Balancing Rules
    Content:

    It appears that if we enable Sequencing  by LE, then we can not use Interco Balancing across LE (if all LEs are within a Ledger), we should only use Interco batch (AGIS).

    Has anyone found a work around to use sequencing by LE and yet use Interco Balancing feature at ledger level for multiple LEs?

  • Indu Kumari
    Journal approval is not getting triggered for Journal...1
    Topic posted November 5, 2019 by Indu KumariGreen Ribbon: 100+ Points 
    Title:
    Journal approval is not getting triggered for Journal approval is not getting triggered forrule defined based on code combination.
    Summary:
    Journal approval is not getting triggered for Journal approval is not getting triggered forrule defined based on code combination.
    Content:

    Journal approval is not getting triggered for for rule defined based on code combination. 
    we have requirement to trigger approval rule based on account combination to appropriate application role. 

    we have used ParallelTypeParticipantOneInParallelModeRuleSet and have rule defined as per attached document . 
    eg 
    ( Journal Line.Account Combination matches "(.*).(.*).(.*).(2106200).(.*).(.*).(.*).(.*).(0000000).(.*)" or  

    Journal Line.Account Combination matches "(.*).(.*).(.*).(1306500).(.*).(.*).(.*).(.*).(2002530).(.*)"
    now,when we interface and send journals for approval, it is not hitting this rule. 

     

    The same was working fine in dev instance (it was at 19c ) and we are facing this issue in UAT instance (19D) . we had configured all the rules manully in one of test instance(was on 19 D) itself  and then migrated into the UAT using soa composer -export /import

    After migrating , i had validated and recompiled again in UAT. but this rule is not working . other participant are wotrking fine.

  • 2019-07-04
    Basic GL question from new Cloud User re Key Flexfield...1
    Topic posted Yesterday by 2019-07-04Red Ribbon: 250+ Points, tagged General Ledger 
    Title:
    Basic GL question from new Cloud User re Key Flexfield Values
    Content:

    Hi,

    This query relates to 19C (11.13.19.07.0) and also 19B (11.13.19.04.0).

    It's more of a how to do something in Cloud query, rather than there being an error or problem.

    In R12 I was familiar with going to Setup > Financials > Flexfields > Key > Values and from there, searching via e.g.

    • Application: General Ledger
    • Title: Accounting Flexfield
    • Structure: Accounting Flexfield
    • Segment: Account

    From there, we could add new Account codes, and define their position in the hierarchy.

    How do we achieve the same in Cloud?

    Is it all done via Setup and Maintenance?

    Sorry for asking basic questions - I know I could wade through the training and many 100s of pages of documentation, but I thought I'd ask here to see if there is a quicker way.

    Any advice much appreciated.

    Thanks

    Jim

    Version:
    19C (11.13.19.07.0) and also 19B (11.13.19.04.0)
  • angela ahrens
    sql on showing manual journal entries with missing...2
    Topic posted October 31, 2019 by angela ahrensRed Ribbon: 250+ Points 
    Title:
    sql on showing manual journal entries with missing attachments
    Summary:
    sql on showing manual journal entries with missing attachments
    Content:

    anyone have sql on manual journal entries with missing attachments

  • Pathikp
    Journal Approval - How to restrict preparers for approving...Answered1
    Topic posted November 7, 2019 by PathikpRed Ribbon: 250+ Points, tagged General Ledger 
    Title:
    Journal Approval - How to restrict preparers for approving their own journals
    Summary:
    Journal Approval - How to restrict preparers for approving their own journals
    Content:

    We are planning to implement Journal approvals in Oracle Cloud, a Business requirement to restrict users to approve their journals in any cases such as Supervisor vacation rule, reassign back to the creator (JE creator   approver)

    There is no profile option available  

    R12, there is a profile option as "Journals: Allow Preparer Approval" with value (Yes/No) to route Journal, but not available in Oracle Cloud. 

    Can someone guide us on how to restrict users to approve their own Journal in BPM workflow rules

    Thank you

    Pathik Patel

     

     

    Version:
    R13 Update 19C
  • Vikash Sethi
    Create a new Request Set4
    Topic posted November 5, 2019 by Vikash SethiSilver Medal: 2,000+ Points, tagged Financials, General Ledger, Setup / Administration 
    Title:
    Create a new Request Set
    Summary:
    Create a new Request Set for Revaluation
    Content:

    I want to create a request set which can run Revaluation for multiple ledgers one by one. It was easy doing in on-Prem ERP. Do you know what are the steps to create this 'Enterprise Scheduler' / Request Set? Please let me know.

    Thanks

    Vikash

    Version:
    19C
  • Farooq Haider Syed, PMP
    NEW Analytics for ERPAnswered74.7
    Topic posted September 22, 2019 by Farooq Haider Syed, PMPBlack Diamond: 60,000+ Points, tagged Financials, Payables 
    Title:
    NEW Analytics for ERP
    Summary:
    Where can I find the new ERP analystics
    Content:

    HI,

    I heard that new ERP analytics provided by Oracle, I saw post in LinkedIn by Oracle.

    Did someone enables and how can we enabled it.

    Thanks

    Farooq

  • Maullin Shah
    CVR error message does not appear on "Journal...Answered3
    Topic posted November 6, 2019 by Maullin ShahBlue Ribbon: 750+ Points, tagged General Ledger 
    Title:
    CVR error message does not appear on "Journal Lines" form when user selects incorrect account code
    Summary:
    CVR error message does not appear on "Journal Lines" form when user selects incorrect account code
    Content:

    Hello All,

    Module : Oracle Cloud GL.

    CVR error message does not appear on "Journal Lines" form when user selects incorrect account code

    Navigation: Journals >> Create Journal >> Journal Lines >> Accounts --> User selects the invalid account combination and clicks on "Ok" button.
    Expectation --> Oracle GL should display CVR rule Error message that account combination is invalid.  So, that user is informed and change the accounting.
    Actual --> When user click on "Ok" button, system does not do any thing... It does not show any kind of error.

    Note: CVR rule is valid and working as expected in all other modules.

    Question:

    1.) Have you seen this issue in your system? 

    2.) Is there a way to pop up the CVR rule message?

    3.) Any help to resolve this issue.

    with regards, Maullin Shah

    Version:
    R13, 19C
    Image: