nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

print bar code

SQLWrangler

Find more posts tagged with

Accepted answers

SQLWrangler

Bhashar,

Thank you for the response a colleague just got back to me with this solution querying ASCM tables and it works.

SELECT ppnf.full_nameFROM per_users pu,per_person_names_f ppnfWHERE pu.username = fnd_global.user_nameAND pu.person_id = ppnf.person_idAND UPPER(ppnf.name_type) = 'GLOBAL'AND TRUNC(SYSDATE) BETWEEN ppnf.effective_start_date AND ppnf.effective_end_date

All comments

Bhaskar Konar

Hi @SQLWrangler,

Welcome to the Oracle Analytics & AI Community!

Could you please share a bit more information about your issue or requirement? This will help us better understand your situation and, if needed, replicate it to find a potential resolution.

Thank you.

SQLWrangler

Bhashar,

Thank you for the response a colleague just got back to me with this solution querying ASCM tables and it works.

SQLWrangler

The last line may not be needed:

TRUNC(SYSDATE) BETWEEN ppnf.effective_start_date AND ppnf.effective_end_date

Top Leaders

Gianni Ceresa 329

Malik Sikandar Hayat 155

Brendan T 105

bae15 105

User_TD15Q 75

Top Posts

OAS 2026 SSO/SAML Configuration Documentation
Hi Team, We would like to raise an enhancement request for the SSO/SAML configuration guidance for OAS 2026. We have already raised multiple SRs regarding OAS 2026 SSO configuration. However, we are facing difficulties getting the required guidance, as the available documentation does not clearly cover the OAS 2026 SSO…
Historical Reporting in OAC
We are planning to archive the Contract and Lease data currently sourced from the External Source as Contract and Lease accounting functions are being migrated to Oracle's CLM and Lease Accounting modules. At this stage, only active and partially closed records are being converted into Oracle and the remaining historical…
Trying to average a calculation row in a table
The difference column is a calculation, and I would like to average that row.
Complex filter issue. How do I do this
We are trying to convert our OAS reports to OAC and one of the parameters in the where clause of the report is what I am trying to make in OAC. I created a calculation as follows and I am trying to put it into a filter . The code validates EVALUATE('GREATEST ( TRUNC ( NVL (%1, TO_DATE (''1/1/2013'', ''mm/dd/yyyy'') ) ),…
Parameter Referencing is not working in OACS DV
Hi , I am calling one parameter in another parameter and it is not working. 1st parameter is showing values, while calling the 1st parameter in second it is not showing any values. Regards, Sree Hari M