-
Forums
-
- Applications (SaaS)
-
Marketing, Sales, and Service
Marketing, Sales, and Service
DashboardB2C Service
Field Service
Marketing
-
Human Capital Management
Human Capital Management
DashboardTalent Management
-
Enterprise Resource Planning
Enterprise Resource Planning
DashboardRisk Management
Project Management
Reporting and Analytics
Integrations, Extensions, and Security
-
Supply Chain Management
Supply Chain Management
Dashboard -
Reporting and Analytics
Reporting and Analytics
DashboardSolutions for Applications (OTBI)
- Reporting & Analytics for HCM
- Reporting & Analytics for Taleo Enterprise (TEE)
- Reporting & Analytics for Taleo Midsize (TBE)
- Reporting & Analytics for Taleo Learn
- Reporting & Analytics for ERP
- Reporting & Analytics for SCM
- Reporting & Analytics for Sales
- Reporting & Analytics for B2C Service
- OBIEE for Applications
Business Analytics
- Applications Security
-
More
More
Public Sector
Oracle Education
-
Infrastructure (IaaS)
and Platform (PaaS)Infrastructure (IaaS) and Platform (PaaS)
DashboardContent and Experience
Business Analytics
Security
System Management
-
Partners
OPN Technical Assistance Forums for Partners
BUILD: Partner Technical Assistance
For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
SERVICE: Partner Technical Assistance
For partners that provide implementation or managed services around Oracle Cloud Applications
- Announcements
Forums
Use our discussion forums to pose questions, explore ideas, and discuss Oracle Applications. -
-
Ideas
-
- Applications (SaaS)
-
Marketing, Sales, and Service
Marketing, Sales, and Service
My IdeasMarketing, Sales, and Service
-
Human Capital Management
Human Capital Management
My Ideas -
Enterprise Resource Planning
Enterprise Resource Planning
My Ideas -
Supply Chain Management
Supply Chain Management
My Ideas -
Reporting and Analytics
Reporting and Analytics
My IdeasReporting and Analytics
-
More
More
My IdeasPublic Sector
Oracle Education
-
Platform (PaaS)
Platform (PaaS)
My Ideas
Ideas
Share your ideas on product enhancements, vote, and comment on your favorite ideas. -
-
Events
-
Events
Sales and Service
Human Capital Management
-
- Contribute
- Hall of Fame
- Learning
- Success
- Documentation
- Support
Comments
- posted November 14, 2019 in Reporting and Analytics for ERP
- Permalink
Great !
Thanks for the quick update.
Regards,
Madhu
- posted November 13, 2019 in Reporting and Analytics for ERP
- Permalink
Thank you so much for this document.
Appreciate if you can update this with 19D.
- posted November 6, 2019 in Human Capital Management > Risk Management
- Permalink
Hi Roop,
This is not specific to Conflicting Roles. Question is generic. As we have commonly used reports in other modules, sharing center.
I want to know if anyone using custom BIP/OTBI reports and any issues they are facing.
Thanks,
Madhu
- posted November 6, 2019 in Human Capital Management > Risk Management
- Permalink
Very useful !
Thanks.
- posted November 6, 2019 in Applications Security
- Permalink
We have similar request too but we didn't find any way.
Hope any expert here can comment.
- posted October 21, 2019 in Reporting and Analytics for ERP
- Permalink
Very Useful one.
Thanks!
- posted July 16, 2019 in Reporting and Analytics for ERP
- Permalink
2) If you want to access the report's output and show only User's Cost center. Then try below
SELECTNVL((SELECT DISTINCT gcc.segment3FROM per_all_assignments_m paam,per_periods_of_service ppos,gl_code_combinations gcc,per_users usrnmWHERE usrnm.person_id = paam.person_idAND ppos.person_id = paam.person_idAND ppos.period_of_service_id = paam.period_of_service_idAND gcc.code_combination_id = paam.default_code_comb_idAND paam.primary_assignment_flag = 'Y'AND paam.assignment_type IN ( 'E','C')AND paam.assignment_status_type ! = 'INACTIVE'AND TRUNC(SYSDATE) BETWEEN paam.effective_start_date AND paam.effective_end_dateAND upper(usrnm.username) = upper(:xdo_user_name)--Exception - Roles/UsersAND NOT EXISTS (SELECT 1FROM per_user_roles pur,per_roles_dn_vl prdvWHERE pur.role_id = prdv.role_idAND pur.user_id = usrnm.user_idAND (role_name LIKE 'XX AP Inquiry%' ORrole_name LIKE 'XX PO Inquiry%' ORrole_name LIKE 'XX PO Buyer%'))),'ALL') User_CCFROM DUALThen pass this result to main query and use gl_code_combinations.segment3Thanks,Madhu- posted July 16, 2019 in Reporting and Analytics for ERP
- Permalink
Hi Abhishek,
Hi ,See if below query is useful for you .. If you want to build it based on 'Manage Data Access for Users' (or Business Unit)..SELECT Users.username ,asg.role_name,(SELECT Bu.BU_NAMEFROM fusion.FUN_ALL_BUSINESS_UNITS_V BuWHERE Bu.bu_id = Asg.org_idAND SecMap.OBJECT_NAME = 'FUN_ALL_BUSINESS_UNITS_V'AND ROWNUM =1) AS BU_NAME,(SELECT PK1_COLUMN_NAMEFROM fusion.FND_OBJECTS ObjWHERE obj.obj_name = secmap.object_name) AS SECURITY_CONTEXTFROM FUN_USER_ROLE_DATA_ASGNMNTS asg,fusion.PER_USERS Users,fusion.FUN_ROLE_DATA_SECURITY_MAPPING SecMapwhere Users.USER_GUID = Asg.USER_GUIDAND Asg.ROLE_NAME = SecMap.ROLE_NAMEAND UPPER(Users.username) = :p_userorder by asg.creation_date desc,asg.last_update_date descThanks,Madhu- posted July 9, 2019 in Applications Security
- Permalink
Thanks Linda and Abdul. This is really useful.
- posted June 27, 2019 in Reporting and Analytics for ERP
- Permalink
Hi ,
You can enable the at the ESS Job definition level. Go to the specific job definition, click 'Show more' in the header. Then choose the Database Trace LOV.
But to access the Log generate you need to have a specific role(kind of Admin) , I'm not sure about it.
Thanks,
Madhu
Trace.JPG (209KB)- posted June 27, 2019 in Reporting and Analytics for ERP
- Permalink
Great Senthil!
Marks it as resolved. It will help others in future.
Thanks,
Madhu
- posted June 27, 2019 in Reporting and Analytics for ERP
- Permalink
Hi Manish,
I don't think that is possible but you can try.
Please refer below and screenshot
Creating a Data Set Using a Content Server as DataSource
Thanks,
Madhu
UCMRep.PNG (141KB)- posted June 26, 2019 in Reporting and Analytics for ERP
- Permalink
Hi Senthi,
We also had same issue and resolved after adding the required roles.
Oracle Support gave us the Data Security Policies required to have access.
1) Grant On GL Ledgers ::: Ledger for Table GL_LEDGERS Read;Update;Report Oracle Fusion General Ledger;View Accounting Period Status; Actions
2) Subledger Application :: Subledger Application Manage Subledger Application Data; Actions
3) Subledger Source Transaction :: Subledger Source Transaction Manage Subledger Source Transaction Data; Actions
4) Subledger Accounting Ledger :: Subledger Accounting Ledger Read;Manage Accounting Period Status;Report Oracle Fusion General Ledger;Manage Ledger for Subledger Data;View Accounting Period Status;Update; Actions
5) Grant on Business Unit :: Business Unit Review Receipt Accounting;Run Accounting Period Close Exceptions report;Create Payables Payment Request;Report Payables;Manage Supplier Negotiation as Procurement Agent;View SupplierRefer below post :
https://cloudcustomerconnect.oracle.com/posts/784cc01212
Thanks,
Madhu
- posted June 26, 2019 in Reporting and Analytics for ERP
- Permalink
Hi ,
For incremental extract , you can create ESS job of type BIP.
In the BIP report datamodel query refer table ESS_REQUEST_HISTORY for the last run date. Then use this as reference ( like -poh.creation_date > last_run_date) in your main query to fetch latest/incremental data only.
Thanks,
Madhu
- posted June 26, 2019 in Reporting and Analytics for ERP
- Permalink
Hi Hari,
Mark this as resolved if you think it is.
Thanks,
Madhu