Skip to Main Content
Forums

SQL Developer Data Modeler

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.

Facing issue in Lexical Parameter while customizing AR Invoice Print Standard report in Oracle?

User_8VXM0Dec 13 2022

Hi,
We are customizing the standard AR Invoice Print Report . in that we have lexical clauses like (&P_DYNAMIC_FROM_CLAUSE,&P_DYNAMIC_WHERE_CLAUSE). When we are commenting this out in our query we are able to get the data, but once we re-add these clauses then our data is not coming. We need these clauses because if we comment out then we would not be able to see invoices from the application.
If anyone came across the issue please let me know!
Attaching the sql query for the reference
Credit Memo header.txt (40.32 KB)

Comments

Post Details

Added on Dec 13 2022
#sql
1 comment
416 views