TAX INVOICE RCM(REVERSE CHARGE MECHANISM) – GST
The below query fetches the details of a tax invocie where in Reverse charge mechanism(RCM) is applied in order to claim the extra tax paid by an organization along with…
Read MoreDelivery Challan with GST Details
Query retrieves data of those inventory items which are used for promotional purposes or given as a sample items for a sales executive in order to promote the products along…
Read MoreOracle 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 More