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!

APEX 21.1 - Which technique do you use to make APEX reports similar this ?

User_GPTK0Aug 6 2021 — edited Aug 6 2021

I know how to do the report below in Python and Delphi, but I need to do it in Apex 21.1
I made several reports in Apex, but I have no idea how to start this one.
-----------
I have a table named Account
fields:
ID
Bank Name
Date
InitialAmount
Sample Data:
TD Ameritrade 2021/06/01 US$ 300
Bank of America 2020/04/20 US$ 100
Wells Fargo 2018/04/20 US$ 150
----------
And a Table named Transactions
fields:
ID
Bank Name
Date
Type (Debit or Credit)
Description
Amount
Sample Data:
Wells Fargo 2021/05/18 US$ 22 Debit
TD Ameritrade 2021/06/23 US$ 40 Debit
Bank of America 2021/04/20 US$ 90 Credit
TD Ameritrade 2021/08/01 US$ 20 Credit
Bank of America 2021/04/15 US$ 50 Debit
TD Ameritrade 2021/08/03 US$ 100 Debit
----
I need a Report similar this: (choose a Bank Name and display a report)
Date BankAccount TransferAmount Balance
TD Ameritrade 2021/06/01 US$ 300 (Inicial Amount)
TD Ameritrade 2021/06/23 (**-US$ 40) US$ 260 (US$ 300-40)
TD Ameritrade 2021/08/01 US$ 20 US$ 280 (US$ 260+20)
TD Ameritrade 2021/08/03 (-**US$ 100) US$ 180 (US$ 280-100)
Thank you

Sample_Transactions.png (72.87 KB)

Comments

Hadar Paiss

Hi,
There are few issues in the upgrade that might arise concerning logins:
with default install oracle 19 password are case sensitive
The password 'format' changed. You can check in dba_users
You might need to add to sqlnet.ora the parameter SQLNET.ALLOWED_LOGON_VERSION_SERVER=11
look into https://docs.oracle.com/en/database/oracle/oracle-database/18/spmsu/finding-and-resetting-user-passwords-10g-password-version.html#GUID-D7B09DFE-F55D-449A-8F8A-174D89936304
It will cover some of it.
Regards,
Hadar

User_YAOJZ

Thanks Hadar. The password issue I knew about. I added the code to SQLNET.ORA in both the oracle_home/network/admin folder and the instantclient/network/admin folder and now get an ORA-12504 error.
I added both a tnsnames.ora and listener.ora files to both folders (with appropriate settings) but can't get past the 12504 error.
Any ideas? Greatly appreciated!
tnsnames.ora (orcltest is name of database, brian-surface4 is name of PC)
LISTENER_ORCLTEST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Brian-Surface4)(PORT = 1521))

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

ORCLTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Brian-Surface4)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcltest)
)
)
listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oracle\WINDOWS.X64_193000_db_home)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\oracle\WINDOWS.X64_193000_db_home\bin\oraclr19.dll")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Brian-Surface4)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

User_B9CRX

Just to clarify, do you mean you upgraded the database the app is still at Legacy 11g app client? You are testing this where the database and client are on the same host?

1 - 3

Post Details

Added on Aug 6 2021
#apex, #apex-discussions, #reporting
1 comment
161 views