To view the disabled or hidden options in oaf page oracle apps

To view the disabled or hidden options in oaf page oracle apps:

the profile option ‘Disable Self Service Personalization’ is enabled so that  can view some of the hidden fields.

go to order management setup->customers->standard->

Query the customer 157661

Click on the Details and click on Account Profile these account profiles are all hidded inside.

Only it will enable if profile option is set.

Use of system administrator request Groups and responsibility in Oracle Apps R12

System Administrator -> Request Groups and Responsibility:

When a concurrent program is created it should register in request groups. so that one can submit the report in the assigned responsibility.

For example:

One should register a report that should run in order management setup means.

First go to system administrator-> security->user->define->query->Order Management Setup

Then in the screen shot the Request Group name OM Concurrent Programs is there. Copy that Request group name and go to security->responsibility->request

Query the copied request group and add the concurrent program by choosing type as program and name as concurrent program name and the application whether that is standard or custom defined while creating a ccp.

Code with substr and instr in oracle apps r12

Code with substr and instr in oracle apps r12

select SUBSTR('XLOGIC HIBM-CHI',9,INSTR('XLOGIC HIBM-CHI','-',1)-9) from dual;

Value returns as IBM

To find the table name by using the column name

To find the table name by using the column name:

select * from all_tab_columns where Upper(column_name) like Upper('Payment%Method%');

Payment%Method% is the column name

for my use - unix send mail program with output attachment has uploaded in google drive

unix send mail program with output attachment has uploaded in google drive in rma transactions report folder. In qlogic_Send_mail.prog file contains the unix commands in which mail will take the body message from a file in one directory.

fndload commands Key Flexfield and Descriptive Flexfield descriptions

KFF - Keyflexfields are used throughout the Applications to uniquely identify informations such as GL accounts, INV items, FIxed Assets and other entities that every business needs to keep track of. 
We can't able to create a new kff but we can modify the existing one

DFF- Descriptive flexfields enable you to capture additional pieces of information from transaction entered into Oracle EBS.

DFF and KFF share common features. They are multisegment fields. Application validates individual segments based ons makes valueset rules and ensures that the segments makes sense using CVR (cross-validation rules).

Context Sensitive Segments  in DFF:

Context Sensitive Segments are conditional DFFs. Only when a condition  is met a particular field 'appears' and we are able to capture details. So for that first DFF is made context sesitive and then second one if made reference.

DFF has two types of segments

1. Global Segments
2. Context Sensitive Segments

Context Sensitive Segments depends on value of another field. 

REFERENCE Field - If the context sensitive information is derived from a field in the form, then that field is called as a Reference Field.

CONTEXT Field - If the context sensitive information is derived from a field / segment in the DFF pop up windown, then that field is called as a Context Field.

Downloading a ldt file for dff 

Download command

FNDLOAD un/pwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct address.ldt DESC_FLEX P_LEVEL=:COL_ALL:REF_ALL:CTX_ONE:SEG_ALL? APPLICATION_SHORT_NAME="AR" DESCRIPTIVE_FLEXFIELD_NAME="Remit Address HZ"

query below using title to get the DESCRIPTIVE_FLEXFIELD_NAME


select * from apps.FND_DESCRIPTIVE_FLEXS_VL where title='Address';

p_context_code is not used in the fndload download command because not using this for downloading a specific code in the screen shot if needed to downlaod specific code then below command is used


FNDLOAD:

FNDLOAD un/pwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct filename.ldt DESC_FLEX P_LEVEL=:COL_ALL:REF_ALL:CTX_ONE:SEG_ALL? APPLICATION_SHORT_NAME="AR" DESCRIPTIVE_FLEXFIELD_NAME="Remit Address HZ"
p_context_code='give the code name'


Upload Command:

FNDLOAD un/pwd 0 Y UPLOAD @FND:patch/115/import/afffload.lct filename.ldt custom_mode=FORCE

Query to find active customer accounts and sites in oracle apps r12

Query to find active customer accounts and sites in oracle apps r12:

SELECT
       hp.party_name                        "PARTY_NAME",      
       hp.party_number                      "PARTY_NUM",
       DECODE(hp.status,
              'A', 'Active',
              'I', 'Inactive',
              hp.status)                    "Party Status",
       hca.account_name                     "ACCOUNT_NAME",
       hca.account_number                   "ACCOUNT_NUM",
       DECODE(hca.status,
              'A', 'Active',
              'I', 'Inactive',
              hca.status)                   "Account Status",
       hcas.creation_date                   "SITE_CREATE_DT",
       DECODE(hcas.status,
              'A', 'Active',
              'I','Inactive')                   "Site Status",
       hps.party_site_number                "PARTY_SITE_NUMBER",
       hou.name                             "ORG",
       hcsua.site_use_code                  "SITE_USE_CODE",
       hcsua.location                       "LOCATION",
       col.name                             "COLLECTOR",
       hcpc.name                            "PROFILE_CLASS",
       rt.name                              "PAY_TERM",
       hcp.Credit_rating                    "CREDIT_RATING",
       hcp.credit_checking                  "CREDIT_CHECKING",
       hcp.credit_hold                      "CREDIT_HOLD",
       hcp.tolerance                        "TOLERANCE",
       hcp.override_terms                   "OVERRIDE_TERMS",
       hcpa.trx_credit_limit                "TRX_CREDIT_LIMIT",
       hcpa.overall_credit_limit            "OVERALL_CREDIT_LIMIT",
       arsc.name                            "STATEMENT_CYCLE",
       hl.address1                          "ADDRESS1",
       hl.address2                          "ADDRESS2",
       hl.address3                          "ADDRESS3",
       hl.address4                          "ADDRESS4",
       hl.city                              "CITY",
       hl.state                             "STATE",
       hl.postal_code                       "ZIP_CODE",
       hl.country                           "COUNTRY"
  FROM
       hz_parties              hp,
       hz_party_sites          hps,
       hz_cust_accounts_all    hca,
       hz_cust_acct_sites_all  hcas,
       hz_cust_site_uses_all   hcsua,
       hz_customer_profiles    hcp,
       hz_cust_profile_classes hcpc,
       hz_cust_profile_amts    hcpa,
       hz_locations            hl,
       ar_collectors           col,
       AR_STATEMENT_CYCLES arsc,
       hr_operating_units hou,
       ra_terms rt
 WHERE
       1=1
   AND hp.party_id            =  hca.party_id
   AND hca.cust_account_id    =  hcas.cust_account_id(+)
   AND hps.party_site_id(+)   =  hcas.party_site_id
   AND hp.party_id            =  hcp.party_id
   AND hca.cust_account_id    =  hcp.cust_account_id
   AND hps.location_id        =  hl.location_id(+)
   AND col.collector_id       =  hcp.collector_id
   AND hcp.cust_account_profile_id = hcpa.cust_account_profile_id
   AND hcas.cust_acct_site_id=hcsua.cust_acct_site_id
   AND hcp.statement_cycle_id=arsc.statement_cycle_id
   AND hcas.org_id=hou.organization_id
   AND hcpc.profile_class_id=hcp.profile_class_id
   AND hca.payment_term_id=rt.term_id(+)
   AND hp.party_type          = 'ORGANIZATION'    -- only ORGANIZATION Party types
   AND hp.status              = 'A'               -- only Active Parties/Customers
   AND hca.status = 'A'    --Only active sites
   AND hcas.status = 'A'   -- Only active sites
   AND  hcsua.site_use_code='BILL_TO'
   AND hou.name in ('US Operating Unit','IE Operating Unit')
   --AND hp.party_name like 'DELL%'
   --AND hca.account_number='11506'
   ORDER BY TO_NUMBER(hp.party_number), hp.party_name, hca.account_number;