DW_AP_SLA_PAYMENT_CF PAYMENT_ACCOUNTING_STATUS_CODE column

Keith Antone

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.

Mallikarjuna Kuppauru-Oracle

Hi @User_05NC2

Yes, this table will capture only accounted records only.

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

Regards,

Arjun

Subha_Tripathy-Oracle

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

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

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

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

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

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

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

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.