Introduction :
The below queries will help us to upload the output file in UCM server and send mail to respective mail id in fusion.
Upload file to UCM:
select
person_id as “KEY” — Split Key from data model SQL
, ‘T1’ TEMPLATE — Report template name
, ‘en-US’ LOCALE
, ‘PDF’ OUTPUT_FORMAT — Output type
, ‘WCC’ DEL_CHANNEL — To send to content server
, ‘FA_UCM_PROVISIONED’ PARAMETER1 — Content Server name
, ‘FAFusionImportExport’ PARAMETER2 — Security group
, ‘fusion.user1’ PARAMETER3 — Author of the file to be shown in content server
, ” PARAMETER4 — Account (Optional)
, ‘PersonAssignmentReport~’||TO_CHAR(SYSDATE, ‘DDMMYYHH24MISS’) PARAMETER5 — Title
, ‘PersonAssignmentReport~’||TO_CHAR(SYSDATE, ‘DDMMYYHH24MISS’)||’.pdf’ PARAMETER6 — Output File name
–Product_Status PARAMETER8, — Content ID (Optional)
, ‘false’ PARAMETER9 — Custom metadata (Optional)
, ” PARAMETER10 — Folder path to deliver files
from per_all_people_f where person_number = :p_person_number
send output in email:
select
person_id as “KEY” — Split Key from data model SQL
, ‘T1’ TEMPLATE — Report template name
, ‘en-US’ LOCALE
, ‘PDF’ OUTPUT_FORMAT — Output type
, ‘EMAIL’ DEL_CHANNEL — To send to content server
, ‘sivachandarancs@gmail.com’ PARAMETER1 –to email
, ” PARAMETER2 –CC
, ‘bipublisher-report@oracle.com’ PARAMETER3 –From Email
, ‘Person Assignment Details’ PARAMETER4
, ‘Hi.. Please find attached person assignment details.’ PARAMETER5
, ‘true’ PARAMETER6
, ‘donotreply@oracle.com’ PARAMETER7
from per_all_people_f where person_number = :p_person_number
Conclusion :
Sample bursting queries to send mail and upload the file in UCM server
