Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Apex 20.1 Page Designer not working Showing blank Page

M.broOct 12 2021 — edited Oct 12 2021

Hi All,
Oracle DB :12.2.0.1.0
Oracle Apex : 20.1.0
I installed Oracle apex with ORDS 19.2.0 and imported the application as well. I can able to view the login page but I tried to enter in Page designer I can't able to view properties (All pages same issue). I did not get any error messages.
Thanks in Advances
M.bro

This post has been answered by jariola on Oct 12 2021
Jump to Answer

Comments

Elco

It are not the tables :

CSF_ACCESS_HOURS_B

CSF_ACCESS_HOURS_TL

Elco

I don't know how I can do the relation with party_id and customer_name

I have now this SQL code:

SELECT

       hp.party_name

     , hca.account_number

     , hca.cust_account_id

     , hp.party_id

     , hl.address1

     , hl.address2

     , hl.address3

     , hl.city

     , hl.state

     , hl.country

     , hl.postal_code

         

FROM   hz_parties hp

     , hz_party_sites hps

     , hz_locations hl

     , hz_cust_accounts_all hca

     , hz_cust_acct_sites_all hcsa

     , hz_cust_site_uses_all hcsu

WHERE  hp.party_id = hps.party_id

AND    hp.party_id = hca.party_id

AND    hcsu.cust_acct_site_id = hcsa.cust_acct_site_id

AND    hca.cust_account_id = hcsa.cust_account_id

Elco

Does anybody has an idea?

Thanks in advange

Regards

Elco

1 - 3

Post Details

Added on Oct 12 2021
13 comments
2,055 views