Categories
- All Categories
- Oracle Analytics Learning Hub
- 17 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 224 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 84 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How can we allow both Purchaser and sellers' LE to search Intrastat transactions?

Hi
Since we have business between EU Country So there will be Intrastat Transactions in system. The customer will purchase goods from DE BU but shipped from the Warehouse (location in Netherland) belongs to UK. There are intercompany transactions between UK an DE and also external Transactions between DE and customer.
For this scenario, we have developed a custom Intrastat report based on Oracle standard Intrastat report process. So, the Oracle background table “JMF_IN_STATISTICS” is used as many fields source. Currently we can only get the data from UK legal entity since there isn't DE Intrastat Transactions in the Oracle background table “JMF_IN_STATISTICS”.
Could you please help provide the method how can we get the Intrastat transaction from DE in the Oracle background table “JMF_IN_STATISTICS”? Since it is the transaction between UK and DE, so we also want to get Intrastat Transactions under Legal Entity DE. But in our system, we can only get the Intrastat Transactions from UK.
I have also updated the attachment of configuration for your reference.
Answers
-
0