Posts

Posts

  • 2019-07-04
    How to define Distributions on Invoices generated via...
    Topic posted September 12, 2019 by 2019-07-04Red Ribbon: 250+ Points, tagged Receivables in Core Financials > Receivables & Collections public
    Title:
    How to define Distributions on Invoices generated via Recurring Bill Plan?
    Content:

    Hi,

    We are using 19B (11.13.19.04.0) and have set up a Recurring Bill Plan.

    From what I have seen from reading Oracle Docs (e.g. Manage Recurring Billing), I cannot see how to determine the Distributions against the invoices created via the "Generate Recurring Billing Data" job, or via the setup linked to the Recurring Bill Plan.

    Am I missing something obvious?

    Any advice would be much appreciated.

    Thanks

    Jim

    Version:
    19B (11.13.19.04.0)
  • Prateek Parasar
    AR Invoice Settlements through Direct DebitAnswered2
    Topic posted September 11, 2019 by Prateek ParasarGold Crown: 30,000+ Points, tagged Collections, Financials, Receivables in Core Financials > Receivables & Collections public
    Title:
    AR Invoice Settlements through Direct Debit
    Summary:
    Direct Debit BACS setup and settlement for AR Invoice Payment
    Content:

    Looking for information on how debit authorisation with bank details are captured in Oracle (against customer or invoice) also how these settlements files are prepared and sent to the bank. Any information, previous post, MOS doc or documentation will be helpful 

    Version:
    R13
  • Beth Bleijie
    Edit AR invoice Special Instructions9
    Topic posted September 10, 2019 by Beth BleijieBronze Trophy: 5,000+ Points, tagged Financials, Receivables, Setup / Administration in Core Financials > Receivables & Collections public
    Title:
    Edit AR invoice Special Instructions
    Summary:
    "Special Instructions" box at the bottom of invoice - how is it edited?
    Content:

    Our AR Invoices show a box at the bottom, below the "Send Payment To" remittance instructions, called "Special Instructions."

    How is this edited?
    Can it be edited specifically for one customer?  If so, can it be added more or less permanently, and not have to be re-added with each invoice?

    Thanks,

    Beth

    Image:
  • Amy Chan
    Bank Reconciliation9
    Topic posted September 9, 2019 by Amy ChanSilver Medal: 2,000+ Points, tagged Cash Management, Financials, Payables, Receivables in Core Financials > Payables & Cash Management public
    Title:
    Bank Reconciliation
    Summary:
    Bank Reconciliation
    Content:

    We just implement one company using Oracle cloud (small amount of transactions) and user reported that the bank reconciliation is not very efficient base the condition for matching is not flexible enough so she did not use auto-reconciliation instead of manual reconciliation.

    Can anyone share with me how to use or setup in order to increase the percentage of auto-reconciliation?

    Thanks.

  • Cristian Betancur
    No data Found in Colombia Sales Reports
    Topic posted September 9, 2019 by Cristian BetancurBlue Ribbon: 750+ Points, tagged Collections, Configuration, Financials, Receivables, Reports, Setup / Administration in Core Financials > Receivables & Collections public
    Title:
    No data Found in Colombia Sales Reports
    Summary:
    No data Found in Colombia Sales Reports
    Content:

    Hi

    I executed scheduled processes:
    -Sales Fiscal Book Report for Colombia.
    -Sales Income Tax Self-Withholding Report for Colombia.

    These reports should be shown in UAT before last week, and they do not show information.

    Is there any set up that it is neccesary to show report information?

    Thanks.

    Cristian.
     

    Version:
    Oracle Fusion Release 13 19B
  • Cristian Betancur
    No Data Found in XLA_TRANSACTION_ENTITIES table...Answered125.0
    Topic posted September 9, 2019 by Cristian BetancurBlue Ribbon: 750+ Points, tagged Assets, Cash Management, Configuration, Expenses, Financials, General Ledger, Payables, Receivables, Reports, Search, Security, Setup / Administration, Subledger Accounting in Core Financials > General Ledger & Intercompany public
    Title:
    No Data Found in XLA_TRANSACTION_ENTITIES table (Subledger Source Transactions)
    Summary:
    No Data Found in XLA_TRANSACTION_ENTITIES table (Subledger Source Transactions)
    Content:

    Hi

    I have a SQL query with this table for diagnostic. However, I cannot see data into XLA_TRANSACTION_ENTITIES table.

    I want to know if this issue is for missing role or it is other cause, because Payables and Receivables transactions have been posted in General Ledger.

    This is critical in some reports, because they are used in LACLS Colombia Cloud financial process and Subledger Financial Reports.

    Thanks.

    Cristian.
     

    Version:
    Oracle Fusion Release 13 19B
    Document:
  • Juan Miguel Isip
    Dunning Letters won't re-run in Draft Mode1
    Topic posted September 8, 2019 by Juan Miguel IsipBronze Medal: 1,250+ Points, tagged Collections, Financials, Receivables, Reports, Sample Reports in Core Financials > Receivables & Collections public
    Title:
    Dunning Letters won't re-run in Draft Mode
    Summary:
    Dunning Letters won't re-run in Draft Mode
    Content:

    I successfully ran the Aged Dunning Letters in Draft Mode but when I re-ran it, it results into an Error and has the error message: 

    "No Dunning Site Found, Looping through delinquent Bill-to Sites."

    Why can't I re-run Aged Dunning Letters in Draft Mode? I've already run the following in sequence:

    • Collections Delinquency Management
    • Update Collections Summary Data
    • Send Dunning Letters 

    I've already confirmed that the said Customer has an Active Site with "Send Dunning" ticked at the profile level and has an active Contact with a Dunning Responsibility.  This is also true since I was also able to generate a Dunning sample once, but wasn't able to do it again. I've also confirmed that all executions of the ESS job "Send Dunning" was set to "Draft Mode".

     

    Also, I noticed that the other job (“Collections Delinquency Management”) that before "Send Dunning Letters" has different outputs pertaining to delinquent customers:

    Log of Successful Run of “Collections Delinquency Management” ESS Job:

    P_ORG_ID=300000001361190

    P_MODE=ORA_FULL

    Scored 3717 objects of type IEX_INVOICES

    Number Of Delinquencies Updated..>> 0

    Number Of Delinquencies Created..>> 1776

    STARTING GATHER STATS for IEX_DELINQUENCY:IEX_DELINQUENCIES_ALL

    367 Rows updated in ar_trx_bal_summary with reference_1 = 1

    To diagnose, run Scoring Diagnostic and Collections Setup Diagnostic

    Output of Successful run of “Collections Delinquency Management” ESS Job:

    Number of Transactions scored: 3717

    Number of delinquencies updated with Status Current: 0

    Number of delinquencies created with Status Delinquent: 1776

    Log of UnSuccessful Run of “Collections Delinquency Management” ESS Job:

    P_ORG_ID=300000001361190

    P_MODE=ORA_FULL

    Scored 3717 objects of type IEX_INVOICES

    Number Of Delinquencies Updated..>> 0

    Number Of Delinquencies Created..>> 0

    STARTING GATHER STATS for IEX_DELINQUENCY:IEX_DELINQUENCIES_ALL

    To diagnose, run Scoring Diagnostic and Collections Setup Diagnostic

    Output of UnSuccessful run of “Collections Delinquency Management” ESS Job:

    Number of Transactions scored: 3717

    Number of delinquencies updated with Status Current: 0

    Number of delinquencies created with Status Delinquent: 0

    How can I generate data again for Delinquent Customers? Any other items I need to check? Am I missing out some steps?

    please advise. Thank you!

  • Arun Kumar
    Enable Customers DFF and enable this DFF1
    Topic posted September 6, 2019 by Arun KumarGreen Ribbon: 100+ Points, tagged Receivables in Core Financials > Receivables & Collections public
    Title:
    Enable Customers DFF and enable this DFF
    Summary:
    Setup Customers DFF and configure this DFF in manage audit policies
    Content:

    Hi Friends,

    I have setup Customers DFF. Next step, I need to enable / configure this DFF in the manage audit policies so that it can be audited. I have not been able to do this, as when I go to Manage Audit Policies --> Receivables --> this DFF does not appear in the list of attributes. 

    Would appreciate any information on how to audit (turn auditing on) for this new customers DFF (ATTRIBUTE1 from the table HZ_CUST_ACCOUNTS).

    Thanks and Regards,

    Arun

     

  • Amit Mishra
    What is the equivalent feature of Customer Deposits in...5
    Topic posted September 6, 2019 by Amit MishraRed Ribbon: 250+ Points, tagged Collections, Financials, Invoice Imaging, Receivables, Subledger Accounting in Core Financials > Receivables & Collections public
    Title:
    What is the equivalent feature of Customer Deposits in Fusion ?
    Summary:
    How to create customer deposit document to share with customer?
    Content:

    Hi All,

    We have a requirement to create a deposit transaction for a customer and later to settle the deposit amount against the upcoming invoices for the same customer. I understand that Fusion doesn't have 'Deposit' feature available in the Receivables module and a couple of folks may have just created the receipt (act as a customer deposit) as a workaround, however, how do I create the deposit document in the system which can be printed and shared with the customer to make a payment against?

    Also, how do I take care of accounting as it was available in Oracle EBS which upcoming invoices used to settle against the deposit transactions and creating appropriate accounting accordingly?

    Any pointer will be appreciated.

    Thanks/Amit

     

    Version:
    19C
  • brightstar
    Fusion Receivables: Short Term and Long Term Deferred...
    Topic posted September 5, 2019 by brightstarRed Ribbon: 250+ Points, tagged Receivables, Revenue Management in Core Financials > Receivables & Collections public
    Title:
    Fusion Receivables: Short Term and Long Term Deferred Revenue Accounting
    Summary:
    Fusion Receivables: Short Term and Long Term Deferred Revenue Accounting
    Content:

    Client sells a service contract for 2 years.

    AR need to book their short term (within 12 months) deferred revenue to a specific account 'X', and book their long term deferred revenue in a different account 'Y'. Below Example in Sep-19.

    Service Contract - 2 years = $12000
    Year 1   Year 2  
    Sep-19 500 Sep-20 500
    Oct-19 500 Oct-20 500
    Nov-19 500 Nov-20 500
    Dec-19 500 Dec-20 500
    Jan-20 500 Jan-21 500
    Feb-20 500 Feb-21 500
    Mar-20 500 Mar-21 500
    Apr-20 500 Apr-21 500
    May-20 500 May-21 500
    Jun-20 500 Jun-21 500
    Jul-20 500 Jul-21 500
    Aug-20 500 Aug-21 500
      6000   6000
    Account X   Y

    After a month, Oct-19, 12 months deferred revenue needs to get re-calculated, which means, 

    Oct-19  Deferred Revenue moves into Recognized Revenue

    Sep-20 Deferred Revenue moves from Account 'Y' into Account 'X' as Sep-20 in Oct-19 falls within the 12 month window.

    This should get repeated automatically every month.

    Can any of the member help to achieve this functionality in Oracle Fusion Receivables?

    Version:
    Fusion Receivables 19C