Posts

Posts

  • Amol S
    Can we do the summation of 2 diffrent DFF
    Topic last edited 4:26 AM by Amol S, tagged Agreements, Approvals, Approvals/Notification, Approved Supplier List, Business Intelligence, Create Requisition, FAQ, Payables, Security, Setup, Supplier Communication, Supply & Distribution Planning Cloud, Tip, Web Services, White Paper in Procurement > Purchasing public
    Title:
    Can we do the summation of 2 diffrent DFF
    Summary:
    Suppose we have created 2 DFF 1. A and 2.B so can be we add the DFF A and B show the result in C
    Content:

    Suppose we have created 2 DFF  1. A  and 2. B,  so can we add the both DFF A and B  and show the result in  C

    Suppose if we entered the value  in DFF A  =  1 

    Suppose if we entered the value  in DFF B =  10

    Can we do the summation of DFF A ( 1) + DFF B ( 10 ) = and show the result in DFF C (11)

    If yes, can you please share the detailed steps. 

    Thanks in advance

  • Puneet Pareek
    Enable Favorite Button While having a Home Page Layout as...2
    Topic posted December 11, 2019 by Puneet PareekRed Ribbon: 250+ Points, tagged Help Center, Payables, Security, Setup / Administration in Core Financials > Payables & Cash Management public
    Title:
    Enable Favorite Button While having a Home Page Layout as 'News Feed'
    Summary:
    AP Users would like to have AP Invoice and Payment Apps as a part of Favorites to minimize the time taken while navigating between 2 Apps namely Payments and AP Invoice
    Content:

    Hi Team,

    We are facing an issue wherein the Favorite and watchlist buttons are not visible when the Default Home Page Theme is changed from Banner --> News Feed. There is a requirement to revamp the Oracle home page by enabling the Home Page layout as 'News Feed' to improve user experience but after performing the setup we don't see favorite button. 

    Can you please confirm if we have any configuration which can enable the favorite button even while having the Default Home Page Setting as 'News Feed'. Please move the post to relevant section if this is not the right section.

     

    Regards,

    Puneet Pareek

  • Matthew Terry
    Recurring Invoice Issues3
    Topic posted December 6, 2019 by Matthew Terry, tagged Payables in Core Financials > Payables & Cash Management public
    Title:
    Recurring Invoice Issues
    Summary:
    Questions about payment dates and issues with PNs and tasks
    Content:

    I had a question about payment dates when it comes to scheduling recurring invoices via upload in Oracle. From what I can tell, the 'From Period' and 'To Period' fields are the only fields that drive dates when payments get cut; regardless of accounting date/expenditure date, the payment will go out on the 1st of each month (or 1st calendar day following the 1st) that falls between the From Period and To Period (values are month/year only, not day). Is there a way to change the date without going in to Oracle once the upload has been processed and without messing with the payment terms? Just a field that can be used on the upload sheet that we download that can make the payment date the 20th, or 15th?

    Version:
    19D (11.13.19.10.0)
  • Tessy van Engelen
    Tax amount Tax Audit Trail report4
    Topic posted November 20, 2019 by Tessy van EngelenBlue Ribbon: 750+ Points, tagged Compliance, Financials, Payables, Period Close / Reconciliation, Reports in Core Financials > Tax and Global public
    Title:
    Tax amount Tax Audit Trail report
    Summary:
    The tax amount shown in the Tax Audit report isn't correct
    Content:

    Situation

    Transaction is booked with a certain tax code. Then the user discovers this amount / tax code isn't the one applicable to the transaction.
    The tax line is adjusted and the transaction is processed.

    What seems to be happening is that the tax table is still showing the old tax amount. As the report: 'Tax Audit Trail' is pulling it's data from the tax table it is not showing the data as shown on the invoice. Which means this report is becoming not usefull.

    Workaround is that you don't update an existing tax line, but you have to cancel it and create a new correct tax line.


    Possible idea's to get a more userfriendly situation

    To get to a more userfriendly situation what we would like to have is both or one of below mentioned idea's:
    - When the tax line is changed and saved that the related tables are updated.
    - Make it impossible to update an saved tax line; we only should be able to cancel it and create a new tax line.

     

    Version:
    19C
  • Mamatha Havildar
    Reconcile Termed Employee P-Card Expenses135.0
    Topic posted July 10, 2019 by Mamatha HavildarRed Ribbon: 250+ Points, tagged Expenses, Financials, Payables, Period Close / Reconciliation, Reports, Setup / Administration, Subledger Accounting in Core Financials > Expenses public
    Title:
    Reconcile Termed Employee P-Card Expenses
    Summary:
    How do you reconcile termed employee P-Card Expenses
    Content:

    We have a few termed employee pcard expenses we want to process.  We were following oracle suggested process
    1 - Activate the employee
    2 - Add the Employee Role 
    3 - Change employee password 
    4 - Run Import User and Role Application Security Data and Retrieve Latest LDAP Changes 
    5 - Login as Terminated User 
    6 - Add a delegate – Accounting 

    But after 19B upgrade we cannot do this anymore. 
    It seems like we have to re-activate the employee record not just user account for adding a delegate reconcile termed employee pcard expense. 

    Looking for suggestion, workaround we can use without activating the employee record.

  • Swathi Potla
    Payables invoice is showing Funds Not Applicabnle
    Topic posted Yesterday by Swathi PotlaBlue Ribbon: 750+ Points, tagged Budgetary Control, Financials, Payables, Public Sector in Core Financials > Payables & Cash Management public
    Title:
    Payables invoice is showing Funds Not Applicabnle
    Summary:
    Certain Invoices not going through funds check
    Content:

    We have multiple invoices that are showing Funds Check as "Not Applicable" which is causing GL to be out of sync with Budget Cube. There is no commonality among these invoices. Did anyone experience the same issue? This happen to have started right after Release 19C. 

    Note that based on our Budgetary Control setup, it should have been reserved. New invoices coming in are getting reserved for the same account code.

  • Leyla Ören
    Fixed Assets - Mass Additions Create13
    Topic posted December 9, 2019 by Leyla ÖrenRed Ribbon: 250+ Points, tagged Assets, Financials, Payables in Core Financials > Assets public
    Title:
    Fixed Assets - Mass Additions Create
    Summary:
    Fixed Assets - Mass Additions Create
    Content:

     

    Hello,
    I am trying to interface an asset into FA through AP.

    Steps

    1. Created a PO and Received it.
    2. Created an AP Invoice and matched it to PO.
    3. Checked the distribution. Track as Asset is marked.
    4. Though the Asset Clearing account in that category is different from the account that is coming in the PO Accrual ( in AP invoice distribution)
    5. Posted that Invoice to GL

    Before I started the Mass Additions Create Program, this was the status

    Accounting Date = 4.12.2019

    Assets Tracking Flag = Y

    Assets Addition Flag = U

    Posted Flag = Y

    Then I ran the Mass Additions Create with the GL Date of 9.12.2019 but the Mass Additions Create Report shows no output.

     

    Version:
    19C (11.13.19.07.0)
  • Louis fayard
    Garnishment for Suppliers1
    Topic posted December 11, 2019 by Louis fayard, tagged Payables in Core Financials > Payables & Cash Management public
    Title:
    Garnishment for Suppliers
    Summary:
    How to create garnishments for supplier
    Content:

    Hello,

    I am trying to create garnishments for suppliers similar as what is done in HCM for salaries.

    I am familiar with the third party relationship options but this does not cover the needs of the clients. He wants to be able to withheld a certain percentage of the invoice paid to the supplier or a total amount (for instance 100 000euros then each time an invoice is paid the amount of the invoice is deduced from the total amounts).

    I have tried to use the Funds capture as described here https://docs.oracle.com/en/cloud/saas/financials/19d/fairp/define-funds-capture.html#FAIRP339912 but I can't make it work and I am not even sure this would be working for garnishments.

    Does anyone have an idea how to make it work ? even partially ?

    thank you,

    Louis

  • Kim Puls
    Year-End Close9
    Topic last edited January 30, 2019 by Kim PulsSilver Medal: 2,000+ Points, tagged Allocations, Assets, Budgetary control, Cash Management, Expenses, Financials, General Ledger, Payables, Period Close / Reconciliation, Receivables, Reports, Subledger Accounting in Core Financials > General Ledger & Intercompany public
    Title:
    Year-End Close
    Summary:
    How is year-end close different from month-end close?
    Content:

    Our institution is new to R12 (went live 7/1/17) which means we haven't done a year-end close yet. We've been told that year-end is similar to month-end. We know we'll have to build new calendars...but our functional leads are questioning how balances roll forward and what they look like in the new year. Is the carryforward a separate line or is it lumped into the new year funding? What happens with unaccounted/POs that need to roll forward? And to top that all off we are upgrading to R13 in the next 6wks.

    Thanks - Kim

  • Ganesan sriram
    The rules defined under rule set InvoiceApprovalRuleSet did...Answered2
    Topic posted December 11, 2019 by Ganesan sriram, tagged Financials, Payables in Core Financials > Payables & Cash Management public
    Title:
    The rules defined under rule set InvoiceApprovalRuleSet did not return any results. (FUN-720336)
    Summary:
    The rules defined under rule set InvoiceApprovalRuleSet did not return any results. (FUN-720336)
    Content:

    We have defined a invoice approval rule based on invoice header requestor name. Condition is If invoice header requestor name isn't null then follow supervisory heirarchy with one level of approval and get manager of the requestor mentioned at invoice header. But we are getting this below error. The rules defined under rule set InvoiceApprovalRuleSet did not return any results. (FUN-720336). Have any one faced the same.

    Find the rule defined below:

    Condition:

    IF

    Invoice Header.Requester Name   Isn't    null

    Then

    List Builder   Supervisory


    Starting Participant:  HierarchyBuilder.getManager("supervisory",Invoice Header.Requester Name,-1,"","")

    Top Participant: HierarchyBuilder.getPrincipal("XXXX",-1,"","")

    Could you please help us on what to be changed in rule.

    Version:
    19D