Oracle Fusion HCM Data Loader (HDL) Keys Significance
HCM Data Loader (HDL) Keys Supported Key Types: HCM Data Loader (HDL) supports 4 different types of keys as listed below GUID – Oracle Fusion Global Unique ID Oracle Fusion…
Read MoreOracle Apps(EBS) – AR Receipt Register Query with Bank statement Header and Line Details
Below query is useful when you required Non Misc Receipts Along with Bank Statement Header , Line Details and Activity name ( like Receipt Write off) SELECT ACRA.RECEIPT_DATE ,( select…
Read MoreQuery to get the Project Expenditures Defined for an Employee for a Specific Period
SELECT EXPT.EXPENDITURE_TYPE , EXPI.Quantity , CASE WHEN (EXPT.unit_of_measure=’HOURS’) THEN NVL(CDL.PROJECT_BURDENED_COST,cdl.project_raw_cost) END Raw_cost , –EXPI.DENOM_RAW_COST EXPI.ACCRUED_REVENUE , EXPI.expenditure_item_id , …
Read MoreJDeveloper Installation and Setting Environment
Prerequisites Desktop with 1.5 GB RAM 1.Telnet and FTP access to apps and db server 2.Database connectivity details: 3.Apps username and password, 4.SID, 5.Host Name and port. 6.Exact version of OA Framework…
Read MoreORA-01792 maximum number of columns in a table or view is 1000 FROM mtl_parameters
Symptoms:- Concurrent program completed warning with “ORA-01792 maximum number of columns in a table or view is 1000 FROM mtl_parameters” this reason. Solution:- SQL> alter session set “_fix_control”=’17376322:OFF’; or at system…
Read MoreEnabling Create/View Accounting from Toolbar on Receipt Summary Form for a Custom Responsibility
How to Enable Create/View Accounting from Toolbar on Receipt Summary Form for a Custom Responsibility Goal:- What are the steps to enable Create/View Accounting for a user-defined responsibility? Solution:- Please…
Read MoreWorkflow download and upload commands in Oracle apps
Workflow upload WFLOAD <apps/pwd>@<connect_string> 0 Y {UPLOAD | UPGRADE | FORCE} <filepath>[<file_name.wft>] Example: WFLOAD apps/pwd@<connect_string> 0 Y UPLOAD $XXDOY_TOP/install/XXDOYAP.wft Different “Upload Modes” applicable to WFLOAD: UPGRADE Honors both protection and…
Read MoreConvert the Amount in to the Word using Function in Oracle Apps EBS R12
Convert the Amount in to the Word using Function in Oracle Apps EBS R12. Function: CREATE OR REPLACE FUNCTION APPS.Get_amount_to_word(P_LC_AMOUNT IN NUMBER,P_CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2 IS x_tot_amount1 NUMBER …
Read MoreFind the query of Receivable (AR) for the Invoice Number (TRX_NUMBER) Wise, Customer wise, Sales Order Wise, Transaction Date and GL Date Wise in Oracle Apps EBS R12
Find the query of Receivable (AR) for the Invoice Number (TRX_NUMBER) Wise, Customer wise, Sales Order Wise, Transaction Date and GL Date Wise in Oracle Apps EBS R12. SELECT rct.trx_number…
Read MoreCSS Plan Creation – Inventory Receiving Options Migration
CSS Plan Creation Process for Migration Configuration: Inventory – Receiving Options Steps 1. Connect with Server wherein the CSS (ConfigSnapshot) is installed 2. Log-in on to ConfigSnapshot 3. Connect with…
Read More