Ability for getting the current process ID via a function — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Ability for getting the current process ID via a function

102
Views
3
Comments

Description

I have a BIP report with the bustling feature, I built an ESS job and bind this BIP report.
When I run this ESS job in Scheduled Processes, the system will have a process ID, Please help provide the ability to get the process ID and apply it to the BIP data model.

 

Use Case and Business Need

Now I have a BIP report with the bustling feature, I built an ESS job and bind this BIP report.

When I run this ESS job in Scheduled Processes, the system will have a process ID and will send an output file to the client's FTP.  If we have a function that can get the current process ID, then the output file can include the process ID in the output file name sent. so that users can find the corresponding output file from their SFTP folder.

Original Idea Number: 58c2187b8b

1
1 votes

Submitted · Last Updated

Comments

  • Becky Alvarez
    Becky Alvarez Rank 3 - Community Apprentice

    Moved from Financials Idea Lab.

  • Valeriy Gorbunov-80491
    Valeriy Gorbunov-80491 Rank 3 - Community Apprentice

    Michelle,

    You've mentioned ESS, is it really Enterprise (Workflow) Scheduler Service (that what ESS is) or you meant BI Publisher Scheduler (which is BIP Scheduler, not ESS)? Because bursting, actually, works in BIP Scheduler.

    How would the customer know the "Process ID" to "find the corresponding output file from their SFTP folder" if the file name is including ID? You send them the ID separately (say by email) to identify the file needed? If yes, you can add any number generated (in Data Model SQL) to the bursting file name and provide it to the customer for identification. No Process ID is required, any unique string is good enough.

  • User_11JSL
    User_11JSL Rank 1 - Community Starter

    Got it, Thanks Valeriy.