Tuesday, January 2, 2024

OIC - ERP - Payables invoice callback - Custom report

Usecase: Here, we will customize the payable invoice callback and get a detailed report from ERP.

Implmentation steps:

  1. Subscribe the callback
  2. Check if jobname ="Load Interface File for Import" then 
    1. save the load request id and load status 
    2. Call a BI report to get the Source name based on Load request id (https://soalicious.blogspot.com/2024/01/oic-erp-get-source-name-for-invoice.html)
  3. Update path : Fetch FTP or S3 bucket path details from where we need to download the processed zip file or achive the processed file. We will use a simple Lookup like OIC_Interface_Path.dvm and store source name and path  and from integration, fetch the path based on source name (fetched from previous step) using lookup() function.
  4. Get the Processed zip file from FTP or S3 Bucket processing directory invoking a child integration. (https://soalicious.blogspot.com/2023/11/oic-get-files-from-aws-s3-rest-service.html)
    1. Provide directory name
    2. filePattern as $loadRequestId
    3. Unzip flag = N
  5. Check Load status
    1. If Load status != SUCCEEDED then Archive the source zip file calling a child integration. With .Failed appended file name. (https://soalicious.blogspot.com/2023/12/oic-create-resuable-integration-to.html)
    2. Otherwise, if Jobname ="Import Payables Invoices" ans status = SUCCEEDED then, 
      1. Validate the AP Invoice: Call ESS job and feed inputs parameters like business unit id, source, ledger id etc. JobPackageName: /oracle/apps/ess/financials/payables/invoices/trandactions/ and jobDefinitionName: APXAPRVL
      2. Monitor the AP invoice : Call a child integration and pass ess job run request id and get the status (https://soalicious.blogspot.com/2024/01/oic-erp-monitor-progress-of-ess-job-and.html)
      3. Initiate invoice approval: Call ESS job and feed inputs parameters like business unit id, source etc. JobPackageName: /oracle/apps/ess/financials/payables/invoices/trandactions/ and jobDefinitionName: APXIAWRE
      4. Archive the file.
  6. Get detailed BI report file (https://soalicious.blogspot.com/2024/01/oic-erp-invoice-bi-report-sql-query-to.html)
  7. Save the report to a ftp or S3 directory for further processing.
  8. Send a Notification with the report. Or we can call ESS job and send mail over BI bursting (https://soalicious.blogspot.com/2024/01/oic-erp-send-custom-invoice-report.html)

No comments:

Post a Comment

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...