Credit Memo Workflow11
Credit Memo Workflow11
Credit Memo Workflow11
Document964902.1
iReceivableCreditMemoWorkflowSetup,UsageandDebugging(DocID964902.1)
InthisDocument
Goal
Solution
Prerequisites
iReceivablesCreditMemoWorkflowWithoutApprovalManagementEngine(AME)
iReceivablesCreditMemoWorkflowWithAME
DebuggingTips
References
APPLIESTO:
OracleiReceivablesVersion12.0.0andlater
Informationinthisdocumentappliestoanyplatform.
ARCMREQ,ARAMECM
***CheckedforRelevance05NOV2012***
GOAL
UnderstandtheworkflowintheCreditMemoWorkflowprocesswithandwithouttheuseoftheApprovalManagement
Engine(AME)intheapprovalfortheCreditMemosanduseprocess.Wewillalsohaveaquicklookatthesetup
requiredtouseiReceivables.
Prerequisites
iReceivablesCreditMemoWorkflowWithoutApprovalManagementEngine(AME)
Setup
UnderstandingtheWorkflow
Demonstration
iReceivablesCreditMemoWorkflowWithAME
Setup
UnderstandingtheWorkflow
Demonstration
DebuggingTips
SOLUTION
Prerequisites
1. SetupEmployeesinHRMSandAssignJobandPositions.
DefineJobsandPositionHierarchy
DefineEmployee:
ToEnteranEmployee
HRResponsibility:People:EnterandMaintain
AttachPositionandJobtoEmployees
ToAssignajobtotheemployee:
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
1/29
11/24/2014
Document964902.1
HRResponsibility:People:EnterandMaintain>ClickontheAssignmentbutton.
SetupOracleReceivablesRelease12
DefineTransactionTypes
Navigation:Setup>Transactions>TransactionTypes
ThisistheCreditMemoTransactionTypewewillattachtotheinvoicetransactiontypetocreateCreditMemoson
approval.
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
2/29
11/24/2014
Document964902.1
DefineCollectors
Navigation:Setup>Collections>Collectors
GivetheCollectornameandselecttheemployeename.
DefineCustomerProfileClass
Navigation:Customer>ProfileClasses
Defineacustomerprofileclasswiththecollectordefinedabove.
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
3/29
11/24/2014
Document964902.1
Attachthecustomerprofileclasscreatedtoyourcustomer.
Navigation:Customer>CustomerAccount>AccountProfile
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
4/29
11/24/2014
Document964902.1
UpdateLookups
Navigation:Setup>System>QuickCodes>Receivables
Thesearethedisputereasonsthatcanbeselectedwhenthedisputeisraisedontheinvoice.Thisisanextensible
lookup,soyoucanaddnewvaluesandenddatetheexistingvalues.
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
5/29
11/24/2014
Document964902.1
SetupOracleBillPresentmentArchitecture(BPA)Release12.Referto'OracleBillPresentmentArchitectureUser
Guide'
SetupOracleWorkflowRelease12,ifyouintendtousetheDisputeInvoicefunction,SelfRegistration,orboth.Refer
to'OracleWorkflowAdministrator'sGuide'
SetthefollowingprofileoptionsforalliReceivablesResponsibilities:
MO:Securityprofile
MO:OperatingUnit
iReceivablesCreditMemoWorkflowWithoutApprovalManagementEngine(AME)
1.Setup
DefineCreditMemoApprovalLimitsforApprovers
Navigation:Setup>Transactions>ApprovalLimits
YouneedtohaveauniquecombinationoftheDocumentType,Reason,CurrencyandPrimary.Youneedtohave
atleastonePrimaryApprover.
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
6/29
11/24/2014
Document964902.1
DefineaCreditMemoTransactionBatchSource
Thetransactionbatchsourcenameshouldmatchthevaluegivenfortheattribute'BatchSourceName'inthe
workflow.Inthiscaseits'iRCreditMemoWorkflow.'
Navigation:Setup>Transactions>Sources
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
7/29
11/24/2014
Document964902.1
TheAttribute'BatchSourceName'asseenintheworkflowbuilder.
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
8/29
11/24/2014
Document964902.1
UpdateTransactionTypeontheInvoice
Navigation:Setup>Transactions>TransactionTypes
ThisistheinvoiceTransactionType.WeneedtoattachaCreditMemoTransactiontypetothis.
DefineiReceivablesInternalUserResponsibility
Thisistheuserweassigntothecollectortobeabletoviewthecustomeraccountinformation.
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
9/29
11/24/2014
Document964902.1
DefineiReceivablesExternalUserResponsibility
Thisistheresponsibilitywegivetothecustomerscontacttoviewtheiraccountinformationbyattachittheusergiven
tothem.
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
10/29
11/24/2014
Document964902.1
CustomerTextDataCreationandIndexing
WeneedthistoberunafteraddingnewcustomerssothatthedataisindexedandavailableforuseiniReceivables.If
youwishtosearchthecustomerinformationbythecustomercontactthenrunthisrequestwiththecompactindex
parameteras'No.'
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
11/29
11/24/2014
Document964902.1
SetupCreditMemoRequestWorkflow
Loadtheworkflowthatyouwouldliketousebyconnectingtothedatabaseandselectingtheappropriateworkflow
(ARCMREQ/ARAMECM).Youcanmodifytheworkflownotificationsmessages,timeoutdurationetc.
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
12/29
11/24/2014
Document964902.1
2.UnderstandingtheWorkflow
ThisistheoverviewoftheARCMREQ(CreditMemoApprovalwithoutAME).Fordetailedactionateachnode,please
refertheReceivablesUserguide.
3.Demonstration
Thedemonstrationwouldshowthedisputecyclestartingfromqueryingtheaccountinformationbythecustomers
collector,goingthroughtheapprovalchainbeforethecreditmemoiscreatedandapplied.Inthisdemowewilluse
theworkflowwithoutAME(ApprovalManagementEngine).
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
13/29
11/24/2014
Document964902.1
Clickonthislinktodownloadtheviewlet.
external_user_dispute_demo_woame
iReceivablesCreditMemoWorkflowWithAME
TheAMEworkflowconsistsofthreephases,knownastransactiontypes.ToimplementtheAMEworkflow,thesethree
transactiontypesmustbesetup:
ReceivablesCreditMemoCollector
ReceivablesCreditMemoApprovalChain
ReceivablesCreditMemoReceivables
ACreditMemorequestusingAMEcanfollowoneoftwoapprovalpaths:
LimitsOnlyusesspecificapprovallimitrulestofindthenextaprover.
HRHierarchyLimitsusesanorganization'sinternalmanagementhierarchytofindthenextaprover.
1.Setup
Navigation:ApprovalsManagementBusinessAnalyst>BusinessAnalystDashboard
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
14/29
11/24/2014
Document964902.1
ReceivablesCreditMemoCollector
Attributes
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
15/29
11/24/2014
Document964902.1
Conditions
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
16/29
11/24/2014
Document964902.1
Rules
ApprovalGroups
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
17/29
11/24/2014
Document964902.1
ReceivablesCreditMemoApprovalChain
Attributes
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
18/29
11/24/2014
Document964902.1
Conditions
Rules
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
19/29
11/24/2014
Document964902.1
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
20/29
11/24/2014
Document964902.1
ApprovalGroups
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
21/29
11/24/2014
Document964902.1
ReceivablesCreditMemoReceivables
Attributes
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
22/29
11/24/2014
Document964902.1
Conditions
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
23/29
11/24/2014
Document964902.1
Rules
ApprovalGroups
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
24/29
11/24/2014
Document964902.1
2.UnderstandingtheWorkflow
ThisistheoverviewoftheARAMECM(CreditMemoApprovalwithAME).Fordetailedactionateachnode,pleaserefer
theReceivablesUserguide.
3.Demonstration
Thedemonstrationwouldshowthedisputecyclestartingfromraisingadisputeonaninvoicebythecustomers
collector,goingthroughtheapprovalchainbeforethecreditmemoiscreatedandapplied.Inthisdemowewilluse
theworkflowwithAME(ApprovalManagementEngine).
Clickonthislinktodownloadtheviewlet.
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
25/29
11/24/2014
Document964902.1
external_user_dispute_demoame
DebuggingTips
WorkflowStatusCheck
FromtheApplication
SystemAdministrator>Workflow>OracleApplicationsManager>WorkflowManager*
Under'RelatedLinks'clickon'WorkItems'
Select'ActiveWorkItems'andclickonGo
Clickonthelink'ARCreditMemoApprovalRequest'
Clickontherelevant'WorkItemActivityStage'
SelecttherelevantActivityNameandclickon'LaunchWorkflowMonitor'
*AlternativelyloginasSYSADMINusetheresponsibilityWorkflowAdministratorWebApplications>
AdministratorWorkflow>StatusMonitor.
WorkflowStatusCheckStatusDiagram
WorkflowStatusCheckActivitiesHistory
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
26/29
11/24/2014
Document964902.1
UsingaScript
Thewfstat.sqlscriptisavailableat$FND_TOP/sql
IfnotusingAME,thesyntaxis:
sql>@wfstat.sqlARCMREQ<Request_id>
IfusingAME,thesyntaxis:
sql>@wfstat.sqlARAMECM<Request_id>
Theoutputforthewfstat.sqlwouldlooklikebelow.
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
27/29
11/24/2014
Document964902.1
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
28/29
11/24/2014
Document964902.1
MoreInformation:
Note108185.1OracleApplicationsObjectLibrarySQLscripts
Note261028.1HowToDownloadandInstallTheLatestOracleWorkflowBuilder(ClientTool)ForEBusiness11i
WorkflowClient:http://www.oracle.com/technology/software/products/workflow/index.html
Note338508.1ErrorOracleApprovalsManagementhasfoundparallelizationconfiguration
REFERENCES
NOTE:1306939.1OracleCreditMemoWorkflow:KnownIssuesandPatches
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=1573km79ti_4&id=964902.1
29/29