Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select List / Drop down not working correctly

Brian666HJul 1 2022

I have a drop down / select list of months.
SELECT MONTHCD val, TO_CHAR(TO_DATE(MONTHCD, 'MM'), 'MON') label
FROM PS_AP_MTCH_EXP_DTL@FINRPT
where YEAR_FROM = NVL(:P2_YEAR, NVL(:P2_YEARFROM, YEAR_FROM))
GROUP BY MONTHCD;
The list shows the VAL not the Label.
All examples show it in this order and I have other list on another page where the label is show.
I have no idea why it’s doing this.
I’ve changed it around thinking that was why the value was not getting passed but that didn’t fix it either.
Looking for suggestions
Thanks

Comments

JohnGoodwin
Answer

When installing if you select "Financial Management Server" it will automatically select the database clients so you must have deselected them, they are selected for a reason, obviously if you were connecting to SQL Server you would not need them selected.

It is also possible to use an existing Oracle client - Using an Existing Oracle Database Client

Cheers

John

Marked as Answer by JanGLi · Sep 27 2020
JanGLi

Damn i even searched the shared document for database client maybe i didn't searched property.

Well any way i have already started the re-installation

Thanks for always helping

QA

@John Goodwin

Do we still need DB client, when we use/specify jdbc connection string during config?

Thanks

A

JohnGoodwin 
1002763 wrote:
Do we still need DB client, when we use/specify jdbc connection string during config?

No you don't need a database client for the configuration.

1 - 4

Post Details

Added on Jul 1 2022
#apex-discussions, #apex20-2
0 comments
464 views