Hi team, May I ask if there's any other advice? Does anyone have similar requirement that each buyer should be restricted to review their own PO content in reports developed using OTBI's Subject Area? Appreciated your suggestions. Thank you. Liwen

Hi @Nathan CCC, Thanks for your advice. We do have many departments doing purchasing under a single BU. E.g. for BU named "Taipei", we have departments of Administration, Legal, Operations…etc all creating Purchase Orders under "Taipei" BU. However, the purchasing items and the amount is not suitable to be shared across…

Hi all, Just to update on this so that in case anyone else got the same requirement, it can be resolved like this: Using OTBI-Analysis instead of BIP-Report with subject area of "Supplier - Supplier Real Time" to achieve it. This is because in Analysis, we may do Filters on the Assignment Inactive Date (set to >…

Hi, Posting my findings here which answered my own question: utilizing the Selection Steps and adding another step to "Remove" those BUs that I don't want them to be presented as individual columns, and then it works as expected. Please refer to below screenshot. The result is that in the Column, it would only having the 2…

Hi @User_AF8AH, For our Fusion environment, I would be able to select the "Destination" with either Email, or FTP, or content server (although I don't know what that is)… It seems that there's no such option for your environment? For us, we are using Fusion Cloud solution, the options are in place when we onboard. Need…

Hi @Bhaskar Konar, I would like to highlight that it's exactly the dates that the seeded reports changed by internal modifications/developments needs to be revealed clearly. Taking our case as example, we are in Cohort B. The quarterly upgrade dates are in Mar, Jun, Sep, Dec of 2024. While please refer to below screenshot,…

Following, thanks for any update in advance.

Hi @Raghavendra Raghunath-Oracle, We register our user accounts with each user's emails, so like mine, the user name is in fact "liwen_chiu@tslines.com". It seems that the per_users table only have the username or user account, not the display name. But the column "- Purchase Receipt Header Details > Created By" is using…

Hi @Nathan CCC, Thanks for providing that online document explaining the subject area, would take note of it for future cases. The roles indicated in that page answered my questions, I got Buyer role in test environment but not in production environment. Thanks much!! Liwen

Hi @MandeepGupta, You're right, I got a lot more roles in TEST… Then it seems that even if I got PR related roles in Production environment, I couldn't access the PR's approval history via an analysis? The PR related roles I have in PROD are: Advanced Procurement Requester Procurement Application Administrator Procurement…

Hi @Raghavendra Raghunath-Oracle, Welcome to this scenario! Thank you for joining us. I tried with the SQL and configure like this below, but it seems that it's still selecting all the users in the list, instead of only having my account selected as default. Is there anything else I should configure together with your…

Hi @Bhaskar Konar, @MandeepGupta, Thank you for your assistance, this is what I got: Thank you. Liwen

Hi @MandeepGupta, Thank you for your reply. I saw that post you provided, but it seems that we are not using the Workforce Management module, so when I tried with a Data Model to execute the SQL, there is nothing returned/available. I am thus need to look for other advice to achieve it, looking forward to your further…

Hi all, Just an update that thanks to the CCC experts, we later use "Receiving - Purchase Receipts Real Time" which is having "- Purchase Receipt Line Details"."Returned Quantity" field. Thank you Liwen

Hi @Sumanth V -Oracle, Thanks much on your prompt reply. I tried but not really able to get the "Session Variable" as you mentioned. Please refer to below screenshot, should I choose "Presentation Variable"? And which option I should go for the "Default selection" type? I put the options in the screenshot as well, please…

Hi team, May I ask if there's an Idea on this already? Thank you. Liwen

Hi team, We have the same requirement as the supplier names are having mixed upper case and lower case. The suppliers worldwide register their company name differently. Thus, to be able to cope with the upper case / lower case when doing search in a report is very important. Please refer to the detailed use case here:…

Dear @MandeepGupta, Thank you for your response. I then tried with the subject area of "Maintenance Management - Purchased Item Usage Real Time" with an Analysis type, but it seems that due to we are not using "Work Order", there's no data in the result… I've also tried another similar one which is "Manufacturing -…

Hi @Praveen Kumar Akkala-Oracle , May I ask if you can help to export the content of Doc ID 2730513.1? Would like to have the guidance as well. Very much appreciated on it. Liwen

Hi @Eliran Hadad , I am assuming the difference is on the customized Data Security Policies definition ESS_REQUEST_HISTORYthat you have. As I spot that you have a SQL on "JobDefinition://oracle/apps/ess/hcm/users/SyncRolesJob", and I found this code snippet online and tried at our TEST environment. The result shows that I…