For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
Hello,
I have an entity Bank Accounts with type which can either be Payroll or Non-Payroll. What I want to do is assign a Sequence number attribute to each instance. For example, if the user added a Payroll account, the Sequence for this instance will have a value of 1. If he adds a Non-Payroll account, the Sequence for the new instance will have a value of 1 also since it is the first non-payroll account. The resulting table should look something like this, assuming it only has 3 attributes (acct no, type, sequence):
Acct. No. - Type - Sequence
87655353 - Payroll - 1
0987669 - Non-Payroll - 1
354548784 - Payroll - 2
973734733 - Payroll - 3
9776553 - Non-Payroll - 2
How can I do this? Is there a function I can use or should I define a relationship of the entity to itself?
Thanks
Comment
This provides a good overview of the general pattern: https://community.oracle.com/blogs/opa_architecture/2017/08/10/intermediate-oracle-policy-automation-opa-ordering-pattern
Note that sequencing by type and then by some other unique attribute (e.g. account no) will be necessary, but the same basic patterns can be utilized.
Be the first to rate this
|
Sign in to rate this