You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Oracle R12 Query fetching no rows in Oracle Fusion.

edited Jul 16, 2020 4:59AM in Receivables & Collections 11 comments

Content

Hi,

We recently migrated our Oracle R12 to Oracle Fusion. We have developed some custom reports in our Old Oracle R12, we need to develop

it in Oracle Fusion. We face difficulty in finding tables and fields.

The below Oracle R12 Query for fetching no rows in Oracle Fusion. The query is to fetch "Account Status" details.

SELECT TO_CHAR(A.TRX_DATE,'RRRRMM') YYYYMM
,:P_DATE CURRDT
,A.ORG_ID ORG_ID
,ARC.PARTY_NUMBER CUST_NUM
,ARC.PARTY_NAME CUST_NAME
,HL.CITY CITY
,0 TRX_TYPE
,A.TRX_NUMBER INVOICE_NUM
,A.TRX_NUMBER TRX_NUM
,TRUNC(A.TRX_DATE) TRX_DATE

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!