Oracle Fusion ERP Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion ERP Analytics

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

DW_AP_SLA_PAYMENT_CF PAYMENT_ACCOUNTING_STATUS_CODE column

Received Response
113
Views
9
Comments
Keith Antone
Keith Antone Rank 2 - Community Beginner
in Oracle Fusion ERP Analytics

Are the records populated in the DW_AP_SLA_PAYMENTS_CF table filtered to only include records where the Accounting Status = 'ACCOUNTED'? We have noticed that the value for the PAYMENT_ACCOUNTING_STATUS_CODE = 'ACCOUNTED' for all records in the table.

Tagged:

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist
    edited May 1, 2024 10:51PM

    Hi @User_05NC2

    Yes, this table will capture only accounted records only.

    image.png

    If you think i have answered your question, please accept the same.

    Regards,

    Arjun

  • Subha_Tripathy-Oracle
    Subha_Tripathy-Oracle Mod

    Hi @User_05NC2 ,

    Thank you for visiting and posting in Fusion Analytics Warehouse(FAW)/ Fusion Data Intelligence(FDI) Product Community Page.

    Yes we support only accounted payments in FAW/FDI.

    It would be great if you update your Display Name in your profile, so we know with whom we are communicating with in the community ;-)

    Thanks
    Subha

  • Keith Antone
    Keith Antone Rank 2 - Community Beginner

    We have noticed that the behavior for the DW_AP_SLA_INVOICE_SCHEDULE_CF includes records where INVOICE_ACCOUNTING_STATUS_CODE = 'UNACCOUNTED'. What is the reason that payments must be accounted to populated the DW_AP_SLA_PAYMENTS_CF?

  • Subha_Tripathy-Oracle
    Subha_Tripathy-Oracle Mod

    Hi @User_05NC2 ,

    This is by design. In case you have a business justification, please feel free to log an Enhancement Request in Fusion Analytics Warehouse Idea Lab:

    https://community.oracle.com/products/oracleanalytics/categories/idealab-fusion-analytics

    Thanks
    Subha

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @User_05NC2

    Based on Customers demands ,

    In Our next Release 18.4 means 24R2 development team is coming with more modifications i hope you can able to see all the status values after that release.

    Regards,

    Arjun

  • AllenN
    AllenN Rank 1 - Community Starter

    On this topic, when is 24R2 expected to be released whereby we may be able to see this capability of having payments which are unaccounted in the fact table?

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics Coach

    Hi Allen,

    Regarding you question on whether we may be able to see this capability of having payments which are unaccounted in the fact table in 24R2. I do not see any Enhancement Request that has been accepted for this so the answer is 'No'.

    I don't think this will ever be a part of the OOTB content since this is a Data Warehouse that contains historical data and INVOICE_ACCOUNTING_STATUS_CODE = 'UNACCOUNTED' means the record is not yet historical.

    On the other hand, if many customers use the Idea Lab to request this enhancement to the OOTB content, it may be added by popular demand.

    Please feel free to log an Enhancement Request in Fusion Analytics Warehouse Idea Lab:

    https://community.oracle.com/products/oracleanalytics/categories/idealab-fusion-analytics

    Regards,

    John

  • AllenN
    AllenN Rank 1 - Community Starter

    Thanks John, per one of the earlier comments, we are seeing where unaccounted invoices are appearing in that fact table, but unaccounted payments don’t seem to exhibit the same behavior (they must be accounted).

    We can create an idea but wanted to get a sense as to the “why” behind what appears to be different behavior for invoices and payments.

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics Coach

    Hi Allen, You would probably need to log a SR to determine the "why" as it could take some digging.

    To start, We would need to know the invoices in DW_AP_SLA_INVOICE_SCHEDULE_CF where INVOICE_ACCOUNTING_STATUS_CODE is 'UNACCOUNTED' and the data from AP_INVOICES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL for the same invoices.