Payables and Cash Management - EBS (MOSC)

MOSC Banner

Modifications to iby_fd_extract_ext_pub not getting reflected in xml

edited Jan 3, 2017 2:57PM in Payables and Cash Management - EBS (MOSC) 3 commentsAnswered

Hi

To get Remittance information, added Extra sql in function Get_Pmt_Ext_Agg of package  iby_fd_extract_ext_pub,

if I execute sql through sql developer for payment_id able to see data in sql developer. But in output in xml getting blank tags.

Would like to know how this issue can be addressed.  details of sql used given below

SELECT DISTINCT aia.INVOICE_NUM

             , decode(aia.invoice_type_lookup_code,'STANDARD','CINV','CREDIT','CREN','DEBIT','DEBN')

             , aia.invoice_date  

             , aia.invoice_amount

             , aia.discount_amount_taken

             , TO_CHAR(aipa.creation_date,'YYYYMMDD')

             , idpa.document_description             

             , iba.payment_amount                    

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