EBI 9.2: When EDI Bill Is Generated, the XML File Is Missing Decimals and Zeros When the Billing Amount Has No Pennies.
(Doc ID 2958337.1)
Last updated on SEPTEMBER 16, 2024
Applies to:
PeopleSoft Enterprise SCM Billing - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When EDI Bill is generated, the XML file is missing decimals and zeros when the billing amount has no pennies.
Example: BI_HDR.INVOICE_AMOUNT = 2764.00 but the xml BI_XHDR_TAO INVOICE_AMOUNT will have 2764) per the xml standard, no decimal provided assumes a decimal and amount is 27.64). However, if amount do have pennies, the xml is inserting the decimal (Example BI_HDR_INVOICE_AMOUNT = 2764.99, xml BI_XHDR_TAO INVOICE_AMOUNT will have 2764.99).
REPLICATION STEPS:
----------------------------
1. Setup integration broker for BILLING_INVOICE_NOTICE. ( PeopleTools - Integration Broker - Integration setup - service operation)
2. Setup customer contact for XML and print. Populate document id as XML and print for INVC and INVN document id. (Customer - contact information )
3. Create the bill as EDI invoice media.= and the amount as the whole number as 100.00. ( Billing - Maintain bills - Stanadard Bills )
4. Run finalize and print. ( Billing- Generate Invoices - Non-consolidated - Finalize and Print)
5: Run IN_PUB_MESSESSAGE for Billing invoice notice from SCM integration - publish outbound message.
6. Review XML the amount is 100 not 100.00.
Changes
The issue was reported and analysed for 9.2 PUM 35 Tools 8.58.03
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |