BI Publisher (MOSC)

MOSC Banner

How to SUM a sequence on eText template

edited Sep 3, 2012 10:48PM in BI Publisher (MOSC) 2 commentsAnswered

Good day,I'm using an eText XML Template and I'm trying to calculate the Hash Total of to send produce a flat file for international payments. Part of the formula for the Hash Total involves doing a sum of the sequence number, multiplied by the sum of the branch numbers. Does anybody know what the syntax is it do a sum of the sequence number? I thought it would be as simple as
{code}SUM(SEQUENCE_NUMBER(DealSeqNumSC)){code} but my eText template doesn't like this.

This is how the sequence is defined on the template:
{code}
KI3HkpUQNpBbbkr0phDnV09elZvzide5SuYYRG2qY5BwlZ2fwkLPRLFr9Q6WbMPMpftJHGEOoGoKXLVWv8rMg7dcvF5uahiGFVf5ji45KdXtUbSDUXbAsrTxyEu7O6arjLx/eg2OMQ5jQoaIvu1uRnlEUoMx5HFX+5+Od51oH67xR2+Wq0iOJZoXY5nlQ/s2PuOGVVtEq2liztP+fQDYjSxXrdavyig6lVVuijQ1XDWPFOui1FXR0CLL7VotK9T7+GycnWPJyqeu54qVZwJsGfDWLbfvqWjH3A9tovb/IIEeaUPyDT7EiqMRV91uJN8gs5VIXDj3qdcWsWqaGPM0fx8AdqPEVVq9wBkt5XrMWrkpMpzuKh6/sUbPxlVBVgU5182vCFe9n11cxXqa7vVRYd/lzwlXqbUfRe9GikLrME9dSCpniU8yB65V08Sap/37ALAbWa7yWGuA3Bqr+w7Sj4KWFlnFdmmr5101Te1yafiOEKwBHhPLVYnaH6dylZr3XVsYZN3OQdWYdJVRaBiuAoelwFUTyt4KXyw3Ub8qv9zU0tjaACjWEEOzF7gqbClMqxe1qQ6B6Sp7b4Veg2O6hFXlDf3QW384Ti7ltRPV/g0HRAWI066ijrl10XMjURsrVVvEMo/tKv33AWA3yl01Ee+tCCt72upgfrkpyzpCVVJWCVdFkVh6aNqNWcvKiO7AfiRcNVp71uMaHHF1DlrsitToYG5gy2jq8dD/ckx8Hseohsh0wqpRQk/4PRAytJI7JZxVW0SpaZKap/b7ALAnDu8Cg5Oiu+o4NUF2//zXH7//548/P2EOALwfuAqcFd1Vx6gJsvPn///XfXPuh3M/3G//+3OvcZFRF+wIXAXOirkGeIT6HTV8BmBH4CpwVlLPq45Qv6OGzwDshXQVAAAAcEBGxFXgjDjkWQegGuAqcFbgKgDqYaurwrtN9EVg7ZWnCZ47kJAqJjIfk0kF51eJo47UyawXDaGwV3pl/ZHoGit1h9IXeDFwFQD1UO4qn7dCuEq5abNXd0XeitxiIix/oEgrkUpKq6YMzElsId431uuPxPVN6EjRWZQLeROWq2S6u+jt2PjUyN8dpumL4ldgrf5RdgqA91HgKsMDSxSxxDXpXOQlxUR8mNQ0If150zQZrpKTGYahwFU8QIrrj8T1TegRpfoJUgW+hURcRXMFkTToZokomjedZkeycjVZ/bMkfSQvOwDgSbJcpdQEEVK6XEgZ3SWoMPPP5hYTYbK4XxvXXK80naBsb0yGfIvMJExscpEVo3CLjWQVg4SxXkymq6g/puMi+WyUi3a50MqBa/UvEsoi4SsAr6LEVdFTHhpALSFQjqsIyWIi0ygfF/7fdFwVT4Z8i7XktkKeRv0R+j3kGmB8VhyDq15EnqtIjSiWro84RGQsJ51YtUWs/kVXlgQBAKVkucqTWANsrneygyF3DXC9mAiNbBz5uOYqOZlhGDJdxSsCGwHXwtxalVncFyz1UtKuWv7elAhKOGSTq9T+4SoA3kSBqya0vRX+JszDr5y9FWvFRMROPvYQaqVaRxwLFsVVifojSn0TfUvJdBTlQt5EVlzFHxrp8nhmDVA8lMIaIADvodxVHn0ThY8f1ves5xYT4Y+/QjN1z7paVav8eVWoYm/WH4nqm6TPgveQ5SpeY55bKahELuSV7K2g/TNX2SUNAQClbHUVAJ+N5aroodStc6GME4eXOtSW9VJ71nn/0Z51dWURALAFuAqclURcBQD4YsBV4KzAVQDUA1wFzgpcBUA9wFXgrMBVANSDdBUAAABwQEbEVeCMOMRVAFQDXAXOClwFQD3AVeCswFUA1MNmV+WXOowbryaPUMoWylECPJ1F7hzkLKICiVZ7VrlRZPPNyR+f/KGGRLKPlZ+wPhxcBUA1uI35AMtKHUb3cS3xn9ZgJemfGDlZ+9FMpjsMWvlEvT3PvcQkk3JV9g+VVaAyTKVuY8FVANRDgat4svDULTgqdWjW3aAXag22u2plDtp3S03JaGZpNdNVGwtUil5qzYwLVwFQD1muUmotRqtSyVKHVt0N1ltOYQ5uI7IaJu73xhzsVbS4QKLSPs5+S47krgFuLlBpTb5aY8FVANRDiausiCI66J/GkFKHT7lqQ1y1PgeV2QjW0JtdlflDZRZT1mcNVwEAvi5ZrvJkrgFqpQ4VFaUW3EKD7a5amYPJ4sn0KL4olR8j/Uyu5IfCGmAJcBUA9VDgqom1vRVaqcO991aszkGglE9c21sRVR6m0SK1cdEPVba3olZJTcBVANRDuasmol3UqVKHovETe9bXI57MOYgu4gKJVnu2Z51/GXpJ/legkxT923vWK9fUMAxwFQA14fAu8HN8XCrfOf55wFUA1ANcBc4KXAVAPcBV4KzAVQDUA1wFzgpcBUA9SFcBAAAAByS4CgAAADgscBUAAICj8w/cRJ52ah2usgAAAABJRU5ErkJggg==" loading="lazy" srcset="https://community.oracle.com/cdn-cgi/image/quality=80,format=auto,fit=scale-down,height=300,width=300/moscdenied:data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAjkAAABECAIAAADsqrMMAAALPklEQVR4nO2dMbLjNhKGcQNPvIfYiOWA0UR7CgUb8R6KnDLbC7wzKNlgIoWuOYDKkauYzhHoACTR3egGAUriIx/+L3BpSBCANGV+0yDY7cYZ55xzbgQAAAAORpATXAUAAOCYTHJyAAAAwCFhrhoAOAkOCwAAVANcBc4KXAVAPWx21ceFBWeXD/24PyMONtf7dOzyMV/SXO/het+b2pU2g+laq/392qh9fFzCsKvjWpMU/fP+7MmD54GrAKiHcld9XFxzvcc3eiKM5Ti5JjooXDU3EM6Iupq5Xxvf7n5tiP2i9uE0H1T2vzauNUnWP/mD0sn92sBYL8Ry1aNv+T8Tuhs5G06Gw7fOviC0b9uW9ZSL773tH2ykTV0BUC0FrmJ3a3Ev5uLZ5ioSv2S4ioc2GaPEjba4Sk7SnKN+gv+G4CkScdWjD1p59O0ihr4Nkrh1QlfLH8LnWzc5JmpfRt8SO9HJAQDyyHLVtMjF7rD8XsyDm2jpix8kK23hfn+5+B4Sa3HcTPPKmxAmb79EX/wyxUlr4+qTjPunv481eRjrJeS7avIN9dE4juO4nBHnbl24YmkhB1j+almfS+DU9rdgqL5t+37udJ7cgxjMd9f2j+lo27bOOdf184n8/6UB+JKUuMqKT4bVhbj1uGoWQNM0eXEV6cTZQ292lfUVxCTTrrImD1e9hLSrwj8T5hv9g6hpOUKiLCWuGvU1Qyo5Fm+FEO7BQinffrrKGDVM79G3i7bafiTuBKBaslzlSa0Bhnv2dleRPQrZrlrGjh6hRaPcr01zvfsxDFflPHITk8Qa4OeRH1d5aay5KqAu0QUnRQ/EJh0++pYGQERE08j+SI6r5sBrfsoFV4HaKXDVxHv2VvizPIBLuUrsYlieIiX2VkgVsm0RNEBa+Qp8kmV7KyCpF5LpqnG512evAZqdqk6KG0RdsmXIHq4CoJhyV01k71lfj3joWX+5sXecdUF3iqfbsz3rjq3Z0UvyvwKd5JC7Zx2aejXZrgpGyNtbQS8kkiDGsMxGh6VjBSk++pbsJwwD3Do37xWEqwCI2eyq8/Jxwc7xL4HlqniJTt+Dru9Zp1a4ddMeh7gbvs19CafI4bbrvHLIdovHyPclkrlO2yjm3RTOdbdpm0X/oCIDoE4qdBX4Iuiu+vVr/PXrEJ99ePSO/gGoD7gKnBXdVT9/jt+/T3f2798/6/Pfv7lvzn1z7se//v2y/n/+3PPWAMChgKvAWTGfV3ld+Zv7V/oMQMXAVeCsJPZWTHf5r/cZgFqRrgIAAAAOyIi4CpwRhzzrAFQDXAXOClwFQD1sdpWVm9Ws25RRbuoqXtp1aq49/+qtyO9kXpVOms6HJu3mDBRmLSu82vvppF2l5vErgmX0ezcsf2CqRgkAdVLu

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center