Steps for Report Development…. 1. Develop the report as per client requirement using the Report-6i tool. 2. Move the report (.rdf) file from local machine to respective path in the server. If client have the CUST_TOP then move into Cust_Top else move it to the related Standard Top.Custom Top – CUST_TOP/ 11.5.0/ Report/ US/ .rdf […]
SELECT hca.account_number,rc.customer_name, hp.party_type,hp.party_name FROM hz_parties hp, hz_Cust_Accounts hca,ar.ra_customers rcWHERE hp.party_id = hca.party_idand rc.customer_id=hca.cust_Account_id AND hca.cust_account_id IN ( SELECT customer_id FROM ap_bank_account_uses_all bauses, ap_bank_accounts_all bacct WHERE bauses.external_bank_account_id = bacct.bank_account_id AND primary_flag = ‘Y’ GROUP BY customer_id) HAVING COUNT (DISTINCT (external_bank_account_id)) > 1)
Oracle Application Object Library uses values; value sets and validation tables as important components of key FLEXFIELDs, descriptive FLEXFIELDs, and Standard Request Submission. This section helps you understand, use and change values, value sets, and validation tables. When you first define your FLEXFIELDs, you choose how many segments you want to use and what order […]
Navigation Path for Value Set Creation:Application-> Validation -> Set.Once we create Independent & Dependent valueset then we can attach values to the valueset by using the following Navigation.Application -> -> Validation -> Values (To create values for value set)NOTE: Once we attach any value to Independent & Dependent we can’t delete that value, but we […]
Oracle Applications Standards for New Report Developments…For developing a Report in Oracle Applications we should follow three standards.1. Creation of Bind Variable – P_CONC_REQUEST_ID: We must create a Bind Variable called “P_CONC_REQUEST_ID” (We can’t change this name. It is standard name.). If we run Conc. Prgm. from SRS window, it will give a Request ID. […]
Recent Comments