Changing Oracle logo in Oracle Applications

Name of the Profile - Corporate Branding Image for Oracle Applications

Name of Image – Image_Name.gif (Provide Your Image Name)

Copy the Image to $OA_MEDIA directory.

Clear the Cache:

Navigation to clear the cache:

Responsibility -> Functional Administrator -> Core Services -> Caching Framework -> Global Configuration -> Clear All Cache -> Yes

Then Refresh the login page to see the new image

Table to get Environment Paths

FND_ENV_CONTEXT

XML Publisher in multiple Languages

Requirement:

Need to develop one template in which language (font) get changed
as we choose other country organization.

Solution:

1. Other language should be enabled on your oracle apps instance.
2. Create the concurrent program with output type as XML
3. Create Data Definition using XML Publisher Responsibility
4. Create template. At the time of creation of templete, enable Translatable check box and click Apply
5. Once template is uploaded, you will find two buttons. Export Translation and Upload Translation.
6. Click on Export Translation. XLF file will be opened.
7. In XLF file - e. g. source-language="en-US" target-language="fr-FR".Source is English and fr is for French language and FR is territory.
8. Update the target fields in French language. In the below example source field is in English language and target is in French language. This indicates that wherever the Invoice Date is present in RTF template it will be
replaced by the target field in french language.
<source>Invoice Date:</source>
<target>Date de facture:</target>
9. Update the same for all fields and finally import the updated translation file.

Matrix Report in XML Publisher

This report is number of JVs created per month per source wise.

Query:select je_source,to_char(date_created,'Mon-YY') Source_Month,count(je_header_id) je_count from gl_je_headerswhere to_char(date_created,'Q') = :p_quarter and to_char(date_created,'YYYY') = :p_year group
 by je_source,to_char(date_created,'Mon-YY')
RDF report:
    Total Number of JVs Quarterly

Source Name	GSource_MonthE	Total
GJE_SOURCE	G If exists: JE_COUNT end; E	999E
Total	G If exists: 999 end; E
O               G Close to JE_SOURCE - <?for-each-   group@section:G_SERVICE_NAME;./JE_SOURCE?><?sort:JE_SOURCE;'ascending';data-type='text'?>  JE_SOURCE - <?JE_SOURCE?><?variable@incontext:JS;JE_SOURCE?>         G close to Source_Month : <?for-each-group@column:G_SERVICE_NAME;./SOURCE_MONTH?> Source_Month - <?SOURCE_MONTH?> E  - <?end for-each-group?> G Near If Exists -  <?for-each-group@cell://G_SERVICE_NAME;./SOURCE_MONTH? IF Exists – <?if:count(current-group()[JE_SOURCE=$JS])?> JE_COUNT - <?current-group()[JE_SOURCE=$JS]/JE_COUNT?>  End; - <?end if?> E  - <?end for-each-group?> G in Total -  <?for-each-group@cell://G_SERVICE_NAME;./SOURCE_MONTH? IF Exists in Total – <?if:count(current-group())?> 999 in Total <?sum(current-group()/JE_COUNT)?> End if in Total: <?end if?> E in Total – <?end for-each-group?> 999 in Total Column - <?sum(//G_SERVICE_NAME[JE_SOURCE=$JS]/JE_COUNT)?> E in Total Column: <?end for-each-group?>

XML Publisher (BI Publisher) cell highlighting.

Color change in XML Publisher:

Requirement: If debit or credit value is greater than 1000 then it should become red.
XML File:<?xml version="1.0" encoding="WINDOWS-1252"?>
<!-- Generated by Oracle Reports version 10.1.2.0.2 -->
<XX_GROUP>
<accounts>
<account>
<number>1-100-3333</number>
<debit>100</debit>
<credit>300</credit>
</account>
<account>
<number>1-101-3533</number>
<debit>220</debit>
<credit>30</credit>
</account>
<account>
<number>1-130-3343</number>
<debit>240</debit>
<credit>1100</credit>
</account>
<account>
<number>1-153-3033</number>
<debit>3000</debit>
<credit>300</credit>
</account>
</accounts>
</XX_GROUP>
RTF Template:

Account	Debit	Credit
FE ACCOUNT	CH1100.00	CH2100.00 E

　The field definitions for the template are shown in the following table:

Default Text Entry	Form Field Entry	Description
FE	<?for-each:account?>	Opens the for each-loop for the element account.
ACCOUNT	<?number?>	The placeholder for the number element from the XML file.
CH1	<?if:debit>1000?><xsl:attribute xdofo:ctx="block" name="background-color">red</xsl:attribute><?end if?>	This field holds the code to highlight the cell red if the debit amount is greater than 1000.
100.00	<?debit?>	The placeholder for the debit element.
CH2	<?if:credit>1000?><xsl:attribute xdofo:ctx="block" name="background-color">red</xsl:attribute><?end if?>	This field holds the code to highlight the cell red if the credit amount is greater than 1000.
100.00	<?credit?>	The placeholder for the credit element.
EFE	<?end for-each?>	Closes the for-each loop.

The code to highlight the debit column as shown in the table is<?if:debit>1000?>
<xsl:attribute
xdofo:ctx="block" name="background-color">red
</xsl:attribute>
<?end if?>The "if" statement is testing if the debit value is greater than 1000. If it is, then the next lines are invoked.

That's it!!!

How to Use FND_STANDARD_DATE value set

Let’s take example of report – AP Invoices Paid in Time

Here GL_Date in Date parameter.

SELECT api.invoice_id, api.invoice_num, invoice_date, api.invoice_amount,

       api.vendor_name, api.vendor_number, apc.check_number, aps.due_date,

       apc.check_date

  FROM ap_invoices_v api,

       ap_payment_schedules_all aps,

       ap_invoice_payments_all aip,

       ap_checks_all apc

 WHERE api.invoice_id = aps.invoice_id

   AND aip.invoice_id = api.invoice_id

   AND aip.check_id = apc.check_id

   AND apc.check_date <= aps.due_date

   --and api.gl_date >= nvl(:p_gl_date,api.gl_date)

   AND api.gl_date >=

          NVL (TO_DATE (SUBSTR (:p_gl_date, 1, 10), 'YYYY/MM/DD'),

               api.gl_date)

That's it. Test the report through SRS window.

Stock Market in India Development of Stock Market in India

HRMS APIs

Below are use full API in HRMS most of time these API are used to migrate external data from legacy system to oracle apps Updating the Per_periods_of_service table using hr_ex_employee_api.update_term_details_emp  Terminate employee hr_ex_employee_api.actual_termination_emp  Applying the final process in the shared instance using hr_ex_employee_api.final_process_emp  Re – Hire Employee hr_employee_api.re_hire_ex_employee  Update  Existing Person in system hr_person_api.update_us_person  Hire New Emp hr_employee_api.create_us_employee  Costing pay_cost_allocation_api.create_cost_allocation  Load  Assignment hr_assignment_api.update_us_emp_asg  Load Update Assign Criteria hr_assignment_api.update_emp_asg_criteria  Note : Contact Person Id Is To Be Passed hr_contact_rel_api.create_contact  Note : Contact Person Id is passed as Null(default of API) hr_contact_rel_api.create_contact  Load Phones hr_phone_api.create_phone hr_person_address_api.update_person_address  Load Addresses hr_person_address_api.update_person_address hr_person_address_api.create_person_address  Load Payment Methods hr_personal_pay_method_api.create_us_personal_pay_method  Element Loading py_element_entry_api.create_element_entry py_element_entry_api.update_element_entry  Load Salaries hr_upload_proposal_api.upload_salary_proposal  Salary Proposal hr_maintain_proposal_api.approve_salary_proposal  State tax rules pay_state_tax_rule_api.create_state_tax_rule pay_state_tax_rule_api.update_state_tax_rule  County Tax Rules pay_county_tax_rule_api.create_county_tax_rule pay_county_tax_rule_api.update_county_tax_rule  City Tax Rules pay_city_tax_rule_api.create_city_tax_rule pay_city_tax_rule_api.update_city_tax_rule  Schools and Colleges per_esa_upd.upd per_esa_ins.ins  Performance Reviews hr_perf_review_api.create_perf_review hr_perf_review_api.update_perf_review  State Information Taxes hr_sit_api.update_sit hr_sit_api.create_sit  Qualifications per_qualifications_api.create_qualification per_qualifications_api.update_qualification  Locations hr_location_api.update_location hr_location_api.create_location  Organization hr_organization_api.update_organization hr_organization_api.create_org_classification  If any Change in Organization information. if information2 = 'Y' then hr_organization_api.enable_org_classification  If any Change in Organization information. if information2 = 'N' then hr_organization_api.disable_org_classification  If Organization does not exist in instance hr_organization_api.create_organization api  Jobs hr_job_api.update_job hr_job_api.create_job  Positions hr_position_api.update_position hr_position_api.create_position