Today's Messages (off)  | Unanswered Messages (on)

Forum: Client Tools
 Topic: SqlDeveloper tools in a secure environment
SqlDeveloper tools in a secure environment [message #681559] Tue, 04 August 2020 02:13
keenweng2001
Messages: 3
Registered: August 2020
Junior Member
we have a number of programmer who want to connect to the ORACLE Instance using SQLDeveloper. is there a way to force the 2FA (password + token) authentication when they login to the instance through the SQL Developer ?
Forum: Forms
 Topic: Image Rotation in Oracle form (11g)
Image Rotation in Oracle form (11g) [message #681533] Tue, 28 July 2020 01:36
mahmud732
Messages: 81
Registered: October 2009
Location: Dhaka
Member
How can I rotate an image loaded in forms runtime.

Advance thanks to all.

Regards

Sultan Mahmud
Forum: NoSQL
 Topic: Latest month Partition in hive
Latest month Partition in hive [message #681546] Wed, 29 July 2020 11:39
rohit_shinez
Messages: 139
Registered: January 2015
Senior Member
Hi Guys
I have a table in hive that holds daily date partition column

[code][
My_tab
part_col
2020-03-31
2020-03-30
2020-03-29
2020-04-30
2020-04-29
2020-04-28

/code]
I need the latest partition value i.e. 2020-03-30 reason being 2020-03-31 doesn't hold data. So latest month partition that holds data if i pass 2020-03 i.e.(YYYY-MM)
Forum: Reports & Discoverer
 Topic: Send report directly to network printer
icon8.gif  Send report directly to network printer [message #681538] Wed, 29 July 2020 01:14
a.mughees0009
Messages: 1
Registered: July 2020
Junior Member
Hi Friends! I'm searching something I couldn't search on internet for days.

Please guide me how to send report print directly to the printer without printing on screen.
I'm developing a POS system and need to print invoice

Here is the code I'm using, I guess I'm stuck on 'report_desname'

SET_REPORT_OBJECT_PROPERTY ('REP_OBJ',
REPORT_FILENAME,
PATH || REPORT_NAME || '.rdf');
V_REP_NAME := 'REP_OBJ';
V_REPID := FIND_REPORT_OBJECT (V_REP_NAME);
SET_REPORT_OBJECT_PROPERTY (V_REPID, REPORT_DESTYPE, PRINTER);
SET_REPORT_OBJECT_PROPERTY (V_REPID, REPORT_DESNAME, '\\172.16.6.12\HP LaserJet P2050 Series PCL6');
SET_REPORT_OBJECT_PROPERTY (V_REPID, REPORT_DESFORMAT,'dflt');
SET_REPORT_OBJECT_PROPERTY (V_REPID, REPORT_SERVER, REPORT);

Best Regards.
Forum: Application Express, ORDS & MOD_PLSQL
 Topic: ORDS OAUTH - How to preserve client (id and secret)
ORDS OAUTH - How to preserve client (id and secret) [message #681499] Fri, 24 July 2020 08:33
acam0008
Messages: 1
Registered: July 2020
Junior Member
We are on APEX 18.4, going onto 19.2.
Our ORDS is configured with OAUTH. We are wondering how to preserve/backup the client id and secrets?
Forum: Oracle Fusion Apps & E-Business Suite
 Topic: Processing Constraints
Processing Constraints [message #681497] Fri, 24 July 2020 02:15
ajayhareesh
Messages: 24
Registered: September 2016
Junior Member
Hi,

Just a quick question regarding Processing Constraints.

We have created a new processing constraint to restrict a column update on order line form and it works perfectly.

But when we try to update the column value from change order screen (custom), it in turn calls oe_order_pub and it is checking processing constraint again and restricting column update there too.

Is there any way we can define processing constraint to restrict update only on Order Line form?

Thanks,
Ajay
 Topic: Oracle Date Track - preserve future Effective Dates
Oracle Date Track - preserve future Effective Dates [message #681474] Tue, 21 July 2020 11:01
GOS-BT-Oracle
Messages: 1
Registered: July 2020
Junior Member
Fictional Example of Date Tracked Data:

01-JAN-2016 to 31-DEC-2016 YES
01-JAN-2017 to 31-DEC-2017 YES
01-JAN-2018 to 31-DEC-2018 YES
01-JAN-2019 to 31-DEC-2019 YES

On 01-JUL-2018, I want change YES to NO, make it an update, and change all future stuff - with one transaction

I *think* it would need to look like this: (using UPDATE_OVERRIDE mode)

01-JAN-2016 to 31-DEC-2016 YES
01-JAN-2017 to 31-DEC-2017 YES
01-JAN-2018 to 30-JUN-2018 YES
01-JUL-2018 to 31-DEC-2019 NO

But ideally, I'd want it to look like this (below). Is there a datetrack mode available for this, or would I need to make several updates, using a combination of UPDATE and CORRECTION mode?

01-JAN-2016 to 31-DEC-2016 YES
01-JAN-2017 to 31-DEC-2017 YES
01-JAN-2018 to 30-JUN-2018 YES
01-JUL-2018 to 31-DEC-2018 NO
01-JAN-2019 to 31-DEC-2019 NO




Current Time: Tue Aug 04 06:49:09 CDT 2020