Venky DevMastery

Fetch employee's work/personal and manager's email address?   SELECT GL.person_id KEY, 'Template Name' TEMPLATE, 'en-US' LOCALE, 'RTF' template_format, 'PDF' output_format, 'EMAIL'  DEL_CHANNEL, 'Document Name'  OUTPUT_NAME, GL.work_email ||';'|| GL.Personal_Email || PARAMETER1, 'noreply@company.com' PARAMETER3, 'Email Body '  AS PARAMETER5, 'true'    PARAMETER6 FROM ( SELECT papf.person_id, haou_lemp.name      legal_employer, hla.address_line_1  work_address_line_1, hla.address_line_2  work_address_line_2, hla.address_line_3  work_address_line_3, hla.address_line_4  work_address_line_4, hla.region_2        work_state, hla.town_or_city    work_town_or_city, hla.postal_code     work_postal_code, hla.country         work_country, papf.person_number, (ppnf.first_name || ' ' || ppnf.last_name) Full_Name, ppos.actual_termination_date  Termination_Date, ppos.NOTIFI...

  Q: How to include multiple email addresses in Bursting the report? Created a new custom lookup “Venkat_EMAIL_IDS” to maintain email ids.  As length of email id can be more than 30 characters, we maintained them in Description field.  1.       Create a new data model. 2.       Create a LOV for email ids using SQL Query. NOTE: Please note that we could not find any solution if we use static list of email ids in the data model LOV.  Hence, email ids should come from a SQL query.   3.       Create a menu type parameter as shown below.  Please make a note of highlighted fields.    4.        Create a sample data model as below.  For demo purpose, I used below sample query.  5.       Add bursting query as shown below.   Here is full bursting query: SELECT    ...

 In Oracle Fusion SCM, you manage freight charges, duty charges, and rebate charges through various modules,  including   Pricing,   Order Management,   and potentially Transportation Management,   allowing for allocation, calculation, and tracking of these costs.  Here's a more detailed breakdown: 1. Freight Charges: Definition: Freight charges are costs associated with transporting goods, encompassing various elements like  transportation,  fuel,  and handling.  Management: Pricing: Define shipping cost types and pricing rules to calculate freight charges.  Order Management: Capture and manage freight charges at the sales order level.  Transportation Management: Integrate with TMS to automate freight cost updates.  Manual Entry: You can manually enter or override freight charges on sales orders.  Allocation: Allocate freight charges to specific item lines or across all lines on an invoice....

 Performance Tuning Tips: --> Do not select all the columns when you are fetching data from FusionDB because it will do full table scan(FTS) Instead use only required columns or Index columns. ---> Always limit the rows when fetching data. --> Use Proper Joins(Primary Key and Foreign Key relationship). --> Use Exists instead of IN. --> Use Hints.

How to Export  Images/Attachments/Documents from Oracle Fusion to Third-Party Apps: ===================================================  1st Methord: Navigate Tools--->click Export Management Oracle ERP application Fill details: name, export object, and file name. Select the Export attachment checkbox to include attachments in the export. After the activity completes, you can access the exported data, including the extracted attachments and then send to third party application. 2nd Method: Use REST API to get all the all attachments  https://docs.oracle.com/en/cloud/saas/human-resources/24d/farws/op-payslips-payslipsuniqid-child-documents-documentsuniqid-child-attachmentspreview-attachmentspreviewuniqid-child-attachment-get.html

 Finance Management: Accounting hub Reporting and analytics Payables and Assets (AP &FA) Revenue management Receivables (AR) Collections Expense management Joint venture management U.S. Federal Financials Project Management: Plan, schedule, and forecast Resource management Cost management and control Billing and revenue management Grant management Project asset management Procurement: Supplier Management Supplier Portal Sourcing Procurement Contracts Self Service Procurement Purchasing Payables Procurement Analytics Risk Management and compliance: ERP role and security design Separation-of-duties automation Continuous access monitoring User access certification Configurations controls Transactions controls Audit and SOX/ICFR workflows Enterprise risk management (ERM) Business continuity planning Enterprise Performance Management: Planning Profitability and cost management Account reconciliation Financial consolidation and close Tax reporting Narrative reporting Enterprise data ...