EBS R12.2 Cloning Steps
Posted by Venkatesh R K Introduction: In this document we are going to discuss the steps for EBS Cloning. NOTE: The following Clone approach is applicable for the APPLICATION version from…
Read MoreHow to deploy Oracle EBS Cloud Manager from Market Place?
Posted by Narasimha Rao.K Introduction: The Main agenda for this post is to demonstrate basic steps to deploy Oracle EBS Cloud Manager from Market Place. Pre-requirement: Have Oracle Cloud account login, and…
Read MoreError: Your Oracle E-Business Suite account has not been linked with the Single Sign-On account that you just entered.
Posted by Asif Hussain Here we will find the solution for below error. Error: Your Oracle E-Business Suite account has not been linked with the Single Sign-On account that you just…
Read MorePeriod End Processing Oracle Inventory and Oracle Cost Management
Steps Oracle Inventory and Oracle Cost Management provides the required features to effect the necessary period-end procedures to: § Reconcile the inventory and work in process costs and values. §…
Read MoreSQL Query to find details from PO till Cheque payment
SQL Query to find details from PO till Cheque payment The following five components of P2P Cycle Query are 1. Requisition Detail 2. Purchase Order Details 3. Receiving Details 4. …
Read MoreFusion HCM – Templates for Loading Work Structures using HDL
Grade : METADATA|Grade|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|SetCode|GradeCode|GradeName|ActiveStatusMERGE|Grade|SourceSystemOwnerName|SourceSystemIdName|1951/01/01|4712/12/31|COMMON|GradeCodeName|GradeName|A Location : METADATA|Location|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|LocationCode|LocationName|Description|SetCode|Country|ActiveStatus|ShipToSiteFlag|ReceivingSiteFlag|BillToSiteFlag|OfficeSiteFlag|Building|PostalCode|TownOrCity|Region1|Region2|AddressLine1MERGE|Location|SourceSystemOwnerName|SourceSystemIdName|1951/01/01|4712/12/31|LocationCode|LocationName|Description|COMMON|US|A|Y|Y|Y|Y|Building|PostalCode|New York|New York|NY|AddressLine1 Job : METADATA|Job|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|SetCode|JobCode|Name|ActiveStatus|MedicalCheckupRequired|BenchmarkJobFlagMERGE|Job|SourceSystemOwnerName|SourceSystemIdName|1950/01/01|4712/12/31|COMMON|ORA_CON|Oracle Consultant|A|N|N Position : METADATA|Position|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|BusinessUnitName|PositionCode|Name|ActiveStatus|DepartmentName|JobSetCode|JobCode|LocationCode|FullPartTime|RegularTemporary|HiringStatus|FTE|HeadCount|PositionTypeMERGE|Position|SourceSystemOwnerName|SourceSystemIdName|1951/01/01|4712/12/31|BusinessUnitName|PositionCode|Cloud Applications Marketing|A|Cloud Applications – US|COMMON|JobCode|LocationCode|FULL_TIME|R|APPROVED|10|10|SHARED Organization : METADATA|Organization|SourceSystemOwner|SourceSystemId|Name|ClassificationCode|EffectiveStartDate|EffectiveEndDate|LocationId(SourceSystemId)|LocationSetCodeMERGE|Organization|SourceSystemOwnerName|SourceSystemIdName1|Cloud Applications – Consultant|DEPARTMENT|1951/01/01|4712/12/31|LocationSourceSystemIdName|COMMONMETADATA|OrgUnitClassification|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|OrganizationId(SourceSystemId)|ClassificationCode|SetCode|StatusMERGE|OrgUnitClassification|SourceSystemOwnerName|SourceSystemIdName2|1951/01/01|4712/12/31|SourceSystemIdName1|DEPARTMENT|COMMON|A
Read MoreFusion HCM – Template for Loading Workers using HDL
METADATA|Worker|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonNumber|StartDate|DateOfBirth|ActionCode|BloodType|CountryOfBirth MERGE|Worker|SourceSystemOwnerName|PER-XXXX|2017/01/01|4712/12/31|XXXX|2017/01/01|1984/08/08|HIRE|A+|US METADATA|PersonName|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|PersonNumber|LegislationCode|NameType|LastName|FirstName|Title|EffectiveStartDate|EffectiveEndDate MERGE|PersonName|SourceSystemOwnerName|PN-XXXX|PER-XXXX|XXXX|US|GLOBAL|Chan|Jackie|Mr.|2017/01/01|4712/12/31 METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|PersonNumber|DateStart|LegalEmployerName|WorkerType|PrimaryFlag|ActionCode MERGE|WorkRelationship|SourceSystemOwnerName|WR-XXXX|PER-XXXX|XXXX|2017/01/01|LegalEmployerName|E|Y|HIRE METADATA|WorkTerms|SourceSystemOwner|SourceSystemId|AssignmentNumber|PeriodOfServiceId(SourceSystemId)|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|ActionCode|PersonId(SourceSystemId)|PersonNumber|LegalEmployerName|DateStart|WorkerType|BusinessUnitShortCode MERGE|WorkTerms|SourceSystemOwnerName|WT-XXXX|ETXXXX|WR-XXXX|2017/01/01|4712/12/31|1|Y|HIRE|PER-XXXX|XXXX|LegalEmployerName|2017/01/01|E|BusinessUnitShortCode METADATA|Assignment|SourceSystemOwner|SourceSystemId|AssignmentNumber|WorkTermsAssignmentId(SourceSystemId)|PersonId(SourceSystemId)|PersonNumber|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|DateStart|ActionCode|PersonTypeCode|LegalEmployerName|BusinessUnitShortCode|JobCode|DepartmentName|LocationCode|PrimaryAssignmentFlag|PrimaryFlag|ManagerFlag MERGE|Assignment|SourceSystemOwnerName|ASG-XXXX|EXXXX|WT-XXXX|PER-XXXX|XXXX|2017/01/01|4712/12/31|1|Y|2017/01/01|HIRE|Employee|LegalEmployerName|BusinessUnitShortCode|JobCode|DepartmentName|LocationCode|Y|Y|N METADATA|PersonLegislativeData|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|LegislationCode|MaritalStatus|Sex MERGE|PersonLegislativeData|SourceSystemOwnerName|PL-XXXX|2017/01/01|4712/12/31|PER-XXXX|US|M|M
Read MoreGL Account analysis for PA Expenditure & Event query
/* 1. GL Account analysis for PA Expenditure */ SELECT ‘Expenditure’ revenue_type,…
Read MoreQuery To Find Contracts With Revenue on Hold in Oracle Fusion
SELECT PPA.segment1 project_number ,OCTV.name contracty_type ,PPA.name project_name ,HOU.name organization_name ,PPA.project_currency_code ,TO_CHAR (PPA.completion_date, ‘DD-MON-YYYY’, ‘NLS_DATE_LANGUAGE = american’) completion_date ,ROUND((NVL((INV.cont_curr_billed_amt), 0)), 2) project_to_date_Invoiced_sum ,ROUND((NVL((INV_UNRECOG.cont_curr_billed_amt), 0)), 2) Draft_invoice_amount ,ROUND(NVL((SELECT SUM(PNAR_AMOUNT) …
Read MoreFunction To Get Bill Rate Of Employee in Specific Project in Oracle Fusion
FUNCTION get_bill_rate ( p_project_id IN NUMBER, p_person_id IN NUMBER )RETURN NUMBERAS ln_bill_rate NUMBER;BEGIN SELECT DISTINCT bro.rate INTO ln_bill_rate FROM pjb_bill_plans_b bpb, pjb_bill_rate_ovrrds bro, per_all_people_f_v ppn, (SELECT DISTINCT…
Read More