I have an issue on Need for sales rep assistance notification mail in oracle EBS.Mail sending to the address with out any issue.But mail does not having "EDETAILWITHTAX details.Means Product , # of Units Shippable? , Net Amount are missing.I have set required Profile option also.My mail as like below.
Product # of Units Shippable? Net Amount
Shipping and Handling: $25.00
Tax (estimated): $0.00
IMPORTANT: Do not reply to this email. If you need to contact us, send
an email to [Customer Care Email Id].
Thank you again for shopping with us.
Edited by: 993255 on Mar 12, 2013 3:34 AM
What i need to do for getting product,unit of shippable,net amount?
Edited by: 993255 on Mar 12, 2013 3:38 AM
You will have to debug into procedure ibe_workflow_pvt.Generate_Detail
this procedure is resposible for population of "EDETAILWITHTAX .
Try executing various queries from this procedure by replacing l_quote_id with quote_header_id.