Hello
I'm trying to integrate with Egypt EInvoicing , EReceipt , I should generate receipt UUID and to do that I should follow instructions in this link https://sdk.invoicing.eta.gov.eg/receiptissuancefaq/#how-to-generate-receipt-uuid
I did steps 1,2,3,4 But for Step 5 I should Create a hash value of the normalized text using SHA256 so i used this sql
SELECT STANDARD_HASH(
('"HEADER""DATETIMEISSUED""2023-05-25T00:34:00Z""RECEIPTNUMBER""001""UUID""""PREVIOUSUUID""""REFERENCEOLDUUID""""CURRENCY""EGP""EXCHANGERATE""0""SORDERNAMECODE""sOrderNameCode""ORDERDELIVERYMODE""""GROSSWEIGHT""6.58""NETWEIGHT""6.89""DOCUMENTTYPE""RECEIPTTYPE""S""TYPEVERSION""1.2""SELLER""RIN""100334776""COMPANYTRADENAME""Minapharm""BRANCHCODE""0""BRANCHADDRESS""COUNTRY""EG""GOVERNATE""cairo""REGIONCITY""city center""STREET""16 street""BUILDINGNUMBER""14BN""POSTALCODE""74235""FLOOR""1F""ROOM""3R""LANDMARK""tahrir square""ADDITIONALINFORMATION""talaat harb street""DEVICESERIALNUMBER""Sofy123""SYNDICATELICENSENUMBER""1000056""ACTIVITYCODE""4620""BUYER""TYPE""F""ID""313717919""NAME""taxpayer 1""MOBILENUMBER""+201020567462""PAYMENTNUMBER""987654""ITEMDATA""ITEMDATA""INTERNALCODE""880609""DESCRIPTION""Samsung A02 32GB_LTE_BLACK_DS_SM-A022FZKDMEB_A022 _ A022_SM-A022FZKDMEB""ITEMTYPE""GS1""ITEMCODE""037000401629""UNITTYPE""EA""QUANTITY""35""UNITPRICE""247.96000""NETSALE""7810.74000""TOTALSALE""8678.60000""TOTAL""8887.04360""COMMERCIALDISCOUNTDATA""COMMERCIALDISCOUNTDATA""AMOUNT""867.86000""DESCRIPTION""XYZ""ITEMDISCOUNTDATA""ITEMDISCOUNTDATA""AMOUNT""10""DESCRIPTION""ABC""ITEMDISCOUNTDATA""AMOUNT""10""DESCRIPTION""XYZ""VALUEDIFFERENCE""20""TAXABLEITEMS""TAXABLEITEMS""TAXTYPE""T1""AMOUNT""1096.30360""SUBTYPE""V009""RATE""14""TOTALSALES""8678.60000""TOTALCOMMERCIALDISCOUNT""867.86000""TOTALITEMSDISCOUNT""20""EXTRARECEIPTDISCOUNTDATA""EXTRARECEIPTDISCOUNTDATA""AMOUNT""0""DESCRIPTION""ABC""NETAMOUNT""7810.74000""FEESAMOUNT""0""TOTALAMOUNT""8887.04360""TAXTOTALS""TAXTOTALS""TAXTYPE""T1""AMOUNT""1096.30360""PAYMENTMETHOD""C""ADJUSTMENT""0""CONTRACTOR""NAME""contractor1""AMOUNT""2.563""RATE""2.3""BENEFICIARY""AMOUNT""20.569""RATE""2.147"')
,'SHA256') as standard_hash_SHA256
FROM DUAL;
and The Result I Got Was E1F20DB1DB2C79B84C823CFB0F9B8C89BF3FAD367CD732CEFB3E9AEAFD2E3F8B
and here I have two questions :
The 1st Question : In Step Number 6 They Said "Convert the hash value from array of 32 bytes to hexadecimal string of 64 characters"
But I Already Got The 64 Character when I run The previous SQL
The 2nd Question : On Their Application The rsult of the SQL should be 65e952fae3e93f64441433bb72eaa6d4d038945fc132e6e8ae3d3444c5d26a50
So please advise what i have to do to get the same result for uuid for the data in the above SQL
with LiveSQL Test Case:
https://livesql.oracle.com/apex/livesql/s/o8fmjsynr77byq5fg1vkelwcg