Oracle apps R12 AR SQL Query to get Customer Address details

Hi All, Please find belwo the SQL Query for Oracle Apps R12 – to get Customer Address details . Comment the Account Number condition to get it for all Customer Data SELECT          HCA.ACCOUNT_NUMBER          CUSTOMER_NUMBER,                 HP.PARTY_NAME               CUSTOMER_NAME,                 HPS.PARTY_SITE_NUMBER       CUST_SITE_NUMBER,                 HL.ADDRESS1                 ADDRESS_LINE1,                 HL.ADDRESS2                 ADDRESS_LINE2,                 HL.ADDRESS3                 ADDRESS_LINE3,                 HL.ADDRESS4                 ADDRESS_LINE4,                 HL.CITY                     CITY, […]

Read More

Create Request Groups in Oracle Apps for submission of Concurrent Programs

Request group is required to allow submission of concurrent programs or request set from a specific responsibility. First request group is created, then programs/request sets are added to request group. Request group should be assigned to a responsibility from which we want to submit a program. Logon to ‘System Administrator’ responsibility. Go to Security-> Responsibility […]

Read More