Oracle Payable - Standard Utility Package Functions

 SELECT 

AI.INVOICE_NUM,

NVL (AP_INVOICES_PKG.GET_DISTRIBUTION_TOTAL (AI.INVOICE_ID), 0)

          DISTRIBUTION_TOTAL,

       AP_INVOICES_PKG.GET_POSTING_STATUS (AI.INVOICE_ID) POSTING_FLAG,

       AP_INVOICES_PKG.GET_APPROVAL_STATUS (AI.INVOICE_ID,

                                            AI.INVOICE_AMOUNT,

                                            AI.PAYMENT_STATUS_FLAG,

                                            AI.INVOICE_TYPE_LOOKUP_CODE)

          APPROVAL_STATUS_LOOKUP_CODE,

       AP_INVOICES_PKG.GET_PO_NUMBER (AI.INVOICE_ID) PO_NUMBER,

       -- AP_INVOICES_PKG.GET_RELEASE_NUMBER (AI.INVOICE_ID),

       AP_INVOICES_PKG.GET_RECEIPT_NUMBER (AI.INVOICE_ID) RECEIPT_NUM,

       AP_INVOICES_PKG.GET_AMOUNT_WITHHELD (AI.INVOICE_ID) AMOUNT_WITHHELD,

       AP_PREPAY_UTILS_PKG.GET_PREPAID_AMOUNT (AI.INVOICE_ID) PREPAID_AMOUNT,

       AP_INVOICES_PKG.GET_NOTES_COUNT (AI.INVOICE_ID) NOTES_COUNT,

       AP_INVOICES_PKG.GET_HOLDS_COUNT (AI.INVOICE_ID) HOLDS_COUNT,

       AP_INVOICES_PKG.GET_AMOUNT_HOLD_FLAG (AI.INVOICE_ID) AMOUNT_HOLD_FLAG,

       AP_INVOICES_PKG.GET_VENDOR_HOLD_FLAG (AI.INVOICE_ID) VENDOR_HOLD_FLAG,

       AP_INVOICES_PKG.GET_ENCUMBERED_FLAG (AI.INVOICE_ID) ENCUMBERED_FLAG,

       AI.GL_DATE GL_DATE,

       AP_INVOICES_PKG.GET_PERIOD_NAME (AI.GL_DATE, NULL, AI.ORG_ID)

          PERIOD_NAME,

       AP_INVOICES_PKG.SELECTED_FOR_PAYMENT_FLAG (AI.INVOICE_ID)

          SELECTED_FOR_PAYMENT_FLAG,

       AP_INVOICES_PKG.GET_UNPOSTED_VOID_PAYMENT (AI.INVOICE_ID)

          UNPOSTED_VOID_PAYMENT_FLAG,

       AP_INVOICES_PKG.GET_DISCOUNT_PAY_DISTS_FLAG (AI.INVOICE_ID)

          DISCOUNT_PAY_DISTS_FLAG,

       AP_PREPAY_UTILS_PKG.GET_PREPAYMENTS_APPLIED_FLAG (AI.INVOICE_ID)

          PREPAYMENTS_APPLIED_FLAG,

       AP_INVOICES_PKG.GET_PAYMENTS_EXIST_FLAG (AI.INVOICE_ID)

          PAYMENTS_EXIST_FLAG,

       AP_INVOICES_PKG.GET_PACKET_ID (AI.INVOICE_ID) QUERY_PACKET_ID,

       DECODE (

          AI.INVOICE_TYPE_LOOKUP_CODE,

          'PREPAYMENT', AP_PREPAY_UTILS_PKG.GET_PREPAY_AMOUNT_APPLIED (

                           AI.INVOICE_ID),

          0)

          PREPAY_AMOUNT_APPLIED

  FROM AP_INVOICES_ALL AI

Oracle Fusion BIP Report - Interactive Layout - Bar Graph need to show numeric values

Requirement:  How to enable numeric value on interactive layout Bar Graph Property in BIP Report.

Solution:

You can set Data Visible property Under the heading Chart Plot Area. Please find below a screenshot where I have highlighted the property to enable numeric value on the interactive layout.

Oracle Fusion ERP and SCM Cloud Application - Custom Object - SOAP Envelop - Request and Response Sample payload

 --ERP and SCM Cloud Application - Custom Object WSDL Link--

https://servername/fscmService/FscmCustomReferenceService?WSDL

1) CreateEntity

Create Entity

2) Find Entity

Find Entity

3) Get Entity

Get Entity

4) Update Entity

Update Entity