Posted by Jayachandran A On : 12.1.1 version, Jserv, JDK, JVM, JRE Introduction: When attempting to login EBS, the following error occurs. ERROR ———– Unable to generate forwarding URL. Exception: oracle.apps.fnd.common.AppsException:…
Read MorePosted 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 MorePosted 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 MorePosted 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 MoreSteps 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 The following five components of P2P Cycle Query are 1. Requisition Detail 2. Purchase Order Details 3. Receiving Details 4. …
Read MoreGrade : 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 MoreMETADATA|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 More/* 1. GL Account analysis for PA Expenditure */ SELECT ‘Expenditure’ revenue_type,…
Read MoreSELECT 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 More