Receivables - EBS (MOSC)

MOSC Banner

need to print the invoice data in Email body through tabular format

edited Mar 11, 2024 1:19PM in Receivables - EBS (MOSC) 5 commentsAnswered

Oracle EBS R12

Oracle Receivables


Question : I have requirement where i need to send the Invoice Number and Due date , due amount and aging buckets information to customer as Email.

All the above details need to print in Email body and it should be Tabular format.

below are the example and it seems like alignment issue.

Can you explain how to display the data intabular format through plsql in email body.

Invoice Number      Amount Due             Due Date             Aging Bucket

             100057            $100.01                      21-JAN-24              31-60

              19244          $12520.45                      01-DEC-23             91-120

              19331          $21597.25                      03-JAN-24              61-90

              19485          $14449.57                      02-FEB-24              31-60

              19587          $20656.45                      02-MAR-24               1-30

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center