Wednesday, 24 March 2021

Oracle Fusion Application Composer: How to upload Bulk data in Custom Object

 

Oracle Fusion

Application Composer:

How to upload Bulk data in Custom Object

 


Requirement: Need to upload bulk data in the custom object.

 (To Learn More About Application Composer Visit Oracle Fusion: Application Composer)

Step1:

Below is the custom object home page. I need to upload bulk data in this object.


Step2:

Click on Navigator > Tools > Import Management


 

Step3:

Click On “Import Objects


Step4:

Enter your custom object name ‘PO_REF’. Click on Download button.


 

Step5:

Open the downloaded .CSV file. Enter the required data field values and save the file.



 

Step6:

Navigate to the “Import Queue” tab. Click on “Create Import Activity”

 


Step7:

Enter Name, Description. Select Object Name from LOV. Select .CSV file.


 

Step8:

Click On Validate Data. Once Validation completed click on the “Close” button.


 



 

 

Step9:

Click on Next. Click on Submit.

 


 


Step10:

Click on Hyperlink.


 

Step11:

It will show the progress of the bulk upload process. Once Process completed 100% Click on Done.

 




Step12:

Navigate to Custom Object Screen. We can able to check bulk uploaded data available in the custom object main screen.

 


 

Tuesday, 9 March 2021

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