PeopleSoft Wiki

I am looking for a way to "pre-edit" and possibly cross reference data in the component interface. Here's an example:

I have inbound conversion data using a business unit from legacy. I need to change this field to be the new PeopleSoft business unit. I have a PeopleSoft record where I can access this cross reference, and would like to write the code in the Component Interface. My goal is to not touch delivered components/pages/record peoplecode, but to somehow use the component interface's peoplecode. Is this possible?

Hi,

I need some help in writing the peoplecode in the CI. Below is the issue.

We have a page setup and it has fields from 2 staging tables - A_1 and B_1 (these staging tables are based on three base tables - A, B and C)
When we enter the data into the page the click on the submit button, the CI should fire and it should insert the base tables A, B and C if its new row or should update the existing data for the changes done.

I have created a ci for the component and need some help in writng the peoplecode for insert and update statements.

Thanks for the help.

Thanks,
Rao

i have consume a wsdl using the integration broker comsume webservice nevigation and the web service has been successfully consumed.

the wsdl is below by query, basically now i want to call the method assess of this webservice in peoplecode. i tried alot but unable to find any clue, how to call it in peoplecode.

this webservice gets a parameter and returns an output on the basis of that input parameter.

anyone here, who worked on this plz guide me as soon as possible.

<?xml version="1.0" encoding="utf-8" ?>
- <wsdl:definitions name="determinations_service" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:typ="http://oracle.com/determinations/server/10.2/rulebase/assess/types" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:i18n="http://www.w3.org/2005/09/ws-i18n" targetNamespace="http://oracle.com/determinations/server/10.2/rulebase/assess/types">
- <wsdl:types>
- <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://oracle.com/determinations/server/10.2/rulebase/assess/types" targetNamespace="http://oracle.com/determinations/server/10.2/rulebase/assess/types" elementFormDefault="qualified" version="1.0">
- <!— Assess Request and response
>
<xsd:element name="assess-request" type="AssessRequest" />
<xsd:element name="assess-response" type="AssessResponse" />
- <xsd:complexType name="AssessResponse">
- <xsd:sequence>
<xsd:element name="events" type="ListEventsType" minOccurs="0" />
<xsd:element name="global-instance" type="GlobalInstanceType" />
</xsd:sequence>
</xsd:complexType>
- <xsd:complexType name="AssessRequest">
- <xsd:sequence>
<xsd:element name="config" type="AssessmentConfiguration" minOccurs="0" />
<xsd:element name="global-instance" type="GlobalInstanceType" />
</xsd:sequence>
</xsd:complexType>
- <! XSD types for the list goals action
>
- <! List Goals Request and response
>
<xsd:element name="list-goals-response" type="ListGoalsResponse" />
- <xsd:element name="list-goals-request">
<xsd:complexType />
</xsd:element>
- <xsd:complexType name="ListGoalsResponse">
- <xsd:sequence>
<xsd:element name="entity" type="ListGoalsEntityType" minOccurs="0" maxOccurs="unbounded" />
</xsd:sequence>
</xsd:complexType>
- <! list goals outputs an entity and attributes but has different required attributes
>
- <xsd:complexType name="ListGoalsEntityType">
- <xsd:sequence>
<xsd:element name="attribute" type="ListGoalsAttributeType" minOccurs="0" maxOccurs="unbounded" />
</xsd:sequence>
<xsd:attribute name="entity-id" type="xsd:string" />
</xsd:complexType>
- <xsd:complexType name="ListGoalsAttributeType">
<xsd:attribute name="id" type="xsd:string" use="required" />
<xsd:attribute name="type" type="AttributeTypeEnum" use="required" />
<xsd:attribute name="text" type="xsd:string" use="required" />
</xsd:complexType>
- <! XSD Types for the Assessment Configuration
>
- <xsd:complexType name="AssessmentConfiguration">
- <xsd:sequence>
<xsd:element name="show-silent" type="xsd:boolean" minOccurs="0" />
<xsd:element name="show-invisible" type="xsd:boolean" minOccurs="0" />
<xsd:element name="show-properties" type="xsd:boolean" minOccurs="0" />
<xsd:element name="show-events" type="xsd:boolean" minOccurs="0" />
<xsd:element name="resolve-indecision-relationships" type="xsd:boolean" minOccurs="0" />
</xsd:sequence>
</xsd:complexType>
- <xsd:simpleType name="OutcomeStyleEnum">
- <xsd:restriction base="xsd:string">
<xsd:enumeration value="value-only" />
<xsd:enumeration value="decision-report" />
<xsd:enumeration value="base-attributes" />
</xsd:restriction>
</xsd:simpleType>
- <xsd:simpleType name="AttributeTypeEnum">
- <xsd:restriction base="xsd:string">
<xsd:enumeration value="boolean" />
<xsd:enumeration value="text" />
<xsd:enumeration value="number" />
<xsd:enumeration value="currency" />
<xsd:enumeration value="date" />
<xsd:enumeration value="datetime" />
<xsd:enumeration value="timeofday" />
</xsd:restriction>
</xsd:simpleType>
- <xsd:simpleType name="StateEnum">
- <xsd:restriction base="xsd:string">
<xsd:enumeration value="known" />
<xsd:enumeration value="unknown" />
<xsd:enumeration value="uncertain" />
</xsd:restriction>
</xsd:simpleType>
<xsd:complexType name="UnknownValue" />
<xsd:complexType name="UncertainValue" />
- <! XSD Types for Assess Error Response
>
- <! error response
>
<xsd:element name="error-response" type="Error" />
- <xsd:complexType name="Error">
- <xsd:sequence>
<xsd:element name="code" type="xsd:string" />
<xsd:element name="message" type="xsd:string" />
<xsd:element name="events" type="ListEventsType" minOccurs="0" />
</xsd:sequence>
</xsd:complexType>
- <! rulebase event types
>
- <xsd:complexType name="RulebaseEventType">
- <xsd:sequence>
<xsd:element name="message" type="xsd:string" />
- <xsd:element name="parameters">
- <xsd:complexType>
- <xsd:sequence minOccurs="0" maxOccurs="unbounded">
<xsd:element name="value" type="xsd:string" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="decision-report" type="DecisionReportType" minOccurs="0" />
</xsd:sequence>
<xsd:attribute name="name" type="xsd:string" use="required" />
<xsd:attribute name="entity-id" type="xsd:string" use="required" />
<xsd:attribute name="instance-id" type="xsd:string" use="required" />
</xsd:complexType>
- <xsd:complexType name="ListEventsType">
- <xsd:sequence>
<xsd:element name="event" type="RulebaseEventType" maxOccurs="unbounded" />
</xsd:sequence>
</xsd:complexType>
- <!

NOTE: The interview service uses the same marshalling code as the generic assess service to write out
session data. Therefore any updates to this template need to be made in parallel with interview_session_data_types.vm

>
- <! decision report types
>
- <xsd:complexType name="DecisionReportType">
- <xsd:choice minOccurs="0" maxOccurs="unbounded">
<xsd:element name="relationship-node" type="RelationshipNodeType" minOccurs="0" maxOccurs="unbounded" />
<xsd:element name="attribute-node" type="AttributeNodeType" minOccurs="0" maxOccurs="unbounded" />
<xsd:element name="already-proven-node" type="AlreadyProvenNodeType" minOccurs="0" maxOccurs="unbounded" />
</xsd:choice>
<xsd:attribute name="report-style" type="xsd:string" />
</xsd:complexType>
- <xsd:complexType name="AttributeNodeType">
- <xsd:sequence>
- <! node attribute value
>
- <xsd:choice minOccurs="0">
<xsd:element name="boolean-val" type="xsd:boolean" />
<xsd:element name="date-val" type="xsd:date" />
<xsd:element name="datetime-val" type="xsd:dateTime" />
<xsd:element name="time-val" type="xsd:time" />
<xsd:element name="number-val" type="xsd:decimal" />
<xsd:element name="text-val" type="xsd:string" />
<xsd:element name="uncertain-val" type="UncertainValue" />
<xsd:element name="unknown-val" type="UnknownValue" />
</xsd:choice>
- <xsd:element name="change-point" minOccurs="0" maxOccurs="unbounded">
- <xsd:complexType>
- <xsd:choice minOccurs="0">
<xsd:element name="boolean-val" type="xsd:boolean" />
<xsd:element name="date-val" type="xsd:date" />
<xsd:element name="datetime-val" type="xsd:dateTime" />
<xsd:element name="time-val" type="xsd:time" />
<xsd:element name="number-val" type="xsd:decimal" />
<xsd:element name="text-val" type="xsd:string" />
<xsd:element name="uncertain-val" type="UncertainValue" />
<xsd:element name="unknown-val" type="UnknownValue" />
</xsd:choice>
<xsd:attribute name="date" type="xsd:date" />
</xsd:complexType>
</xsd:element>
- <! node attribute custom properties
>
<xsd:element name="properties" type="ListCustomPropertiesType" minOccurs="0" />
- <! child nodes
>
- <xsd:choice minOccurs="0" maxOccurs="unbounded">
<xsd:element name="relationship-node" type="RelationshipNodeType" minOccurs="0" maxOccurs="unbounded" />
<xsd:element name="attribute-node" type="AttributeNodeType" minOccurs="0" maxOccurs="unbounded" />
<xsd:element name="already-proven-node" type="AlreadyProvenNodeType" minOccurs="0" maxOccurs="unbounded" />
</xsd:choice>
</xsd:sequence>
- <! node id
>
<xsd:attribute name="id" type="xsd:string" use="required" />
- <! node entity instance
>
<xsd:attribute name="entity-id" type="xsd:string" use="required" />
<xsd:attribute name="instance-id" type="xsd:string" use="required" />
- <!
will only show up if outcome is unknown and resolve-rels is true. Used to indicate whether or not the entity instance
actually exists in the session or was created to backwards chain unknown relationships

>
<xsd:attribute name="hypothetical-instance" type="xsd:boolean" use="required" />
- <! node attribute id & type
>
<xsd:attribute name="attribute-id" type="xsd:string" use="required" />
<xsd:attribute name="type" type="AttributeTypeEnum" use="required" />
- <! node attribute current text
>
<xsd:attribute name="text" type="xsd:string" use="required" />
- <! true if the attribute is inferred
>
<xsd:attribute name="inferred" type="xsd:boolean" use="required" />
- <! only provided if start relevance != ChangePointDate.EARLIEST
>
<xsd:attribute name="start-relevance" type="xsd:date" use="optional" />
- <! only provided if end relevance != ChangePointDate.LATEST
>
<xsd:attribute name="end-relevance" type="xsd:date" use="optional" />
</xsd:complexType>
- <xsd:complexType name="RelationshipNodeType">
- <xsd:sequence>
- <!
Relationship decision nodes now include targets. If the relationship is inferred this will be
Relationship.getAllKnownTargets otherwise it's Relationship.getAllTargets

>
<xsd:element name="target" type="RelationshipTargetType" minOccurs="0" maxOccurs="unbounded" />
- <! node relationship properties
>
<xsd:element name="properties" type="ListCustomPropertiesType" minOccurs="0" />
- <! child nodes
>
- <xsd:choice minOccurs="0" maxOccurs="unbounded">
<xsd:element name="relationship-node" type="RelationshipNodeType" minOccurs="0" maxOccurs="unbounded" />
<xsd:element name="attribute-node" type="AttributeNodeType" minOccurs="0" maxOccurs="unbounded" />
<xsd:element name="already-proven-node" type="AlreadyProvenNodeType" minOccurs="0" maxOccurs="unbounded" />
</xsd:choice>
</xsd:sequence>
- <! node id
>
<xsd:attribute name="id" type="xsd:string" use="required" />
- <! node relationship id
>
<xsd:attribute name="relationship-id" type="xsd:string" use="required" />
- <! node relationship source instance
>
<xsd:attribute name="source-entity-id" type="xsd:string" use="required" />
<xsd:attribute name="source-instance-id" type="xsd:string" use="required" />
- <!
will only show up if outcome is unknown and resolve-rels is true. Used to indicate whether or not the source entity instance
actually exists in the session or was created to backwards chain unknown relationships

>
<xsd:attribute name="hypothetical-instance" type="xsd:boolean" use="required" />
- <! node relationship target entity
>
<xsd:attribute name="target-entity-id" type="xsd:string" use="required" />
- <! relationship state - known, unknown or uncertain
>
<xsd:attribute name="state" type="StateEnum" use="required" />
- <! true if the relationship is inferred
>
<xsd:attribute name="inferred" type="xsd:boolean" use="required" />
- <! only provided if start relevance != ChangePointDate.EARLIEST
>
<xsd:attribute name="start-relevance" type="xsd:date" use="optional" />
- <! only provided if end relevance != ChangePointDate.LATEST
>
<xsd:attribute name="end-relevance" type="xsd:date" use="optional" />
</xsd:complexType>
- <xsd:complexType name="AlreadyProvenNodeType">
- <! this attribute's value is the id of the node that has already been proven
>
<xsd:attribute name="id" type="xsd:string" use="required" />
</xsd:complexType>
- <! property types
>
- <xsd:complexType name="ListCustomPropertiesType">
- <xsd:sequence>
<xsd:element name="property" type="CustomPropertyType" maxOccurs="unbounded" />
</xsd:sequence>
</xsd:complexType>
- <xsd:complexType name="CustomPropertyType">
- <xsd:simpleContent>
- <xsd:extension base="xsd:string">
<xsd:attribute name="key" use="required" />
</xsd:extension>
</xsd:simpleContent>
</xsd:complexType>
- <xsd:complexType name="RelationshipType">
- <xsd:sequence>
<xsd:element name="target" type="RelationshipTargetType" minOccurs="0" maxOccurs="unbounded" />
- <! this element will only be provided if the 'show-events' attribute is true in the assessment configuration options
>
<xsd:element name="properties" type="ListCustomPropertiesType" minOccurs="0" />
- <! this element will only appear in a response for attribute outcome attributes whose outcome style is not 'value-only'
>
<xsd:element name="decision-report" type="DecisionReportType" minOccurs="0" />
</xsd:sequence>
<xsd:attribute name="id" type="xsd:string" use="required" />
<xsd:attribute name="state" type="StateEnum" />
- <! this property will only be provided in a response for relationship outcomes
>
<xsd:attribute name="inferred" type="xsd:boolean" use="optional" />
- <! the following properties are used to configure relationship outcomes. The requestor must either specify the 'outcome-style' property or both the 'unknown-outcome-style' and the 'known-outcome-style'
>
<xsd:attribute name="outcome-style" type="OutcomeStyleEnum" use="optional" />
<xsd:attribute name="unknown-outcome-style" type="OutcomeStyleEnum" use="optional" />
<xsd:attribute name="known-outcome-style" type="OutcomeStyleEnum" use="optional" />
</xsd:complexType>
- <xsd:complexType name="RelationshipTargetType">
- <! the value of this attribute must match the id one of the specified entity instances
>
<xsd:attribute name="instance-id" type="xsd:string" use="required" />
</xsd:complexType>
- <! generic session data types
>
- <xsd:complexType name="GlobalInstanceType">
- <xsd:sequence>
<xsd:element name="attribute" type="AttributeType" minOccurs="0" maxOccurs="unbounded" />
<xsd:element name="relationship" type="RelationshipType" minOccurs="0" maxOccurs="unbounded" />
<xsd:element name="entity" type="EntityType" minOccurs="0" maxOccurs="unbounded" />
- <! this element will only be provided if the 'show-events' attribute is true in the assessment configuration options
>
<xsd:element name="properties" type="ListCustomPropertiesType" minOccurs="0" />
</xsd:sequence>
</xsd:complexType>
- <xsd:complexType name="EntityType">
- <xsd:sequence>
<xsd:element name="instance" type="EntityInstanceType" minOccurs="0" maxOccurs="unbounded" />
- <! this element will only be provided if the 'show-events' attribute is true in the assessment configuration options
>
<xsd:element name="properties" type="ListCustomPropertiesType" minOccurs="0" />
</xsd:sequence>
<xsd:attribute name="id" type="xsd:string" use="required" />
</xsd:complexType>
- <xsd:complexType name="EntityInstanceType">
- <xsd:sequence>
<xsd:element name="attribute" type="AttributeType" minOccurs="0" maxOccurs="unbounded" />
<xsd:element name="relationship" type="RelationshipType" minOccurs="0" maxOccurs="unbounded" />
<xsd:element name="entity" type="EntityType" minOccurs="0" maxOccurs="unbounded" />
</xsd:sequence>
<xsd:attribute name="id" type="xsd:string" use="required" />
</xsd:complexType>
- <xsd:complexType name="AttributeType">
- <xsd:sequence>
- <! node attribute value
>
- <xsd:choice minOccurs="0">
<xsd:element name="boolean-val" type="xsd:boolean" />
<xsd:element name="date-val" type="xsd:date" />
<xsd:element name="datetime-val" type="xsd:dateTime" />
<xsd:element name="time-val" type="xsd:time" />
<xsd:element name="number-val" type="xsd:decimal" />
<xsd:element name="text-val" type="xsd:string" />
<xsd:element name="uncertain-val" type="UncertainValue" />
<xsd:element name="unknown-val" type="UnknownValue" />
</xsd:choice>
- <xsd:element name="change-point" minOccurs="0" maxOccurs="unbounded">
- <xsd:complexType>
- <xsd:choice minOccurs="0">
<xsd:element name="boolean-val" type="xsd:boolean" />
<xsd:element name="date-val" type="xsd:date" />
<xsd:element name="datetime-val" type="xsd:dateTime" />
<xsd:element name="time-val" type="xsd:time" />
<xsd:element name="number-val" type="xsd:decimal" />
<xsd:element name="text-val" type="xsd:string" />
<xsd:element name="uncertain-val" type="UncertainValue" />
<xsd:element name="unknown-val" type="UnknownValue" />
</xsd:choice>
<xsd:attribute name="date" type="xsd:date" />
</xsd:complexType>
</xsd:element>
- <! this element will only be provided if the 'show-events' attribute is true in the assessment configuration options
>
<xsd:element name="properties" type="ListCustomPropertiesType" minOccurs="0" />
- <! this element will only appear in a response for attribute outcome attributes whose outcome style is not 'value-only'
>
<xsd:element name="decision-report" type="DecisionReportType" minOccurs="0" />
</xsd:sequence>
<xsd:attribute name="id" type="xsd:string" use="required" />
- <! this property is returned for each attribute in a response
>
<xsd:attribute name="type" type="AttributeTypeEnum" use="optional" />
- <! this property will only be provided in a response for relationship outcomes
>
<xsd:attribute name="inferred" type="xsd:boolean" use="optional" />
- <! the following properties are used to configure relationship outcomes. The requestor must either specify the 'outcome-style' property or both the 'unknown-outcome-style' and the 'known-outcome-style'
—>
<xsd:attribute name="outcome-style" type="OutcomeStyleEnum" use="optional" />
<xsd:attribute name="unknown-outcome-style" type="OutcomeStyleEnum" use="optional" />
<xsd:attribute name="known-outcome-style" type="OutcomeStyleEnum" use="optional" />
</xsd:complexType>
</xsd:schema>
</wsdl:types>
- <wsdl:message name="ListGoalsResponse">
<wsdl:part element="typ:list-goals-response" name="ListGoalsResponse" />
</wsdl:message>
- <wsdl:message name="ListGoalsRequest">
<wsdl:part element="typ:list-goals-request" name="ListGoalsRequest" />
</wsdl:message>
- <wsdl:message name="AssessResponse">
<wsdl:part element="typ:assess-response" name="AssessResponse" />
</wsdl:message>
- <wsdl:message name="AssessRequest">
<wsdl:part element="typ:assess-request" name="AssessRequest" />
</wsdl:message>
- <wsdl:portType name="odsAssessServiceGeneric_SimpleBenefits_type">
- <wsdl:operation name="ListGoals">
<wsdl:input message="typ:ListGoalsRequest" />
<wsdl:output message="typ:ListGoalsResponse" />
</wsdl:operation>
- <wsdl:operation name="Assess">
<wsdl:input message="typ:AssessRequest" />
<wsdl:output message="typ:AssessResponse" />
</wsdl:operation>
</wsdl:portType>
- <wsdl:binding name="odsAssessServiceGeneric_SimpleBenefits" type="typ:odsAssessServiceGeneric_SimpleBenefits_type">
<soap:binding style="document" transport="http://schemas.xmlsoap.org/soap/http" />
- <wsdl:operation name="ListGoals">
<soap:operation soapAction="http://oracle.com/determinations/server/10.2/rulebase/types/ListGoals" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
- <wsdl:operation name="Assess">
<soap:operation soapAction="http://oracle.com/determinations/server/10.2/rulebase/types/Assess" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdl:output>
<soap:body use="literal" />
</wsdl:output>
</wsdl:operation>
</wsdl:binding>
- <wsdl:service name="odsAssessServiceGeneric_SimpleBenefits">
- <wsdl:port binding="typ:odsAssessServiceGeneric_SimpleBenefits" name="odsAssessServiceGeneric_SimpleBenefits_SOAP">
<soap:address location="http://localhost:8080/determinations-server/assess/soap/generic/SimpleBenefits" />
</wsdl:port>
</wsdl:service>
</wsdl:definitions>