INVOICE_PAYMENT_ID in XLA tables
Hi Guru's
I am in process of upgrading the project from 11i to R12.
Here i am facing some issue like one of my program is extracting the information from GL to AP.
In 11i, In case of AP PAYMENTS the table GL_IMPORT_REFERENCES has both the column like CHECK_ID(REFERENCE_3) and INVOICE_NUM (REFERENCE_5).
But In R12, we can't find these field in GL_IMPORT_REFERENCES.
In XLA_TRANSACTION_ENTITY table SOURCE_ID_INT_1 gives the CHECK_ID details, but anywhere i can't find INVOICE_NUM details.
If we are tying to get the invoice_num info from check_id, then it is only possible if payment is done only for one invoice.
I am in process of upgrading the project from 11i to R12.
Here i am facing some issue like one of my program is extracting the information from GL to AP.
In 11i, In case of AP PAYMENTS the table GL_IMPORT_REFERENCES has both the column like CHECK_ID(REFERENCE_3) and INVOICE_NUM (REFERENCE_5).
But In R12, we can't find these field in GL_IMPORT_REFERENCES.
In XLA_TRANSACTION_ENTITY table SOURCE_ID_INT_1 gives the CHECK_ID details, but anywhere i can't find INVOICE_NUM details.
If we are tying to get the invoice_num info from check_id, then it is only possible if payment is done only for one invoice.
Tagged:
0